IT Workforce Analyst

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 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 compliance, engagement, and other workforce-related initiatives. 

Working closely with data architects, analysts, and business stakeholders, the incumbent contributes to analytic solution design, develops reusable business logic, validates outputs, and translates workforce requirements into maintainable technical solutions. The position serves as a bridge between business analysis and data engineering by refining analytic SQL, documenting business rules, preparing data transformation logic, and partnering with engineers to productionize reporting and analytics assets. The analyst independently executes complex assignments while escalating novel architectural, governance, or enterprise-wide decisions to senior team members. 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.

Department Overview 

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. 

REQUIRED QUALIFICATIONS

• Bachelor's degree in a related area and/or equivalent experience/training.
• At least 2 years of experience developing complex SQL queries and working with structured data. Experience writing maintainable, well-organized SQL using joins, CTEs, window functions, and reusable query patterns. Familiarity with Python or similar scripting languages preferred..
• At least 2 years’ experience developing reports from large data sets.
• Experience translating business questions into analytic approaches and actionable recommendations. 2 years’ experience developing and maintaining report specifications in collaboration with business owners. 
• Familiarity with dimensional modeling concepts, logical data design, source-to-target mapping, and data transformation techniques. Experience documenting business logic for implementation by engineering teams. Demonstrated experience using data to solve business problems and support decision-making. 
• Strong problem-solving, critical thinking, and communication skills.
• Proficiency in MS 365 Office Suite, especially Excel.
• Excellent communication, escalation, time management, collaboration, and change management skills. Ability to work both independently and in teams. 
• Experienced in setting priorities across competing demands, clarifying expectations, and sustaining a positive and productive attitude despite swiftly changing priorities and a high level of activity. Ability to complete projects and achieve results in a fast-paced work environment.

PREFERRED QUALIFICATIONS

• Experience working with workforce, HR, healthcare, operational, or compliance-related data.
• Experience developing metrics and KPIs.
• Familiarity with workforce analytics concepts including turnover, mobility, staffing, compliance, and organizational effectiveness.
• Experience with Tableau, Power BI, Databricks, or similar analytics platforms.

Budgeted Job Salary Range: 125,000 - 155,000