Lawrence Livermore National Laboratory (LLNL) is looking for an HR Data Analyst to build advanced reporting and analytics solutions that drive workforce decisions across HR, strengthening the United States’ security.
Requirements
- Advanced SQL for data extraction, transformation, and validation; strong data modeling fundamentals.
- Hands-on experience building and maintaining HR reports in Oracle HCM (OTBI and/or BI Publisher) or a comparable enterprise HCM reporting platform.
- Proficiency with MicroStrategy (or similar BI) for dashboard design, interactivity, and performance tuning.
- Strong understanding of HR data structures (recruiting, job/position, workforce movement, compensation, org hierarchy) and experience validating/reconciling data across multiple systems and supporting UAT/testing.
- Advanced proficiency in SQL, data modeling, and Oracle HCM reporting (OTBI/BI Publisher).
- Experience designing complex dashboards with strong UX and interactivity principles in MicroStrategy (or equivalent BI tools).
- Practical experience applying statistical or predictive methods (e.g., regression, time series, clustering, forecasting, risk scoring) using Python, R, or Alteryx.
Responsibilities
- Lead end-to-end development of enterprise workforce analytics products and dashboards (e.g., attrition, internal mobility, retirement risk) from intake and scoping through delivery to Laboratory leadership.
- Experience building and maintaining HR operational and analytical reports in Oracle HCM (OTBI, BI Publisher) and related LAPIS datasets using SQL and subject areas to support TA, Compensation, HRBPs, ER, and other HR functions.
- Own data validation and reconciliation across Oracle, LAPIS, and MicroStrategy, performing structured data quality checks, documenting logic, and partnering with IT to resolve discrepancies.
- Translate ambiguous business questions into clear technical reporting requirements, ensuring alignment with HR stakeholders and system capabilities.
- Proactively identify emerging workforce trends, risks, and opportunities, collaborating with HR and leaders to frame analytic questions that directly support business and workforce decisions.
- Design and evolve user-friendly, scalable BI solutions in tools such as MicroStrategy, Power BI, or Tableau, enabling self-service access to trusted metrics and insights.
- Support system testing and user acceptance testing (UAT) during Oracle HCM implementations and releases, validating report outputs and documenting issues.
Other
- Must be eligible to access the Laboratory in compliance with Section 3112 of the National Defense Authorization Act (NDAA).
- Bachelor’s degree in a quantitative or related field (or equivalent experience).
- Must pass a post-offer, pre-employment drug test.
- U.S. person (U.S. citizen, U.S. lawful permanent resident, U.S. national, or U.S. protected individual) due to U.S. Export Control.
- Ability to work in a Flexible Term appointment, which is for a definite period not to exceed six years.
