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 ReportingExecute 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 & VisualizationAssist 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 KnowledgeKnowledge 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 ProficiencyAbility 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).CommunicationKnowledge of methods for effective communication skills, both written and verbal Knowledge of methods to utilize interpersonal skills to effectively work with others.Analytical & Problem-SolvingAbility to interpret data, conduct analysis, and provide actionable insights.Knowledge of methods to research, interpret, analyze, compile, and present data and informationKnowledge 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.