University of Utah Jobs

Search for careers

<strong></strong> <a href="https://careers-uuhc.icims.com/jobs/42241/data-warehouse-analyst-ii/job?mode=apply&apply=yes&in_iframe=1&hashed=-336237487" class="iCIMS_Anchor iCIMS_Action_Button iCIMS_ApplyOnlineButton iCIMS_PrimaryButton" title="Apply for this job online"> </a><a onclick="showSocialOptions(); return false" id="mobileShowSocialOptionsButton" href="#" class="iCIMS_Anchor iCIMS_Action_Button iCIMS_JobShareButton" title="Share"> Share </a><a href="https://careers-uuhc.icims.com/jobs/42241/data-warehouse-analyst-ii/referral?in_iframe=1&hashed=-435801949" class="iCIMS_Anchor iCIMS_Action_Button iCIMS_SecondaryButton" title="Refer this job to a friend"> Refer this job to a friend </a> Intere

Job Information

University of Utah Health Data Warehouse Analyst II in SALT LAKE CITY, Utah

Overview

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 is focused on developing and supporting the Enterprise Data Warehouse and the reporting solutions across our clinical health care environment. This position is responsible for the development of functional specifications to fulfill the data requirements for delivering comprehensive business intelligence solutions, data mart design, reporting and analytics. Strong data modeling, SQL skills and knowledge of 3rd party reporting tools is required. The incumbent provides system administrative support for data extraction processes and reporting tools, including front line support for the user community. This position has no responsibility for providing care to patients.

Corporate Overview: The University of Utah is a Level 1 Trauma Center and is nationally ranked and recognized for our academic research, quality standards and overall patient experience. Our four hospitals and seventeen clinics provide excellence in our comprehensive services, medical advancement, and overall patient outcomes.

Responsibilities

  • Analyzes user data to determine business rules and creates data models.

  • Participates in all phases of data warehouse implementation. Identifies pertinent issues and prepares comprehensive design specifications for database design, testing, conversion, and implementation.

  • Translates and documents the results of requirements gathering into a standard format to be used to create the appropriate Business Intelligence (BI) solution.

  • Applies industry standards to the technical architecture of a Business Intelligence solution (Stars, Cubes, Extract Transform and Load (ETL)) to solve business problems or increase business efficiently.

  • Implements and supports Cognos and other reporting applications.

  • Identifies and recommends methods to normalize and maintain data from disparate systems. Works with other internal ITS teams to understand the source systems used for the warehouse.

  • Troubleshoots data warehouse software. Develops and maintains tools to optimize data quality and access.

  • Works with end user to gather reporting requirements.

  • Collaborates with users and negotiates to identify and develop add data sources for the data warehouse consistent with business rules and customer needs.

  • Coordinates with Data Warehouse Architects to create and support Business Intelligence environment. Identifies and works with appropriate staff to resolve technical issues.

  • Develops strategies and updates the data warehouse in response to changes reporting requirements.

  • Conducts and attends team meetings, and communicates (verbally and in writing) team and project issues to appropriate staff and customers. Presents findings, recommendations, and specifications both verbally and in writing.

  • Participates as a team member on data warehouse projects.

Knowledge / Skills / Abilities

  • Strong background in data modeling techniques and methodologies.

  • Knowledge of relational database and query concepts.

  • Ability to analyze and develop business requirements and translate them into a data warehouse dimensional model.

  • Ability to multi-task and meet negotiated timelines.

  • Skill in explaining data warehouse operations to technical and non-technical users.

Qualifications

Qualifications Required

  • Bachelor degree in Computer Science or related field or equivalency.

  • Broad knowledge of data warehousing design, the business intelligence reporting life cycle and standard query tools.

Qualifications (Preferred)

Preferred

  • Graduate Degree in Medical Informatics or Computer Science or related field.

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.

Physical Requirements

Non Indicated

ShareRefer this job to a friend

Interested in this opportunity?

Socialize this job opportunity to a friend, colleague, or family member:

EEO Statement

The University of Utah Health Care is an Affirmative Action/Equal Opportunity employer. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities. The University of Utah Health Care is committed to diversity in its workforce. Women and minorities are encouraged to apply.

Requisition Number 42241

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

The University of Utah Health Care is an Affirmative Action/Equal Opportunity employer. Upon request, reasonable accommodations in the application process will be provided to individuals with disabilities. The University of Utah Health Care is committed to diversity in its workforce. Women and minorities are encouraged to apply.

University of Utah logo
University of Utah logo
DirectEmployers