Workforce Analyst

Job Description

Certain terms and conditions of employment for this position, including the rate of pay, benefits, etc., are currently subject to negotiation with the appropriate union.

As part of the People Analytics team, the workforce analyst supports workforce reporting, analytics, and metric development activities that inform operational and strategic decision-making across UCSF. Working under the direction of the Director of People Analytics, the incumbent partners with analysts, engineers, and business stakeholders to investigate workforce questions, develop workforce metrics, conduct analyses, and deliver reporting solutions that support organizational priorities.

Working under the direction of the Director of People Analytics, the the technically-oriented workforce analyst will support leadership requests, develop metrics, conduct analyses, and operationalize business questions into reporting and analytics products.

This role will touch upon the broad portfolio of People Analytics domains, including workforce demographics, workforce movement, human resources operational analytics, occupational health, learning and compliant, engagement, and other workforce-related initiatives.

Working closely with data architects, analysts, and business stakeholders, the incumbent contributes to analytic solution design, validates outputs, and translates workforce requirements into technical solutions. The position requires strong technical skills, sound judgment, and the ability to independently execute complex assignments while escalating novel architectural, governance, or enterprise-wide decisions to senior team members. The analyst independently executes assigned analyses and reporting projects while receiving guidance on prioritization, stakeholder management, and novel or highly complex analytical problems.

The mission of the Enterprise Information and Analytics (EIA) department is to advance UCSF’s institutional priorities by enhancing access to and the use of data and analytics, including appropriate data platforms and data governance, in a manner that meets the unique needs across the education, research, and care mission areas. The department achieves its goals by working with clinical, research, education, and business partners to organize, integrate, govern, and transform UCSF’s data assets into actionable insight and information.

People Analytics owns enterprise-wide assets for UCSF as a whole, used for both operational and analytical purposes, as well as departmental and business assets to drive business insights and decisions.

• Data Consultation:
  Consult with department leaders and process owners, and/or external providers to identify/source multiple data streams, derive and define analytics & data reporting that meet business needs.
• Technical:
  Develop TSQL queries to marry disparate data sources that inform recommendations to support and enhance business processes. Prepare reporting on AI-augmented platforms such as PowerBI, Tableau, Databricks.
• Process/Workflow Efficiency:
  Plan work flows and processes surrounding the analysis of data. Identify additional efficiencies to enhance work flow or extract more value from existing data tools. Identify tools to optimize workflow without compromising analytics.
• Documentation:
  Document analytics approaches to allow for validation and replication.
• Sustainability:
  Work with People Analytics engineering team to ensure processes are scalable, flexible, and within governed parameters (security, enterprise standards) to meet future business needs.

• Data extraction:
  Establish efficient and effective procedures for extracting and storing data from multiple sources to analyze and present the data based on industry standards, with drill down analysis based on data subsets and populations.
• Collection/Querying methods:
  Manage and maintain library of complex forms, queries, reports, scripts. Update/merge data using data extracts.
• Documentation:
  Document data collection procedures and sources. Develop and maintain a well-organized source data repository that can be accessed by business process owners…