Data System Analyst 4
F_IT EIA PEOPLE ANALYTICS Job Summary The Data Warehouse Architect in Enterprise Information & Analytics (EIA) designs the Scuba data warehouse ecosystem with a focus on people and workforce-related data. The role involves collaborating with both business and operational stakeholders, optimizing performance, driving innovation, and establishing data governance and standardization to align with business objectives.
- Architecture: Design both backend and frontend of the Scuba data warehouse ecosystem, including specialized data assets like the master person registry (Person Dimension), and facts and dimensions associated with workforce- and productivity-related data models and visualization solutions. Design and implement efficient and adaptable data models to support data exploration, data science, and analytics, resulting in insights that inform key business decisions.
- Operations: Work closely with EIA colleagues to support and enhance data warehouse operations. Design, develop, and optimize ETL workflows to support UCSF enterprise systems and operations, as well as workforce and productivity analytics..
- Technical Collaboration: Provide technical guidance to analysts and developers in EIA, supporting the creation of trusted data assets and conducting code reviews. Serve as a subject matter expert in data warehouse concepts such as Kimball, star schema, snowflake schemas, and normalized and dimensional data models.
- Stakeholder Partnership: Collaborate internally with People Analytics team and externally with consumers of enterprise assets owned by the People team. Collaborate with stakeholders in the operational and functional business units, offering data and analytics solutions while demonstrating a deep understanding of their business goals and operational objectives. Collaborate with departmental data stewards and technical system owners to establish a comprehensive understanding of the organization's processes and data, ensuring alignment with business needs.
- Communication: Translate business requirements from the ambulatory unit into technical specifications, ensuring alignment with organizational goals and addressing business needs.
- Performance Monitoring and Optimization: Proactively monitor and analyze performance to identify and recommend optimizations, enhancing system performance.
- Innovation: Stay current with the latest trends in data and analytics technologies, and drive innovation for the Scuba data warehouse ecosystem.
- Governance and Standards: Play an active role in establishing data governance and standardization, ensuring new and existing data assets conform to UCSF standards with appropriate access controls.
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.
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 - $215,800 (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
- Minimum of 7 years using at least one ETL tool such as Microsoft SQL Server Integration Services (SSIS), or any ETL applications. Capable of designing and developing data extraction, integration, and transformation solutions. Demonstrate the ability to create, code, and test ETL routines. Possess an understanding of the principles of effective ETL design. Advanced skills associated with programming design, modification and implementation.
- At least 7 years writing T-SQL. Experienced in writing complex SQL queries and stored procedures. Understanding of query performance tuning.
- Demonstrated advanced knowledge, skills and abilities associated with system problem identification and resolution. Knowledge necessary to design, set up, operate and correct malfunctions involving technology systems. Experience in incident response and digital forensics, including data collection, examination and analysis.
- In-depth knowledge of business and process analysis functions. Knowledge of the design, development and application of technology and systems to meet business needs. Demonstrated ability to create software specifications.
- Demonstrated experience with database administration. Advanced knowledge of complex database management systems and standards. Knowledge relating to extremely highly complex database system design. Advanced database querying and modeling skills working with moderately complex databases. In-depth knowledge of conceptual database design. Skills necessary to develop procedures and standards relating to database management systems. Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level.
- Familiarity with logical data design and data mapping or data conversion.
- Demonstrated skill at analyzing and preventing security incidents of high complexity. Strong security skills for protecting the operating system, software, data and hardware.
- Advanced knowledge of test application code in client server environment.
- Ability to write technical documentation in a clear and concise manner.
- Experience in data integration and the specification of data services. Ability to understand and model complex knowledge-intensive processes such as scholarly and research processes.
- Familiarity with data quality and governance issues and requirements.
- Technical skill to develop, implement and test disaster recovery functions using backup technologies.
- Demonstrated advanced project management skills.
- Interpersonal skills sufficient to work with both technical and non-technical personnel at various levels in the organization. Ability to elicit and communicate technical and non-technical information in a clear and concise manner.
- Ability to work independently on complex technical projects as well as on a team of technical professionals and departmental decision-makers. Position requires frequent interface with senior level personnel on matters of significance.
- Significant hands-on experience with Tableau BI or other similar visualization applications
- Ability to solve complex problems and perform work assignments requiring independent thought and judgment
- Knowledge of current industry practices, trends and resources (i.e., vendors, agencies, etc.)
- Bachelor's degree in related area and / or equivalent experience / training.
Preferred Qualifications
- Clarity Data Model Certification
License/Certification
- Clarity Data Model Certification (Preferred)
About UCSF The University of California, San Francisco (UCSF) is a leading university dedicated to promoting health worldwide through advanced biomedical research, graduate-level education in the life sciences and health professions, and excellence in patient care. It is the only campus in the 10-campus UC system dedicated exclusively to the health sciences. We bring together the world's leading experts in nearly every area of health. We are home to five Nobel laureates who have advanced the understanding of cancer, neurodegenerative diseases, aging and stem cells. 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. Job Code and Payroll Title 000599 DATA SYS ANL 4 Job Category Clinical Systems / IT Professionals Bargaining Unit 99 - Policy-Covered (No Bargaining Unit) Location San Francisco, CA Campus Mission Center Building (SF) Additional Shift Details Monday - Friday |
University of California - San Francisco Campus and Health
Dec 13, 2025