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. 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 per year. Salary offers will be commensurate with the final candidate's qualification, education, and experience and considered with the internal peer group. 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 #J-18808-Ljbffr Brookhaven National Laboratory