Business Specialist - Upton, NY
Company: Msccn
Location: Mount Upton
Posted on: April 1, 2026
|
|
|
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. 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 proposalsl 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.
Keywords: Msccn, Utica , Business Specialist - Upton, NY, Accounting, Auditing , Mount Upton, New York
