Business Specialist - Upton, NY

Job Description

ATTENTION MILITARY AFFILIATED JOB SEEKERS: Our organization works with partner companies to source qualified talent for their open roles. The following position is available to Veterans, Transitioning Military, National Guard and Reserve Members, Military Spouses, Wounded Warriors, and their Caregivers
. If you have the required skill set, education requirements, and experience, please click the submit button and follow the next steps. Unless specifically stated otherwise, this role is "On-Site" at the location detailed in the job post.

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.

• 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 People Soft 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.

466858

High School/GED

Finance

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