Job Details

Data Warehouse Analyst

Position Number: 6561717
Location: Salt Lake City, UT
Position Type: Computing - Database Administration

Data Warehouse Analyst

Job Summary

Join the Utah Data Coordinating Center (DCC) as a Data Warehouse Analyst, where your work will directly enable innovative clinical research at the University of Utah and across national partners. You will play a pivotal roll in designing, developing and maintaining business intelligence solutions, including reports, dashboards and data visualizations for a thriving clinical research enterprise. This is a growth-focused role ideal for someone who thrives in a collaborative, mission-driven environment. The Utah DCC supports large-scale health data infrastructure that underpins national emergency response, clinical registries, and federal research initiatives. This position is listed as hybrid meaning the selected candidate would need to live local or be willing to relocate to the Salt Lake City area.

Positions are designed to provide growth and professional development opportunities, including promotions within a defined career ladder.

The University of Utah offers a comprehensive benefits package including:

Excellent health care coverage at affordable rates
14.2% retirement contributions that vest immediately
Generous paid leave time
11 paid Holidays
50% tuition reduction for employee, spouse, and dependent children
Flex spending accounts
Free transit on most UTA services
Employee discounts on a variety of products and services including cell phones & plans, entertainment, health and fitness, restaurants, retail, and travel
Professional development opportunities

Additional benefits information is available at www.hr.utah.edu/benefits

Responsibilities
As a Data Warehouse Analyst, your responsibilities will include:

Data Analysis and Requirements Gathering: Analyze business requirements, understand data sources, and translate them into technical specifications for BI solutions.
Data Modeling and Warehousing: Design and develop data models, data warehouses, and ETL (Extract, Transform, Load) processes to ensure data quality, accessibility, and scalability.
Dashboard and Report Development: Create interactive dashboards, reports, and visualizations using tools like Power BI, Tableau, Python or Looker.
Data Extraction, Transformation, and Loading (ETL): Automate the process of extracting data from various sources, transforming it into a usable format, and loading it into the data warehouse or reporting tools.
Performance Optimization and Troubleshooting: Optimize the performance of BI systems, troubleshoot issues, and ensure the reliability of data and reports.
Collaboration and Communication: Collaborate with Data Architects, Software engineers and various teams to gather requirements, provide support, and ensure the BI solutions meet the business needs.

Disclaimer This job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to the job.

Comments
Work Environment and Level of Frequency typically required
Nearly Continuously: Office environment.
Physical Requirements and Level of Frequency that may be required
Nearly Continuously: Sitting, hearing, listening, talking.
Often: Repetitive hand motion (such as typing), walking.
Seldom: Bending, reaching overhead.

Minimum Qualifications
Requires a bachelor's degree in area of specialty or equivalency (one year of education can be substituted for two years of related work experience) and 2-4 years of experience in the field or in a related area. Familiar with a variety of the field's concepts, practices, and procedures.

Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.

Preferences
We will give preference to candidates with the following qualifications:

Proficient in SQL
Familiarity with AWS (Glue, S3, EC2)
Development experience with Python (Pandas, Boto3, PySpark)
Understanding of ETL processes and tools
Experience with version control systems (Git)
Ability to read/understand Java is a plus
Experience using Jenkins
Experience with data visualization tools (Tableau, SSRS, Power BI)
Background in data warehouse design (Star/Snowflake Schema)
In-depth understanding of database management systems, OLAP and ETL frameworks
Excellent analytical, problem-solving, and innovative thinking skills
Strong ability to explain advanced data concepts to fellow developers as well as non- technical end users
Demonstrated ability to meet deadlines, balance multiple priorities, and ensure quality standards based on an Agile development process.

Applicants will be screened according to preferences.

Special Instructions

Requisition Number: PRN43069B
Full Time or Part Time? Full Time
Work Schedule Summary: Hybrid 2-3 Days in office. Monday-Friday, 8:30 am - 5:00 pm
Department: 02228 - Data Coordinating Center
Location: Campus
Pay Rate Range: 47600 to 84249
Close Date: 12/10/2025
Open Until Filled:

To apply, visit https://utah.peopleadmin.com/postings/188695