Overview
On Site
USD 47,600.00 per year
Full Time
Skills
FLSA
Preventive Maintenance
Project Management
Performance Management
Recruiting
Pivotal
Clinical Research
Research
Promotions
Apache Flex
Retail
Professional Development
Data Analysis
Requirements Elicitation
Specification Gathering
Data Modeling
Warehouse
Data Quality
Accessibility
Scalability
Dashboard
Data Extraction
Performance Tuning
Communication
Collaboration
Business Intelligence
Oracle Linux
Inventory
Typing
SQL
Amazon Web Services
Amazon S3
Amazon EC2
Python
Pandas
PySpark
Version Control
Git
Java
Jenkins
Data Visualization
Tableau
Microsoft SSRS
Microsoft Power BI
Data Warehouse
Snow Flake Schema
Database Administration
OLAP
Extract
Transform
Load
Analytical Skill
Problem Solving
Conflict Resolution
Agile
Human Resources
URS
HR Management
Higher Education
Health Care
Law
SAP BASIS
Reporting
Statistics
Job Details
Announcement
Details
Open Date
09/10/2025
Requisition Number
PRN43069B
Job Title
Data Warehouse Analyst
Working Title
Data Warehouse Analyst
Job Grade
F
FLSA Code
Computer Employee
Patient Sensitive Job Code?
No
Standard Hours per Week
40
Full Time or Part Time?
Full Time
Shift
Day
Work Schedule Summary
Hybrid 2-3 Days in office. Monday-Friday, 8:30 am - 5:00 pm
VP Area
U of U Health - Academics
Department
02228 - Data Coordinating Center
Location
Campus
City
Salt Lake City, UT
Type of Recruitment
External Posting
Pay Rate Range
47600 to 84249
Close Date
12/10/2025
Priority Review Date (Note - Posting may close at any time)
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:
Additional benefits information is available at ;/strong>
Responsibilities
As a Data WarehouseAnalyst, your responsibilities will include:
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:
Applicants will be screened according to preferences.
Type
Benefited Staff
Special Instructions Summary
Additional Information
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 Human Resources at 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 or or University Human Resource Management at 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.
The University of Utah values candidates who have experience working in settings with students and patients from all backgrounds and possess a strong commitment to improving access to higher education and quality healthcare for historically underrepresented students and patients.
All qualified individuals are strongly 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.
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 or 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 (OEO/AA). More information, including the Director/Title IX Coordinator's office address, electronic mail address, and telephone number can be located at: ;br>Online reports may be submitted at oeo.utah.edu
This report includes statistics about criminal offenses, hate crimes, arrests and referrals for disciplinary action, and Violence Against Women Act offenses. They also provide information about safety and security-related services offered by the University of Utah. A paper copy can be obtained by request at the Department of Public Safety located at 1658 East 500 South.
Details
Open Date
09/10/2025
Requisition Number
PRN43069B
Job Title
Data Warehouse Analyst
Working Title
Data Warehouse Analyst
Job Grade
F
FLSA Code
Computer Employee
Patient Sensitive Job Code?
No
Standard Hours per Week
40
Full Time or Part Time?
Full Time
Shift
Day
Work Schedule Summary
Hybrid 2-3 Days in office. Monday-Friday, 8:30 am - 5:00 pm
VP Area
U of U Health - Academics
Department
02228 - Data Coordinating Center
Location
Campus
City
Salt Lake City, UT
Type of Recruitment
External Posting
Pay Rate Range
47600 to 84249
Close Date
12/10/2025
Priority Review Date (Note - Posting may close at any time)
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 ;/strong>
Responsibilities
As a Data WarehouseAnalyst, 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.
Type
Benefited Staff
Special Instructions Summary
Additional Information
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 Human Resources at 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 or or University Human Resource Management at 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.
The University of Utah values candidates who have experience working in settings with students and patients from all backgrounds and possess a strong commitment to improving access to higher education and quality healthcare for historically underrepresented students and patients.
All qualified individuals are strongly 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.
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 or 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 (OEO/AA). More information, including the Director/Title IX Coordinator's office address, electronic mail address, and telephone number can be located at: ;br>Online reports may be submitted at oeo.utah.edu
This report includes statistics about criminal offenses, hate crimes, arrests and referrals for disciplinary action, and Violence Against Women Act offenses. They also provide information about safety and security-related services offered by the University of Utah. A paper copy can be obtained by request at the Department of Public Safety located at 1658 East 500 South.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.