University of Utah Health Care

Returning Candidate?

Data Warehouse Architect III

Data Warehouse Architect III

Requisition Number 
27954
Reg/Temp 
Regular
Employment Type 
Full-Time
Shift 
Day
Work Schedule 
8-5
Location Name 
Information Technology Services
Patient Care? 
No
City 
SALT LAKE CITY
State 
UT
Department 
COR ISC 18I DATA WAREHOUSE
Category 
Information Technology

More information about this job

Overview

As a patient-focused organization, the University of Utah Health Care 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 Care 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

The incumbent leads the architecture, design and development of the next generation Data Warehouse platform and analytic solutions.

Responsibilities

  • Consults with business and technology leaders to understand organization goals.
  • Serves as a lead architect in defining and implementing new Enterprise Data Warehouse.
  • Establishes and maintains data modeling standards to promote quality model deliverables.
  • Performs technical evaluations and proofs-of-concept and present recommendations.
  • Recommends architectural changes that maximize system performance, stability, and maintainability.
  • Designs and builds logical data models.
  • Creates automated reports, dashboards, ETL workflows, and mappings.
  • Tunes system performance through SQL tuning, DB optimization, and other strategies.
  • Collaborates with junior team members on the technical approach and design for complex problems.
  • Oversees the architectural direction of the Business Intelligence platform in order to ensure a cohesive and high performing system.

Knowledge / Skills / Abilities

  • Has significant experience architecting Data Warehouse solutions within Healthcare and or Life Sciences industries.
  • In depth knowledge of technique, models, processes, methodologies, and plans within architecture disciplines.
  • Excellent understanding of Healthcare industry standards and technology trends.
  • Strong database SQL, ETL and data analysis skills.
  • Experience with Data Warehouse platform evaluations/selection and experience with Teradata, Netezza, or Greenplum highly desirable.
  • Excellent communication skills written, oral, and presentation delivery.
  • Ability to present complex technical concepts in terms that are relevant and applicable to HMS business. Ability to sell the value of data services to HMS in business terms to promote better information and capabilities for better decision making.

Qualifications

Qualifications

Required

  • Bachelor’s degree in Computer Science or equivalent.
  • Five years of applicable experience.

Qualifications (Preferred)

Working Conditions and Physical Demands

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

  • This is a sedentary position 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.
  • We are University of Utah Health. healthcare.utah.edu

Physical Requirements

Non Indicated