Workforce Data Engineer

Responsibilities

• Partner with workforce analysts, HR stakeholders, and business leaders to understand workforce reporting, analytics, and operational requirements.
• Collaborate with analysts to translate workforce metrics, business rules, and reporting requirements into technical specifications and sustainable data solutions.
• Evaluate source system data and identify required data elements to support workforce analytics initiatives.
• Support development, testing, and validation of new workforce metrics and analytic products.
• Contribute to analytic solution design by providing technical guidance on data structures, integration approaches, and implementation considerations.
• Document business and technical requirements, data definitions, assumptions, and transformation logic.
• Design, develop, maintain, and optimize dimensional data models supporting workforce analytics, operational reporting, and strategic decision-making.
• Build and maintain ETL processes, stored procedures, and SSIS pipelines that support workforce data integration and analytics.
• Leverage UCSF's established Kimball data architecture to develop governed and reusable workforce data assets.
• Integrate data originating from Oracle HCM Cloud, and other systems into analytic data models.
• Develop and maintain technical documentation for data models, pipelines, and data transformations.
• Collaborate with data architects and senior engineers to ensure solutions align with enterprise architecture, governance, and engineering standards.
• Investigate, troubleshoot, and resolve data quality issues affecting workforce reporting, dashboards, and downstream analytic products.
• Support efforts to standardize, reconcile, and improve workforce data across multiple enterprise systems and business processes.
• Validate analytic datasets, metrics, and reporting outputs to ensure accuracy, consistency, and alignment with business requirements.
• Implement data quality controls, monitoring processes, and validation procedures to support reliable analytics.
• Contribute to the development of new workforce metrics and analytic capabilities as organizational priorities evolve.
• Maintain technical documentation and operational procedures.
• Participate in continuous improvement efforts that improve reliability, maintainability, and scalability of People Analytics data products.
• Perform other duties as assigned.

Qualifications

• Bachelor's degree in a related area and/or equivalent experience/training
• Minimum 5 years of experience in data analytics or data management
• Minimum 3 years of experience performing advanced data analysis using SQL and/or analytic programming languages (e.g., R, Python, Stata, SPSS)
• T-SQL in Microsoft SQL Management Studio preferred
• 2+ years of experience developing or integrating with APIs for data ingestion (REST/JSON), including secure authentication (OAuth2/API keys) and operational support (logging/monitoring/error handling)
• Experience writing SQL for data extraction, transformation, and analysis
• Hands-on experience developing and supporting SSIS pipelines for analytic data preparation
• Experience integrating data from multiple source systems
• Experience validating data quality and troubleshooting data issues
• Ability to communicate effectively with both technical and non-technical audiences
• Strong analytical, problem-solving, and organizational skills
• Ability to work independently while collaborating effectively within a team
• Strong organizational skills