Junior Data Analyst

Reporting to the Business Assurance Manager, this foundation level role within the Business Assurance group provides reporting and data analytics support to the Procurement Department. Under general supervision, the Analyst will apply basic principles, theories, and concepts to bridge procurement business reporting needs and technology by collecting, cleaning, and analyzing financial data to produce actionable insights, financial reports, and dashboards. This position will use SQL, Excel, and data visualization tools to analyze data, detect trends and anomalies, and help the procurement organization in the decision support and strategic decision making by creating and or updating queries/reports/dashboards etc.

The Junior Data Analyst will engage with the Business Systems Group in understanding the OCFO's Business Systems and related data architecture, tables and reporting options.

What Success Looks Like:

• Precision: Take pride in data integrity and accuracy.
• Efficiency: Look for ways to automate repetitive manual reporting, freeing up time for deeper exploratory analysis.
• Curiosity: Don't just deliver a chart; ask follow-up questions that help the business pivot or grow.
• Collaboration: Translate data into plain English for scientific division and operations' teams.

As a Junior Data Analyst, you are the "first responder" to data queries, and data deliverables for the Procurement Department to the Department of Energy or University of California.

You will:

• 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.
• Support the department in transforming raw data into actionable insights. The primary focus is on data maintenance, basic reporting, and assisting senior analysts with moderate Division projects.
• Assist in gathering data from database sources. Perform regular data "hygiene" to identify, troubleshoot, and correct errors or inconsistencies in datasets.
• Develop and maintain automated reports and dashboards using LBNL supported tools to track key performance indicators (KPIs).
• Submit data reports to the Compliance team for DOE and UC reporting requirements.
• Perform initial analysis to identify trends, correlations, and patterns in structured and unstructured data.
• Maintain clear documentation of data definitions, analysis methodologies, and reporting processes to ensure data integrity across the organization.
• Work alongside different departments to understand their data needs and provide basic analytical support for their specific queries.

We are looking for:

• A Bachelor's degree in Data Science, Statistics, Mathematics, Economics, Computer Science, or a related field, and a minimum of one year of professional experience in related fields.
• 1 year of experience in a data-related role with a solid foundational background in quantitative fields.
• Experience (through coursework or projects) using SQL to query databases and Excel for advanced data manipulation (VLOOKUPs, Pivot Tables).
• Internships, capstone projects, or a verifiable portfolio that demonstrates the ability to handle real-world data.
• Basic to intermediate knowledge of SQL (joins, subqueries, and data cleaning).
• Familiarity with programming languages for data analysis
• Exposure to data visualization tools (e.g., Power BI, Tableau, or Google Looker Studio).
• The ability to break down a complex problem into smaller, manageable parts and approach it with a logical, step-by-step methodology.
• Strong verbal and written communication skills, with the ability to explain technical findings to non-technical stakeholders clearly.
• An obsessive eye for accuracy--ensuring that the "small numbers" add up before they reach the final report.
• A "growth mindset" and a willingness to learn new tools and industries as the company's data needs evolve.
• 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.

Desired skills/knowledge:

• Experience using and troubleshooting PeopleSoft financials and supply chain management applications release 9.0 or higher.
• Experience using PeopleSoft Query and SQL, Cognos reporting tools
• Experience working for a large, Federal direct- and grant-funded research organization.
• Professional certification or advanced education in management information systems, PeopleSoft Financials and Supply Chain 9.0 higher, and Reporting/Data Analytics applications like Cognos 12, Power BI, Google Analytics.

Additional information:

• Application date: Priority consideration will be given to candidates who apply by June 23, 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 budgeted salary range for this position is $74,163 - $86,524 depending 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: Work will be primarily performed at: Lawrence Berkeley National Lab, 1 Cyclotron Road, Berkeley, CA. A REAL ID or other acceptable form of identification is required to access Berkeley Lab sites (for more information click here).
• Work authorization: This position is eligible for full-time telework. Individuals on a full-time telework schedule must reside within 150 miles of Berkeley Lab.