Senior Analyst, Workforce Analytics

Stanford University; Palo Alto (CA); On-site; USD 110,000 - 140,000; Full time

Job summary

Stanford Medicine is seeking a Senior Analyst, Workforce Analytics — Data, Reporting & BI. This role partners with the Director of Workforce Analytics to design scalable BI solutions and deliver trusted workforce insights.

Responsibilities include reporting, data governance, dashboard development, data integration, and applying AI to improve efficiency. Strong Tableau/SQL skills, Python/R, and experience with Databricks are highly valued.

Qualifications

• Master’s degree in a technical discipline is preferred.
• Strong knowledge of workforce or HR data, metrics, and reporting practices.
• Experience with HR technology platforms (e.g., Oracle HCM, Workday, SuccessFactors).
• Demonstrated expertise in Tableau, with dashboards and advanced calculations.
• Proficiency with SQL for querying and analyzing data.
• Experience transforming, integrating, validating, and analyzing large datasets for reporting.
• Experience automating recurring data, reporting, and analytics processes.
• Hands-on experience using Python, R, or similar tools is a plus.
• Databricks and data governance tools are a plus.
• Strong stakeholder consulting skills and ability to communicate technical concepts.

Responsibilities

• Define and drive investigations to produce reports from structured data.
• Develop methods for identifying data patterns and trends.
• Create meaningful reports illustrating key findings.
• Lead end-to-end BI initiatives from requirements to rollout.
• Oversee data governance and data quality initiatives.
• Educate stakeholders on workforce analytics tools and promote data literacy.
• Leverage AI to enhance analytics, automation, and self-service reporting.

Skills

Tableau

SQL

Python/R

Data governance

Data storytelling

Stakeholder consulting

Generative AI

Education

Bachelor’s degree

Master’s degree preferred

Tools

Databricks

Collibra

Oracle HCM

Workday

SuccessFactors

Job description

Stanford Medicine is fueling discovery and innovation to advance human health.

Rooted in our mission to be a premier research-intensive medical institution, the Stanford University School of Medicine (SoM) improves health through leadership, diversity, collaborative discoveries, and innovation in education, patient care, and research. Whether working in departments with faculty or in units that support the school, our staff propel us toward the future of medicine and Precision Health. We are transforming health care from reactive diagnosis to proactive prediction and prevention and from one-size-fits-all medicine to personalized care that empowers people to lead healthy lives.

Join the Human Resources Group (HRG), a department within the School of Medicine’s Dean’s Office, providing best-in-class people services and solutions that deliver value to our customers and cultivate leaders at all levels of the organization. Working closely with the School's academic departments, institutes, centers and administrative units, we lead in creating and maintaining a work environment that attracts, develops, rewards and retains a highly-engaged, talented, productive and diverse workforce in support of Stanford Medicine: Leading the Biomedical Revolution in Precision Health.

We have an exciting new opportunity and invite applications for the position of Senior Analyst, Workforce Analytics — Data, Reporting & BI. We are seeking a dynamic, well-rounded analytics professional who can perform complex technical and analytical work to address workforce and business needs. Reporting to the Director of Workforce Analytics, your responsibilities will span workforce data, reporting, BI, and analytics to deliver trusted information and actionable insights that inform School of Medicine’s workforce strategies and decision-making.

If you are passionate about transforming workforce data into trusted, scalable reporting and analytics solutions that inform talent strategies, support organizational transformation, and enable better decision-making, this opportunity is for you!

Duties include:

• Develop and maintain complex business intelligence solutions, including workforce reports, dashboards, scorecards, KPIs, metrics, and ad hoc analyses, with a focus on scalable reporting. Query, clean, transform, and integrate data from multiple sources to deliver accurate, actionable information and support organizational decision-making.
• Lead complex workforce reporting and business intelligence initiatives end-to-end, from requirements gathering and solution design through development, validation, implementation, and ongoing support.
• Originate and coordinate data governance/stewardship assignments.
• Develop and maintain documentation for data, reporting, analytics, and related processes.
• Participate in user acceptance testing of new BI analysis and reporting systems, upgrades, enhancements and change requests; plan, conduct and document results of testing.
• Define and drive areas of investigations to assess and produce relevant, standard, or custom information (reports, charts, graphs, and tables) from structured data sources by querying data repositories and generating the associated information, including summary interpretations of results.
• Develop and design methods for identifying data patterns and trends in available information sources using a variety of qualitative and quantitative techniques. Proactively suggest areas of investigation.
• Design and create meaningful reports that effectively illustrate key findings within the data. Identify and recommend strategic data collection and reporting requirements. Effectively convey findings and recommendations to varied audience groups and senior leadership.
• Provide subject matter expertise for ad-hoc projects and inquiries (e.g., requests for statistical analyses or surveys).
  Lead and/or collaborate with technical staff, project teams or vendors to develop standardizing processes and systemize routine reports, dashboards, and metrics.
  Validate data, analyses, and outputs for accuracy, identify anomalies, and investigate data quality issues.
• Leverage generative AI and emerging technologies to enhance analytical work, automation, and productivity, and identify opportunities to improve reporting and self-service analytics.
• Educate and train stakeholders on workforce analytics tools and promote data literacy, including effective use and interpretation of workforce data.

* - Other duties may also be assigned

Desired Qualifications:

• Master’s degree in a technical discipline (Statistics, Economics, Finance, Operations Research, Engineering, Mathematics, Psychology, Computer Science, MBA, Information Systems, Biology, Physics, Analytics, Data Science or similar area) is preferred.
• Strong knowledge of workforce or HR data, metrics, and reporting practices preferred.
  Experience working with HR technology platforms (e.g., Oracle HCM, Workday, SuccessFactors); Oracle HCM experience preferred.
• Demonstrated expertise in Tableau, with substantial hands-on experience independently designing and developing complex, interactive dashboards, including advanced calculations, parameters, level-of-detail expressions, and row-level security.
• Proficiency with SQL for querying and analyzing data.
• Demonstrated experience transforming, integrating, validating, and analyzing large, complex datasets from multiple data sources for reporting and analytics.
• Experience automating and streamlining recurring data, reporting, and analytics processes to improve efficiency.
• Hands-on experience using Python, R, or similar analytical tools is a plus.
• Experience working with modern cloud-based data and analytics platforms such as Databricks is a plus.
• Familiarity with data governance or data catalog tools, such as Collibra, is a plus.
• Strong stakeholder consulting skills, with the ability to understand business needs, translate requirements into effective data and reporting solutions, and communicate technical concepts to varied audiences.
• Experience with or interest in applying generative AI and emerging AI technologies to workforce analytics and related processes.
  

Responsibilities

Core Duties

• Define and drive areas of investigations to assess and producerelevant, standard, or custom information (reports, charts, graphics, andtables) from structured data sources by querying data repositories andgenerating the associated information, including summary interpretationsof results.

• Develop and design methods for identifying data patterns andtrends in available information sources using a variety of qualitativeand quantitative techniques. Proactively suggest areas ofinvestigations.

• Design and create meaningful reports that effectively illustratekey findings within the data. Identify and recommend strategic datacollection and reporting requirements. Effectively convey findingsandrecommendations to varied audience groups and seniorleadership.

• Create non-routine databases and generate related informationsummaries. Develop innovative algorithms and statistical models to helpwith finding key insights.

• Perform advanced statistical analyses that are appropriate forcomplex datasets and reporting requirements.

• Provide subject matter expertise for ad-hoc projects andinquiries (e.g., requests for statistical analyses or surveys).

• Direct and drive the implementation of data standards and commondata elements for data collection.

• Lead and/or collaborate with technical staff, project teams orvendors to develop standardizing processes and systemize routinereports, dashboards, and metrics.

• May lead testing of prototype software and participate in theapproval and release process for new software.

• May oversee or supervise staff in the development andimplementation of programs or functions.

Minimum Education:

Bachelor’s degree.

Minimum Experience:

Five years of relevant experience or combination of education andrelevant experience. Experience in a quantitative discipline such aseconomics, finance, statistics, or engineering.

Knowledge, Skills and Abilities:

• Advanced experience applying analytical software, databasemanagement system software, database reporting software, database userinterface and query software, and data mining software.

• Advanced ability to collect data using a variety of methods, suchas data mining and hardcopy or electronic documentation study, to improve or expand databases.

• Advanced experience utilizing complex statistical tools and techniques.

• Considerable interpersonal and communication skills toeffectively convey findings and recommendations to a wide variety ofaudiences and influence senior leadership & faculty in keydecisions.

• Ability to manage multiple activities in a deadline-orientedenvironment; highly organized, flexible, and rigorous attention todetail.

• Ability to use logic to calculate data; efficiently construct adatabase or scrutinize the form of a question.

• Ability to work with data of varying levels of complexity,quality, and validity.

• Demonstrated ability to produce data in a clear andunderstandable manner meeting user requirements.

• Effectively manage multiple requests from internal and externalcustomers.

• Demonstrated experience in leading projects withusers/clients.