IT Workforce Analyst

University of California - San Francisco; San Francisco (CA); On-site; USD 90,000 - 150,000; Full time

Job summary

University of California, San Francisco (UCSF) is seeking a data-driven workforce analyst within the People Analytics team. You will explore workforce metrics, develop reporting solutions, and partner with engineers to productionize analytics assets.

The role touches demographics, mobility, learning, compliance, and other workforce initiatives. You will interface with data architects, analysts, and stakeholders to refine business rules, write maintainable SQL, and translate requirements into

Qualifications

• Bachelor's degree in a related area or equivalent experience.
• 2+ years of experience developing complex SQL queries and working with structured data.
• 2+ years of experience developing reports from large data sets.
• Experience translating business questions into analytic approaches and actionable recommendations.
• Familiarity with dimensional modeling concepts and data transformation techniques.
• Strong communication, time management, and collaboration skills.

Responsibilities

• Develop and refine analytics and data reporting to meet business needs.
• Create and optimize complex SQL queries to join disparate data sources.
• Produce reports on AI-augmented platforms such as PowerBI, Tableau, Databricks.
• Document analytics approaches to enable validation and replication.
• Ensure scalable and governed production data products with engineering partners.
• Develop ad hoc reports based on external and internal report specs.
• Communicate findings clearly to internal and external audiences.
• Collaborate with cross-functional teams to define objectives and data needs.

Skills

SQL

Python

Analytical thinking

Communication

Problem solving

Education

Bachelor's degree

Tools

Tableau

Power BI

Databricks

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 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.

Key Responsibilities

• 30%: 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.
• 30%: Technical: Develop and refine complex TSQL queries to marry disparate data sources that inform recommendations to support and enhance business processes. Optimize query performance and prepare analytical code for production implementation by the engineering team. Prepare reporting on AI-augmented platforms such as PowerBI, Tableau, Databricks.
• 30%: 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.
• 30%: Documentation: Document analytics approaches to allow for validation and replication.
• 30%: 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.
• 20%: 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.
• 20%: Collection/Querying Methods: Manage and maintain library of complex forms, queries, reports, scripts. Update/merge data using data extracts.
• 20%: Documentation: Document data collection procedures and sources. Develop and maintain a well-organized source data repository that can be accessed by business process owners for additional review and analysis.
• 20%: Validation: Ensure data from various sources is reconciled and accurately presented in workforce analytic tools.
• 20%: Identify and Repair Errors: Analyze and troubleshoots data errors and problems, and devise functional solutions.
• 20%: Code Quality: Produce readable, well-documented, modular SQL and analytical code following team standards to facilitate peer review, engineering handoff, and long-term maintainability. Partner with People Analytics engineers to transition analytical prototypes into governed production solutions. Contribute technical documentation, business rule definitions, testing, and validation to support scalable enterprise data products.
• 20%: Develop Ad. Hoc reports based on report specifications from either outside parties (eg. Regulators, Trade organization, and Unions) or internal organizations.
• 20%: Analyze report requirements and determine report data source requirements and establish plan for efficient and effective collection and presentation of data. Ensure accuracy and quality through careful review of report results and clearly document the report specs. When necessary the incumbent works directly with the requestor(s) to clarify the desired outcome and develop adjustments to the report spec accordingly.
• 30%: Business/Strategic alignment Consultation: Consult with UCSF business/operational leaders and process owners to identify business problems that would use analytics to identify pain points and areas of opportunity.
• 30%: Dashboard design: Develop effective presentations of workforce data that depict organizational trends and performance relative to benchmarks and industry standards.
• 30%: General communications: Communicate findings of workforce analyses and insights verbally, visually and in writing to internal and external audiences.
• 30%: Cross-functional: Work with teams outside of HR to define business objectives, data needs, and resulting solutions and analytics.

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. At least 2 years' experience developing and maintaining report specifications in collaboration with business owners.
• 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.

About UCSF

The University of California, San Francisco (UCSF) is a leading university dedicated to promoting health worldwide through advanced biomedical research, graduate-level education in the life sciences and health professions, and excellence in patient care. It is the only campus in the 10-campus UC system dedicated exclusively to the health sciences. We bring together the world's leading experts in nearly every area of health. We are home to five Nobel laureates who have advanced the understanding of cancer, neurodegenerative diseases, aging and stem cells.

Pride Values

UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence - also known as our PRIDE values.

In addition to our PRIDE values, UCSF is committed to equity - both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available here.

Join us to find a rewarding career contributing to improving healthcare worldwide.

Equal Employment Opportunity

The University of California is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected status under state or federal law.

Salary Information

The final salary and offer components are subject to additional approvals based on UC policy.

Your placement within the salary range is dependent on a number of factors including your work experience and internal equity within this position classification at UCSF. For positions that are represented by a labor union, placement within the salary range will be guided by the rules in the collective bargaining agreement.

To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html