{bc}
oracle

Lead Workforce Visualization Analyst

University of California, San Francisco
San Francisco, USA
Full-time
Lead · 2+ years experience
Onsite
Discovered 2 weeks ago
databrickspower-bisqltableau

Full Job Posting

REQUIRED QUALIFICATIONS

  • Bachelor's 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.
  • 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)
  • Responsibilities
  • %
  • of time
  • Essential Function (Yes/No )
  • Key Responsibilities
  • (To be completed by Supervisor)
  • 30
  • Analytics Solution Design, Visualization and Business Reporting Logic
  • Business Consultation: Consult with department leaders, process owners, and stakeholders to understand workforce reporting needs, define analytical requirements, and translate business questions into intuitive reporting solutions using approved enterprise dashboard templates and visualization standards.
  • 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.
  • Visualization Stewardship: Serve as the People Analytics lead for dashboard usability and presentation by promoting consistent application of enterprise visualization standards, approved templates, navigation patterns, filtering behavior, KPI presentation, and information hierarchy. Recommend incremental improvements based on stakeholder feedback and evolving business needs.
  • 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.
  • 20
  • Data Mapping and Collection
  • 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 for additional review and analysis.
  • Validation: Ensure data from various sources is reconciled and accurately presented in workforce analytic tools.
  • Identify and Repair errors: Analyze and troubleshoots data errors and problems, and devise functional solutions.
  • Ad. Hoc Workforce Reporting
  • Develop Ad. Hoc reports based on report specifications from either outside parties (eg. Regulators, Trade organization, and Unions) or internal organizations.
  • 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.
  • Strategic Partnership, Communications, Dissemination and Visualization Leadership
  • Business/Strategic alignment Consultation: Consult with UCSF leaders and business partners to identify opportunities where workforce analytics and effective data visualization can improve operational and strategic decision-making.
  • Analytics Presentation: Develop dashboards for tiered audiences that communicate workforce trends, performance, and organizational insights through clear, consistent, and user-centered visualization techniques.
  • Communication: Present analytical findings verbally, visually, and in writing to technical and non-technical audiences, tailoring communication to executive, operational, and analytical stakeholders.
  • Cross-functional Collaboration: Partner with analysts, data architects, engineers, and business stakeholders to ensure reporting solutions balance analytical accuracy, technical feasibility, usability, and enterprise standards.
  • Continuous Improvement: Evaluate user feedback, emerging visualization capabilities, and evolving business needs to recommend enhancements to the People Analytics reporting portfolio while maintaining consistency with enterprise design standards and approved dashboard templates.
  • 0%
  • (To update total %, enter the amount of time in whole numbers (without the % symbol - e.g., 15, 20) then highlight the total sum (e.g., 1%) at the bottom of the column and press F9. The total sum should add up to 100%.)

Responsibilities

  • of time
  • Essential Function (Yes/No )
  • (To be completed by Supervisor)
  • 30
  • Business Consultation: Consult with department leaders, process owners, and stakeholders to understand workforce reporting needs, define analytical requirements, and translate business questions into intuitive reporting solutions using approved enterprise dashboard templates and visualization standards.
  • 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.
  • Visualization Stewardship: Serve as the People Analytics lead for dashboard usability and presentation by promoting consistent application of enterprise visualization standards, approved templates, navigation patterns, filtering behavior, KPI presentation, and information hierarchy. Recommend incremental improvements based on stakeholder feedback and evolving business needs.
  • 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.
  • 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.
  • 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 for additional review and analysis.
  • Validation: Ensure data from various sources is reconciled and accurately presented in workforce analytic tools.
  • Identify and Repair errors: Analyze and troubleshoots data errors and problems, and devise functional solutions.
  • Develop Ad. Hoc reports based on report specifications from either outside parties (eg. Regulators, Trade organization, and Unions) or internal organizations.
  • 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.
  • Business/Strategic alignment Consultation: Consult with UCSF leaders and business partners to identify opportunities where workforce analytics and effective data visualization can improve operational and strategic decision-making.
  • Analytics Presentation: Develop dashboards for tiered audiences that communicate workforce trends, performance, and organizational insights through clear, consistent, and user-centered visualization techniques.
  • Communication: Present analytical findings verbally, visually, and in writing to technical and non-technical audiences, tailoring communication to executive, operational, and analytical stakeholders.
  • Cross-functional Collaboration: Partner with analysts, data architects, engineers, and business stakeholders to ensure reporting solutions balance analytical accuracy, technical feasibility, usability, and enterprise standards.
  • Continuous Improvement: Evaluate user feedback, emerging visualization capabilities, and evolving business needs to recommend enhancements to the People Analytics reporting portfolio while maintaining consistency with enterprise design standards and approved dashboard templates.
  • 0%
  • (To update total %, enter the amount of time in whole numbers (without the % symbol - e.g., 15, 20) then highlight the total sum (e.g., 1%) at the bottom of the column and press F9. The total sum should add up to 100%.)

Key Responsibilities

  • Analytics Solution Design, Visualization and Business Reporting Logic
  • Data Mapping and Collection
  • Ad. Hoc Workforce Reporting
  • Strategic Partnership, Communications, Dissemination and Visualization Leadership

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at University of California, San Francisco