Associate Accountant, Data Analytics

Lawrence Berkeley National Laboratory is hiring an Associate Accountant, Data Analytics within the Office of the Chief Financial Officer. Reporting to the Controller's Office Manager, the Associate Accountant is a rotational position responsible for financial accounting functions in compliance with applicable policies.

This role bridges finance and technology by collecting, cleaning, and analyzing financial data to produce actionable insights, reports, and dashboards. The incumbent will utilize SQL, Excel, and data visualization tools to reconcile accounts, detect trends, and automate workflows supporting strategic decision-making.

Key responsibilities:

Accounting, Operations, and Reporting

• Execute and monitor financial transactions and processes.
• Prepare financial statement analysis including responsibility for certain general ledger account reconciliations; acting in the capacity of a preparer.
• Prepare financial statement reporting for both internal audiences; acting in the capability of a preparer.
• Research and correct irregularities in system output results and/or reconciliations, with oversight from a more senior accountant or their manager.
• Assisting with monthly and year-end close related activities.
• Utilize computer databases (PeopleSoft FMS) to obtain financial information.
• Assist with automating manual accounting workflows, enhancing data integrity, and improving efficiency within accounting systems.
• Ensure compliance with financial regulations (GAAP) and supporting audit processes.

Data Analysis & Visualization

• Assist with analyzing financial datasets to identify trends, patterns, and discrepancies; developing, maintaining, and automating reports and dashboards and utilize tools to identify trends and support data-driven decision-making.

Required qualifications:

• Bachelor's Degree in Business Administration, Accounting, Finance, or related field and/or equivalent training and experience and 0-1 years of professional-level experience.
• Experience in the development and maintenance of moderately financial spreadsheets and databases containing some advanced functions and experience in utilizing commercial and/or institutional financial tools.

Accounting Knowledge

• Knowledge of and understanding of accounting principles, financial statements, and GAAP.
• Knowledge of methods to interpret and apply financial policies and procedures including the use of generally accepted financial principles and methodologies.
• Knowledge of methods to perform financial functions including: preparation and posting of journal entries, balance sheet reconciliations, financial statement analysis, financial report preparation and variance analysis.

Technical Proficiency

• Ability to use Excel (VLOOKUPs, Pivot Tables, Macros) are essential. Knowledge of data visualization tools (e.g., Tableau, Power BI, SQL) and ability to learn ERP systems (e.g., PeopleSoft, Oracle).

Communication

• Knowledge of methods for effective communication skills, both written and verbal Knowledge of methods to utilize interpersonal skills to effectively work with others.

Analytical & Problem-Solving

• Ability to interpret data, conduct analysis, and provide actionable insights.
• Knowledge of methods to research, interpret, analyze, compile, and present data and information
• Knowledge of methods related to decision making, problem-solving and analytical.
• Knowledge of data analytics to help search data and help analyze.

Additional information:

• Application date: Priority consideration will be given to candidates who apply by May 29, 2026. Applications will be accepted until the job posting is removed.
• Appointment type: This is a full-time career appointment, exempt (monthly paid) from overtime pay.
• Salary range: The expected salary for this position is $71,280 - $83,160. The final salary depends upon the candidate's skills, knowledge, and abilities. This includes education, certifications, and years of experience.
• Background check: This position is subject to a background check. Any convictions will be evaluated to determine if they directly relate to the responsibilities and requirements of the position. Having a conviction history will not automatically disqualify an applicant from being considered for employment.
• Work modality: This position is eligible for a hybrid work schedule - a combination of teleworking and performing work on site at Lawrence Berkeley National Lab, 1 Cyclotron Road, Berkeley, CA. Work schedules are dependent on business needs. Individuals working a hybrid schedule must reside within 150 miles of Berkeley Lab.

Want to learn more about working at Berkeley Lab? Please visit: careers.lbl.gov

Equal Employment Opportunity Employer: The foundation of Berkeley Lab is our Stewardship Values: Team Science, Service, Trust, Innovation, and Respect; and we strive to build community with these shared values and commitments. Berkeley Lab is an Equal Opportunity Employer. We heartily welcome applications from all who could contribute to the Lab's mission of leading scientific discovery, excellence, and professionalism. In support of our rich global community, all qualified applicants will be considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories under State and Federal law.

Misconduct Disclosure Requirement: As a condition of employment, the finalist will be required to disclose if they are subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct, are currently being investigated for misconduct, left a position during an investigation for alleged misconduct, or have filed an appeal with a previous employer.