Job Information

University of Utah Health Lead Data Warehouse Architect in SALT LAKE CITY, Utah


As a patient-focused organization, University of Utah Health exists to enhance the health and well-being of people through patient care, research and education. Success in this mission requires a culture of collaboration, excellence, leadership, and respect. University of Utah Health seeks staff that are committed to the values of compassion, collaboration, innovation, responsibility, diversity, integrity, quality and trust that are integral to our mission. EO/AA

This position will provide oversight in the design, deployment, management and development of one or more functional areas of the Enterprise Data Warehouse (EDW). Responsibilities include logical and physical design and deployment of the EDW environment, modernization of legacy processes, EMR source system analysis and architecture, Financial and Revenue Cycle source system analysis, developing the EDW roadmap and developing clinical and financial data structures. Effective and responsible management of assigned staff and projects.

Corporate Overview: University of Utah Healthcare is an integrated academic healthcare system with four hospitals including a level 1 trauma center, twelve community health centers, over 1,600 providers, and a health plan serving over 200,000 members. University Healthcare is nationally ranked and recognized for our academic research, quality standards and overall patient experience. In addition to our clinical delivery system, we have a School of Medicine, School of Dentistry, College of Nursing, College of Pharmacy, and College of Health providing education and training for over 1,250 providers annually. We have over 2 million patient visits annually and research grants exceeding $350 million.


  • Oversees day to day work activities of a small team(approximately 6 FTEs) and projects and priorities assigned to that team.

  • Collaborate with technology and management teams to understand structural requirements and define standards for how data will be stored, consumed, integrated, and managed across the organization and translate into a usable blueprint

  • Build an inventory of data needed to implement architecture and create a vision for how data will flow through the organization.

  • Design and build complex data models, approve modifications, and implement systems. Implement measures to ensure data accuracy and accessibility, constantly monitoring and refining the performance of data management systems.

  • Produce and enforce database development standards.

  • Mentors and trains data warehouse staff members on best practices and standardized solution design.

  • Facilitates the analysis of current state, future state and performs gap analysis.

  • Contributes to strategic planning processes, especially in translating business needs to IT solutions.

  • Act as a key thought partner to help current stakeholders understand how to extract maximum value from our tools.

  • Promotes clinical and business process improvement opportunities.

  • Mentors team members in their professional development.

  • Provides input on team members' evaluation

  • Recognized as subject matter expert and advanced individual contributor professional.

  • Conducts highly complex work, unsupervised and with extensive latitude for independent judgment and provide solutions.

  • Takes part in knowledge sharing activities to promote development of other team members.

Knowledge / Skills / Abilities

  • Superior team leadership, project management, and project planning skills, including the ability to collaborate with and motivate cross-functional partners around key clinical initiatives and drive for results / flawless execution.

  • Possess strong understanding of data modeling tools and standards, ETL tools, and big data technologies (e.g., Hadoop, Spark, Pig, NoSQL)

  • The ability to credibly interface with staff and senior executives, including the ability to communicate with non-technical stakeholders effectively.

  • Deep understanding of the healthcare industry and the ability to identify stakeholder' analytic needs.

  • Demonstrated ability to problem-solve a proposed solution, and lead a team through the research and execution of an analytic concept.

  • Considerable experience with healthcare cost, utilization and quality metrics (both design and application.

  • Demonstrated experience with large-scale integration of clinical data for primary and secondary use, sound understanding of Electronic Medical Records (EMR) systems architecture, medical standards and vocabularies and Clinical Data Warehouse (DW) architecture.

  • Strong database SQL, ETL and data analysis skills.

  • Experience with Data Warehouse platform evaluations/selection.

  • Excellent clinical analysis & problem-solving skills.


Qualifications Required

  • Bachelor Degree in Computer Science, Mathematics, Information Technology or equivalency.

  • Eight years of Senior Experience in the field.

  • Strong database SQL, ETL and data analysis skills.

  • Experience with Data Warehouse platform evaluations/selection.

  • Excellent clinical data or revenue cycle data analysis & problem-solving skills.

Qualifications (Preferred)


  • Proven experience designing and troubleshooting databases and data structures

  • Previous experience leading/managing projects and employees

  • Previous experience with Epic Cogito Products (Clarity,Caboodle,Slicer Dicer, Epic Reporting)

  • Cogito Certifications

Working Conditions and Physical Demands

Employee must be able to meet the following requirements with or without an accommodation.

  • This is a sedentary position in an office setting that may exert up to 10 pounds and may lift, carry, push, pull or otherwise move objects. This position involves sitting most of the time and is not exposed to adverse environmental conditions.

Physical Requirements

Sitting, Standing

EEO Statement

University of Utah Health Hospitals and Clinics, a part of The University of Utah, values candidates who have experience working in settings with students from diverse backgrounds and possess a strong commitment to improving access to higher education for historically underrepresented students.

Individuals from historically underrepresented groups, such as minorities, women, qualified persons with disabilities and protected veterans are encouraged to apply. Veterans’ preference is extended to qualified applicants, upon request and consistent with University policy and Utah state law. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities.

University of Utah Heath Hospitals and Clinics, a part of The University of Utah, is an Affirmative Action/Equal Opportunity employer and does not discriminate based upon race, ethnicity, color, religion, national origin, age, disability, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, pregnancy-related conditions, genetic information, or protected veteran's status. The University does not discriminate on the basis of sex in the education program or activity that it operates, as required by Title IX and 34 CFR part 106. The requirement not to discriminate in education programs or activities extends to admission and employment. Inquiries about the application of Title IX and its regulations may be referred to the Title IX Coordinator, to the Department of Education, Office for Civil Rights, or both.

To request a reasonable accommodation for a disability, please contact the University of Utah Health Hospitals and Clinics Human Resources office at 801-581-6500.If you or someone you know has experienced discrimination or sexual misconduct including sexual harassment, you may contact the Director/Title IX Coordinator in the Office of Equal Opportunity and Affirmative Action:

Sherrie Hayashi

Director/ Title IX Coordinator

Office of Equal Opportunity and Affirmative Action (OEO/AA)

135 Park Building

Salt Lake City, UT 84112


Online reports may be submitted

For more information:

To inquire about this posting, email:

The University is a participating employer with Utah Retirement Systems (“URS”). Eligible new hires with prior URS service, may elect to enroll in URS if they make the election before they become eligible for retirement (usually the first day of work). Contact Hospitals and Clinics Human Resources at (801) 581-6500 for information. Individuals who previously retired and are receiving monthly retirement benefits from URS are subject to URS’ post-retirement rules and restrictions. Please contact Utah Retirement Systems at (801) 366-7770 or (800) 695-4877 or Hospitals and Clinics Human Resources at (801) 581-6500 if you have questions regarding the post-retirement rules.

This position may require the successful completion of a criminal background check and/or drug screen.

Requisition Number 50134
Reg/Temp Regular
Employment Type Full-Time
Shift Day
Work Schedule M-F
Location Name Information Technology Services
Patient Care? No
State UT
Category Information Technology