Associate Accountant, Data Analytics

Lawrence Berkeley National Laboratory•Berkeley, CA

7h•Hybrid

About The Position

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.

Requirements

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.
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.
Ability to use Excel (VLOOKUPs, Pivot Tables, Macros) are essential.
Knowledge of methods for effective communication skills, both written and verbal
Knowledge of methods to utilize interpersonal skills to effectively work with others.
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.

Nice To Haves

Knowledge of data visualization tools (e.g., Tableau, Power BI, SQL) and ability to learn ERP systems (e.g., PeopleSoft, Oracle).

Responsibilities

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.
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.