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 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

Brookhaven National Laboratory requires all non-badged personnel including visitors to produce a REAL-ID or REAL-ID compliant documentation to access Brookhaven National Laboratory – view more information at www.bnl.gov/real-id. This is due to nationwide identification requirements for federal site access as required by the federal REAL ID Act. Those not in possession of a REAL ID-compliant document will not be permitted to access the site which includes access to the Laboratory for interviews.

As a U.S. Department of Energy laboratory, Brookhaven National Laboratory requires employees to obtain and maintain a DOE Uncleared Personal Identity Verification (UPIV) credential in accordance with Homeland Security Presidential Directive 12 (HSPD-12) requirements. The credentialing process is completed as part of onboarding and enables access to DOE facilities and information systems. As a condition of employment, the selected candidate must be able to obtain and maintain a UPIV credential. These requirements are established under DOE Order 206.2 Chg. 2, Identity, Credential, and Access Management (ICAM- Identity, Credential, and Access Management (ICAM)), and DOE Order 473.1A- Physical Protection Program- Physical Protection Program.

About Us

Brookhaven National Laboratory (www.bnl.gov) delivers discovery science and transformative technology to power and secure the nation’s future. Brookhaven Lab is a multidisciplinary laboratory with seven Nobel Prize-winning discoveries, 37 R&D 100 Awards, and more than 70 years of pioneering research. The Lab is primarily supported by the U.S. Department of Energy’s (DOE) Office of Science. Brookhaven Science Associates (BSA) operates and manages the Laboratory for DOE. BSA is a partnership between Battelle and The Research Foundation for the State University of New York on behalf of Stony Brook University. BSA salutes our veterans and active military members with careers that leverage the skills and unique experience they gained while serving our country, learn more at BNL | Opportunities for Veterans at Brookhaven National Laboratory.

Equal Opportunity/Affirmative Action Employer

Guided by our core values of integrity, responsibility, innovation, respect, and teamwork, Brookhaven Science Associates is an Equal Employment Opportunity Employer-Vets/Disabled. We are committed to fostering a respectful and collaborative environment that fuels scientific discovery. We consider all qualified applicants without regard to any characteristic protected by law. All qualified individuals are encouraged to apply. We ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation. *VEVRAA Federal Contractor

BSA employees are subject to restrictions related to participation in Foreign Government Talent Recruitment Programs, as defined and detailed in United States Department of Energy Order 486.1A. You will be asked to disclose any such participation at the time of hire for review by Brookhaven. The full text of the Order may be found at: https://www.directives.doe.gov/directives-documents/400-series/0486.1-BOrder-a/@@images/file