Business Specialist

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, Digital Transformation 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.

Other Information:

• Visa Sponsorship is not available for this position.

• This is an onsite position located in Upton, New York.

Compensation:

Brookhaven Laboratory is committ