What are the responsibilities and job description for the Workforce Data Engineer position at UCSF Health?
IT - Enterprise Report Writing
Full Time
87724BR
Job Summary
Having significant experience, applies advanced data / information management concepts and campus / medical center / OP objectives to resolve highly complex issues where analyses of situations, information or data require an in-depth evaluation of variable factors. Selects methods and techniques to obtain desired results.
Workforce Data Engineer will support maintenance of UCSF’s governed Master Person Registry (Person Dimension). Will also design, develop, and validate workforce data models that integrate traditional and AI-augmented approaches. Leveraging dimensional modeling principles (Kimball methodology) and SSIS-supported data pipelines, this role integrates data from multiple enterprise sources to create reliable analytic datasets and metrics. The analyst monitors and validates results, including generated by AI on platforms such as Power BI/Data Fabric, Databricks, and Tableau Pulse, tuning inputs, thresholds, and feature selections to ensure accuracy, relevance, and business alignment.
Serving as a liaison with external vendors, the role evaluates analytic solutions and dashboards for quality, transparency, and adherence to both Kimball and enterprise standards. The analyst translates complex analytic findings into clear, actionable insights, dashboards, and visualizations for leadership, guiding data-driven decisions while maintaining rigorous standards for governance, privacy, and security. This position represents a significant expansion of scope, combining technical proficiency, AI stewardship, vendor engagement, and independent analytic judgment.
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.
The salary range for this position is $143,900 - $180,000 (Annual Rate).
To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html
Department Description
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.
Required Qualifications
At UCSF Health, our mission of innovative patient care, advanced technology and pioneering research is redefining what’s possible for the patients we serve – a promise we share with the professionals who make up our team.
Consistently ranked among the top 10 hospitals nationwide by U.S. News & World Report – UCSF Health is committed to providing the most rewarding work experience while delivering the best care available anywhere. In an environment that allows for continuous learning and opportunities for professional growth, UCSF Health offers the ideal atmosphere in which to best use your skills and talents.
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 at diversity.ucsf.edu
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.
Organization
Health
Job Code and Payroll Title
000599 DATA SYS ANL 4
Job Category
Clinical Systems / IT Professionals
Bargaining Unit
99 - Policy-Covered (No Bargaining Unit)
Employee Class
Career
Percentage
100%
Location
San Francisco, CA
Campus
Mission Center Building (SF)
Work Style
Flexible
Shift
Days
Shift Length
8 Hours
Additional Shift Details
Monday - Friday
Full Time
87724BR
Job Summary
Having significant experience, applies advanced data / information management concepts and campus / medical center / OP objectives to resolve highly complex issues where analyses of situations, information or data require an in-depth evaluation of variable factors. Selects methods and techniques to obtain desired results.
Workforce Data Engineer will support maintenance of UCSF’s governed Master Person Registry (Person Dimension). Will also design, develop, and validate workforce data models that integrate traditional and AI-augmented approaches. Leveraging dimensional modeling principles (Kimball methodology) and SSIS-supported data pipelines, this role integrates data from multiple enterprise sources to create reliable analytic datasets and metrics. The analyst monitors and validates results, including generated by AI on platforms such as Power BI/Data Fabric, Databricks, and Tableau Pulse, tuning inputs, thresholds, and feature selections to ensure accuracy, relevance, and business alignment.
Serving as a liaison with external vendors, the role evaluates analytic solutions and dashboards for quality, transparency, and adherence to both Kimball and enterprise standards. The analyst translates complex analytic findings into clear, actionable insights, dashboards, and visualizations for leadership, guiding data-driven decisions while maintaining rigorous standards for governance, privacy, and security. This position represents a significant expansion of scope, combining technical proficiency, AI stewardship, vendor engagement, and independent analytic judgment.
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.
The salary range for this position is $143,900 - $180,000 (Annual Rate).
To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html
Department Description
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.
Required Qualifications
- Bachelor’s degree and a minimum of 5 years’ experience in data analytics or data management; or an equivalent combination of education and experience.
- Minimum 4 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.
- Demonstrated experience integrating data from multiple enterprise systems for analytic purposes
- Experience developing analytic datasets, metrics, and dashboards supporting decision-making
- Working knowledge of data warehouse concepts, ETL principles, and analytic data modeling
- Hands-on experience developing and supporting SSIS pipelines for analytic data preparation
- Strong written and verbal communication skills, including with internal and external stakeholders
- Demonstrated ability to validate, interpret, and contextualize analytic outputs
- Professionalism and discretion in handling sensitive and confidential workforce data
- Demonstrated ability to work with others from diverse backgrounds. Demonstrated effective communication and interpersonal skills. Demonstrated service orientation skills.
- Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.
- Self-motivated and works independently and as part of a team. Able to self-manage projects once priorities are set.
- Demonstrated advanced problem-solving skills. Able to learn effectively and meet deadlines.
- Experience applying Kimball dimensional modeling principles in analytic datasets
- Experience with PeopleSoft HCM or similar HR systems; Experience with workforce analytics or people-related data
- 3 years of experience integrating data from diverse sources and formats, including delimited text files (CSV/TSV/PSV), fixed-width files, JSON, XML, YAML, Parquet/Avro/ORC, and Excel (XLS/XLSX), as well as relational databases via ODBC/JDBC.
- 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).
At UCSF Health, our mission of innovative patient care, advanced technology and pioneering research is redefining what’s possible for the patients we serve – a promise we share with the professionals who make up our team.
Consistently ranked among the top 10 hospitals nationwide by U.S. News & World Report – UCSF Health is committed to providing the most rewarding work experience while delivering the best care available anywhere. In an environment that allows for continuous learning and opportunities for professional growth, UCSF Health offers the ideal atmosphere in which to best use your skills and talents.
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 at diversity.ucsf.edu
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.
Organization
Health
Job Code and Payroll Title
000599 DATA SYS ANL 4
Job Category
Clinical Systems / IT Professionals
Bargaining Unit
99 - Policy-Covered (No Bargaining Unit)
Employee Class
Career
Percentage
100%
Location
San Francisco, CA
Campus
Mission Center Building (SF)
Work Style
Flexible
Shift
Days
Shift Length
8 Hours
Additional Shift Details
Monday - Friday
Salary : $143,900 - $180,000