Only the job description changed.
| Previous Job Description | Current Job Description | ||||
|---|---|---|---|---|---|
| 2 | Certain terms and conditions of employment for this position, including the rate of pay, benefits, e | 2 | Certain terms and conditions of employment for this position, including the rate of pay, benefits, e | ||
| > | tc., are currently subject to negotiation with the appropriate union. As part of the People Analytic | > | tc., are currently subject to negotiation with the appropriate union. As part of the People Analytic | ||
| > | s team, the workforce analyst supports workforce reporting, analytics, and metric development activi | > | s team, the workforce analyst supports workforce reporting, analytics, and metric development activi | ||
| > | ties that inform operational and strategic decision-making across UCSF. Working under the direction | > | ties 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 s | > | of the Director of People Analytics, the incumbent partners with analysts, engineers, and business s | ||
| > | takeholders to investigate workforce questions, develop workforce metrics, conduct analyses, and del | > | takeholders to investigate workforce questions, develop workforce metrics, conduct analyses, and del | ||
| > | iver reporting solutions that support organizational priorities. Working under the direction of the | > | iver reporting solutions that support organizational priorities. Working under the direction of the | ||
| > | Director of People Analytics, the technically-oriented workforce analyst will support leadership req | > | Director of People Analytics, the technically-oriented workforce analyst will support leadership req | ||
| > | uests, develop metrics, conduct analyses, and operationalize business questions into reporting and a | > | uests, develop metrics, conduct analyses, and operationalize business questions into reporting and a | ||
| > | nalytics products. This role will touch upon the broad portfolio of People Analytics domains, includ | > | nalytics products. This role will touch upon the broad portfolio of People Analytics domains, includ | ||
| > | ing workforce demographics, workforce movement, human resources operational analytics, occupational | > | ing workforce demographics, workforce movement, human resources operational analytics, occupational | ||
| > | health, learning and compliance, engagement, and other workforce-related initiatives. Working closel | > | health, learning and compliance, engagement, and other workforce-related initiatives. Working closel | ||
| > | y with data architects, analysts, and business stakeholders, the incumbent contributes to analytic s | > | y with data architects, analysts, and business stakeholders, the incumbent contributes to analytic s | ||
| > | olution design, develops reusable business logic, validates outputs, and translates workforce requir | > | olution design, develops reusable business logic, validates outputs, and translates workforce requir | ||
| > | ements into maintainable technical solutions. The position serves as a bridge between business analy | > | ements into maintainable technical solutions. The position serves as a bridge between business analy | ||
| > | sis and data engineering by refining analytic SQL, documenting business rules, preparing data transf | > | sis and data engineering by refining analytic SQL, documenting business rules, preparing data transf | ||
| > | ormation logic, and partnering with engineers to productionize reporting and analytics assets. The a | > | ormation logic, and partnering with engineers to productionize reporting and analytics assets. The a | ||
| > | nalyst independently executes complex assignments while escalating novel architectural, governance, | > | nalyst independently executes complex assignments while escalating novel architectural, governance, | ||
| > | or enterprise-wide decisions to senior team members. The position requires strong technical skills, | > | 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 | > | 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 independ | > | architectural, governance, or enterprise-wide decisions to senior team members. The analyst independ | ||
| > | ently executes assigned analyses and reporting projects while receiving guidance on prioritization, | > | ently executes assigned analyses and reporting projects while receiving guidance on prioritization, | ||
| > | stakeholder management, and novel or highly complex analytical problems. Department Overview The mis | > | stakeholder management, and novel or highly complex analytical problems. Department Overview The mis | ||
| > | sion of the Enterprise Information and Analytics (EIA) department is to advance UCSF’s institutional | > | sion 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 pla | > | priorities by enhancing access to and the use of data and analytics, including appropriate data pla | ||
| > | tforms and data governance, in a manner that meets the unique needs across the education, research, | > | tforms 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, educat | > | and care mission areas. The department achieves its goals by working with clinical, research, educat | ||
| > | ion, and business partners to organize, integrate, govern, and transform UCSF’s data assets into act | > | ion, and business partners to organize, integrate, govern, and transform UCSF’s data assets into act | ||
| > | ionable insight and information. People Analytics owns enterprise-wide assets for UCSF as a whole, u | > | ionable insight and information. People Analytics owns enterprise-wide assets for UCSF as a whole, u | ||
| > | sed for both operational and analytical purposes, as well as departmental and business assets to dri | > | sed for both operational and analytical purposes, as well as departmental and business assets to dri | ||
| > | ve business insights and decisions. | > | ve business insights and decisions. | ||
| 3 | 3 | ||||
| 4 | Qualifications: | 4 | Qualifications: | ||
| t | 5 | REQUIRED QUALIFICATIONS - Bachelor's degree in a related area and/or equivalent experience/training. | t | 5 | 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. E | > | - At least 2 years of experience developing complex SQL queries and working with structured data. E | ||
| > | xperience writing maintainable, well-organized SQL using joins, CTEs, window functions, and reusable | > | xperience 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 yea | > | query patterns. Familiarity with Python or similar scripting languages preferred.. - At least 2 yea | ||
| > | rs’ experience developing reports from large data sets. - Experience translating business questions | > | rs’ experience developing reports from large data sets. - Experience translating business questions | ||
| > | into analytic approaches and actionable recommendations. 2 years’ experience developing and maintain | > | into analytic approaches and actionable recommendations. 2 years’ experience developing and maintain | ||
| > | ing report specifications in collaboration with business owners. - Familiarity with dimensional mode | > | ing report specifications in collaboration with business owners. - Familiarity with dimensional mode | ||
| > | ling concepts, logical data design, source-to-target mapping, and data transformation techniques. Ex | > | ling concepts, logical data design, source-to-target mapping, and data transformation techniques. Ex | ||
| > | perience documenting business logic for implementation by engineering teams. Demonstrated experience | > | perience 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 dev | > | using data to solve business problems and support decision-making. - Strong problem-solving, critic | ||
| > | eloping and maintaining report specifications in collaboration with business owners. - Strong proble | > | al thinking, and communication skills. - Proficiency in MS 365 Office Suite, especially Excel. - Exc | ||
| > | m-solving, critical thinking, and communication skills. - Proficiency in MS 365 Office Suite, especi | > | ellent communication, escalation, time management, collaboration, and change management skills. Abil | ||
| > | ally Excel. - Excellent communication, escalation, time management, collaboration, and change manage | > | ity to work both independently and in teams. - Experienced in setting priorities across competing de | ||
| > | ment skills. Ability to work both independently and in teams. - Experienced in setting priorities ac | > | mands, clarifying expectations, and sustaining a positive and productive attitude despite swiftly ch | ||
| > | ross competing demands, clarifying expectations, and sustaining a positive and productive attitude d | > | anging priorities and a high level of activity. Ability to complete projects and achieve results in | ||
| > | espite swiftly changing priorities and a high level of activity. Ability to complete projects and ac | > | a fast-paced work environment. PREFERRED QUALIFICATIONS - Experience working with workforce, HR, hea | ||
| > | hieve results in a fast-paced work environment. PREFERRED QUALIFICATIONS - Experience working with w | > | lthcare, operational, or compliance-related data. - Experience developing metrics and KPIs. - Famili | ||
| > | orkforce, HR, healthcare, operational, or compliance-related data. - Experience developing metrics a | > | arity with workforce analytics concepts including turnover, mobility, staffing, compliance, and orga | ||
| > | nd KPIs. - Familiarity with workforce analytics concepts including turnover, mobility, staffing, com | > | nizational effectiveness. - Experience with Tableau, Power BI, Databricks, or similar analytics plat | ||
| > | pliance, and organizational effectiveness. - Experience with Tableau, Power BI, Databricks, or simil | > | forms. | ||
| > | ar analytics platforms. | ||||