Lead Workforce Visualization 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 Lead Workforce Visualization 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.

The incumbent serves as the teams subject matter expert for dashboard user experience information design and analytic addition to leading visualization design the incumbent performs workforce analyses develops metrics writes SQL and analytical logic validates results and partners with engineering to operationalize reporting solutions. The role combines business analysis technical analytics and front-end analytics development to deliver enterprise-quality reporting products.

Working closely with data architects analysts engineers and business stakeholders the incumbent establishes visualization standards promotes consistency across reporting products and contributes to the overall user experience of the People Analytics portfolio while independently executing complex assignments and escalating architectural or governance decisions when appropriate.

Department Overview

The mission of the Enterprise Information and Analytics (EIA) department is to advance UCSFs 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 UCSFs 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

• Bachelors degree in a related area and/or equivalent experience/training.
• At least 2 years of experience working with structured data using SQL and modern analytics platforms (e.g. Tableau Power BI Databricks). Ability to develop analytical logic reusable metrics and reporting solutions from enterprise data models.
• At least 2 years of experience developing dashboards reports or analytical applications from large enterprise data sets using modern business intelligence tools (Power BI Tableau preferred)
• Experience translating business questions into analytic approaches and actionable recommendations. 2 years experience developing and maintaining report specifications in collaboration with business owners.
• 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.
• Experience developing dashboards or interactive reporting solutions using established visualization standards approved templates and user-centered design principles.
• 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 project and achieve results in a fast-paced work environment.
• Ability to balance analytical accuracy usability and visual communication when presenting complex workforce information to technical and non-technical audiences.

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 translating business questions into analytical solutions dashboard requirements and actionable recommendations in collaboration with business stakeholders.
• Experience developing dashboards using Tableau Power BI Tableau Pulse Databricks or similar analytics platforms including implementation of interactive dashboards KPI scorecards and executive reporting.