The Business Services Directorate (BSD) provides high-quality business services to support the Lab's research initiatives by participating in cross-functional teams with a focus on risk mitigation and cost management, which is a critical component to the Lab's success. Led by the Chief Financial Officer, Brookhaven's Business Services Directorate includes the Budget Office, Fiscal Services Division, Procurement & Property Management Division, Chief Financial Office, and the Business Operations…
Offices. The Directorate manages a broad range of financial activities, including the planning and implementation of the Lab's fiscal matters and its approximately $900 million annual budget.
The Business Services Directorate (BSD) has an opening for a Business Specialist position within the Budget Office. This individual will report to the Assistant Budget Officer for Direct Programs.
Essential Duties and Responsibilities:
- Prepare financial and management reports for laboratory management and DOE using Microsoft Excel and Power BI, with supporting presentations in Microsoft PowerPoint.
- Review and process new funding work authorizations for DOE and non-DOE sources.
- Maintain, enhance, and ensure the accuracy and integrity of existing Power BI reports and dashboards used by the Budget Office.
- Design, develop, and migrate Excel-based, ad hoc, and legacy reports into Power BI, including:
- Requirements gathering;
- Data modeling and validation;
- Documentation of assumptions and methodologies.
- Support the annual DOE Office of Science budget submission process, including:
- Review and submission of approximately 170 proposals
- Reconciliation against PeopleSoft ERP data;
- Preparation of required schedules, estimates, and supporting analyses.
- Reconcile laboratory funding and current balances on DOE and SPP programs.
- Perform month-end and year-end closing activities, including new fiscal year startup.
- Assist with tasks.
- Assist with preparing and maintaining documentation for policies and procedures.
- Perform other recurring and ad hoc duties as assigned.
Required Knowledge, Skills, and Abilities:
- Bachelor's degree in Accounting, Business Administration, Finance, or a directly related field, or equivalent contemporary full-time directly related experience on a 2:1 (experience: college) basis.
- Four (4) years of full-time, directly related experience with progressively increasing responsibility in a business, financial, or budget role.
- Advanced proficiency in Microsoft Excel, including complex formulas and functions (e.g., XLOOKUP, SUMPRODUCT, INDEX/MATCH, nested formulas), pivot tables, goal seek, and data validation.
- Demonstrated experience using Microsoft Power BI, including building, maintaining, and modifying reports and dashboards; working with multiple data sources; and validating results against source systems.
- Knowledge of Generally Accepted Accounting Principles (GAAP) and Government Cost Accounting Standards (CAS) requirements relevant to assigned areas of responsibility.
- Experience extracting, analyzing, and reconciling data from Enterprise Resource Planning (ERP) systems for reporting and decision-making.
- Strong attention to detail and commitment to data accuracy and integrity.
- Strong verbal and written communication skills.
- Proven organizational skills, initiative, and creativity in problem-solving.
- Ability to manage competing deadlines and perform effectively in a fast-paced environment.
- Working knowledge of Office 365 applications, including Outlook, Word, PowerPoint, SharePoint, and Teams.
- Ability to establish and maintain positive working relationships in a multicultural environment.
Preferred Knowledge, Skills, and Abilities:
- Experience with PeopleSoft ERP Financial Applications.
- Knowledge of BNL policies, practices, and procedures.
- Knowledge of ChatGPT; AI; SQL; Power Query.
- Advanced Power BI experience, or similar, including:
- Data modeling concepts;
- DAX;
- Report optimization;
- Lifecycle management of business intelligence products.
Compensation:
Brookhaven Laboratory is committed to providing fair, equitable, and competitive compensation. The full salary range for this position is $82,950 - $124,350 / year. Salary offers will be commensurate with the final candidate's qualification, education, and experience and considered with the internal peer group.
Brookhaven National Laboratory is committed to employee success and we believe that a comprehensive employee benefits program is an important and meaningful part of the compensation employees receive. Review more information at BNL | Benefits Program