What are the responsibilities and job description for the Senior Data Engineer / Data Platform Architect position at University of California - San Francisco?
The EIA Health Finance team is seeking a highly experienced Senior Data Engineer / Data Platform Architect to support, enhance, and evolve OmniView, UCSF Health's enterprise data warehouse for financial analytics.
OmniView is a mission-critical platform supporting budgeting, cost accounting, labor productivity, and service line analytics. This role combines hands-on engineering, production support, and solution architecture, with a strong emphasis on building scalable, sustainable, and agile data and reporting platforms.
The ideal candidate is equally comfortable managing production systems, architecting enterprise solutions, and collaborating with business and technical stakeholders to deliver high-impact analytics.
Healthcare Domain Expertise (Required)
Experience with healthcare data, specifically:
- Budgeting and financial planning
- Cost accounting
- Labor productivity
- Service line analytics
Key Responsibilities
1. OmniView Data Warehouse Ownership (Primary Focus)
- Support, maintain, and enhance the OmniView enterprise data warehouse
- Design and optimize data models supporting:
- Budgeting & forecasting
- Cost accounting
- Labor productivity
- Service line analytics
- Develop and manage ETL/ELT processes using SQL Server (SSMS), SSAS
- Ensure high performance, reliability, and data quality
- Manage version control and deployments using GitHub
- Partner with finance stakeholders to evolve the platform
2. Production Support & Operations (Critical)
- Own production support, monitoring, and maintenance of:
- Data pipelines
- Data warehouse systems
- Reports and dashboards
- Troubleshoot data issues, performance bottlenecks, and failures
- Implement monitoring, alerting, and incident response processes
- Ensure SLAs for critical financial reporting systems
- Continuously improve system stability and operational efficiency
3. Data Architecture & Platform Design (Key Attribute)
- Architect scalable, sustainable, and agile data platforms
- Work closely with system owners, finance leaders, and stakeholders
- Translate business needs into cohesive technical solutions
- Design end-to-end data flows across:
- SQL Server ecosystem
- Microsoft Fabric
- Databricks
- BI tools
- Drive modernization of legacy systems
4. Data Engineering & Modern Platforms
- Extend OmniView into modern platforms (Fabric, Databricks)
- Build scalable data pipelines and integrations
- Optimize performance and cost efficiency
5. Data Science & Advanced Analytics
- Develop models for forecasting and financial insights
- Apply statistical and machine learning techniques
- Explore AI / GenAI use cases (e.g., OpenAI)
6. Business Intelligence & Reporting
- Develop dashboards using Power BI
- Enable self-service analytics for finance teams
- Deliver insights via strong data storytelling
Required Qualifications:
- Bachelor's degree in a related area and/or equivalent experience/training.
- At least fifteen years of experience in a Data Warehouse/Business Intelligence environment Previous experience in healthcare
- Experience with healthcare operations data, specifically:
- Budgeting and financial planning
- Cost accounting
- Labor productivity
- Service line analytics
- Experience in academic medical centers or large health systems
- Familiarity with Budgeting, Cost Accounting, and Labor productivity in a Healthcare setting.
- Working knowledge of:
- Windows authentication and other security protocols
- MS Windows Server
- SQL Server, MS Team Foundation
- MS Fabric
- Working knowledge of Relational Database design and data modeling skills
- Working knowledge of the Kimball Data Warehouse Dimensional Model
- Working knowledge of the Inmon Data Warehouse Model
- Advanced working knowledge of SQL Server's T-SQL language
- Ability to work in an Agile environment
- This position requires flexibility to orient and work at ail UCSF Medical Center locations
- Demonstrated experience designing, developing and supporting database applications
- Thorough working knowledge of testing practices, application debugging, and troubleshooting procedures
- Ability to identify, assess impact and develop recovery strategies for application or system failures
- Demonstrated ability to identify and implement critical maintenance fixes and to isolate and correct malfunctions, including interface problems
- Demonstrated ability to research, evaluate, and implement new technologies and software
- Ability to use creative problem-solving skills and apply effective technical solutions
- Demonstrated ability to work with technical and non-technical staff to identify user requirements and translate them into technology-based solutions
- Excellent verbal and written communication skills, including the ability to prepare and deliver formal and informal documentation, presentations, and training to a variety of end users
- Excellent organizational and time management skills with the ability to set own priorities to coordinate multiple assignments with fluctuating and time-sensitive deadlines
- Ability to foster and maintain positive and professional working relationships
- Ability to effectively handle interpersonal interactions at all levels and respond appropriately to conflicts and problems
- Must be flexible and have a positive attitude, and a sense of humor is highly desirable
Preferred Qualifications
- Degree in computer science or related field.
- Familiarity with Bl tools such as Tableau, Power BI, and DAX programming
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 here.
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.
Salary Information
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.
To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html
Required Qualifications:
- Bachelor's degree in a related area and/or equivalent experience/training.
- At least fifteen years of experience in a Data Warehouse/Business Intelligence environment Previous experience in healthcare
- Experience with healthcare operations data, specifically:
- Budgeting and financial planning
- Cost accounting
- Labor productivity
- Service line analytics
- Experience in academic medical centers or large health systems
- Familiarity with Budgeting, Cost Accounting, and Labor productivity in a Healthcare setting.
- Working knowledge of:
- Windows authentication and other security protocols
- MS Windows Server
- SQL Server, MS Team Foundation
- MS Fabric
- Working knowledge of Relational Database design and data modeling skills
- Working knowledge of the Kimball Data Warehouse Dimensional Model
- Working knowledge of the Inmon Data Warehouse Model
- Advanced working knowledge of SQL Server's T-SQL language
- Ability to work in an Agile environment
- This position requires flexibility to orient and work at ail UCSF Medical Center locations
- Demonstrated experience designing, developing and supporting database applications
- Thorough working knowledge of testing practices, application debugging, and troubleshooting procedures
- Ability to identify, assess impact and develop recovery strategies for application or system failures
- Demonstrated ability to identify and implement critical maintenance fixes and to isolate and correct malfunctions, including interface problems
- Demonstrated ability to research, evaluate, and implement new technologies and software
- Ability to use creative problem-solving skills and apply effective technical solutions
- Demonstrated ability to work with technical and non-technical staff to identify user requirements and translate them into technology-based solutions
- Excellent verbal and written communication skills, including the ability to prepare and deliver formal and informal documentation, presentations, and training to a variety of end users
- Excellent organizational and time management skills with the ability to set own priorities to coordinate multiple assignments with fluctuating and time-sensitive deadlines
- Ability to foster and maintain positive and professional working relationships
- Ability to effectively handle interpersonal interactions at all levels and respond appropriately to conflicts and problems
- Must be flexible and have a positive attitude, and a sense of humor is highly desirable
Preferred Qualifications
- Degree in computer science or related field.
- Familiarity with Bl tools such as Tableau, Power BI, and DAX programming
Equal Employment Opportunity: The University of California San Francisco is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.