Junior Data Analyst

Junior Data Analyst

Lawrence Berkeley National Laboratory is hiring a Junior Data Analyst within the Office of the Chief Financial Officer (OCFO). 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. We're here for the same mission, to bring science solutions to the world. Join our team and YOU will play a supporting role in our goal to address global challenges! Have a high level of impact and work for an organization associated with 17 Nobel Prizes!

Why join Berkeley Lab? We invest in our employees by offering a total rewards package you can count on: Exceptional health and retirement benefits, including pension or 401K-style plans Opportunities to grow in your career - check out our Tuition Assistance Program A culture where you'll belong - we are invested in our teams! In addition to accruing vacation and sick time, we also have a Winter Holiday Shutdown every year. Parental bonding leave (for both mothers and fathers) Pet insurance

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 17, 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: This position is eligible for full-time telework. Individuals on a full-time telework schedule must reside within 150 miles of Berkeley Lab.
• Work authorization: Candidates must be eligible to work in the U.S. at the time of hire. Visa sponsorship is not available for this position.

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.