Business Intelligence Analyst

Job Summary

Join the Utah Data Coordinating Center (DCC) as a Business Intelligence Analyst, where your work will directly enable innovative clinical research at the University of Utah and across national partners. You will play a pivotal role 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.

As a Business Intelligence Analyst, your responsibilities will include:

1. Data Analysis and Requirements Gathering: Analyze business requirements, understand data sources, and translate them into technical specifications for BI solutions.
2. Data Modeling and Warehousing: Design and develop data models, data warehouses, and ETL (Extract, Transform, Load) processes to ensure data quality, accessibility, and scalability.
3. Dashboard and Report Development: Create interactive dashboards, reports, and visualizations using tools like Power BI, Tableau, Python or Looker.
4. 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.
5. Performance Optimization and Troubleshooting: Optimize the performance of BI systems, troubleshoot issues, and ensure the reliability of data and reports.
6. 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.

The Utah DCC offers a career ladder for Business Intelligence Analyst and provides growth and professional development opportunities.

This position is not eligible for work visa sponsorship.

To learn more about the Utah DCC visit http://uofuhealth.org/UtahDCC

Learn more about the great benefits of working for University of Utah: benefits.utah.edu

The department may choose to hire at any of the below job levels and associated pay rates based on their business need and budget.

Responsibilities

Business Intelligence AnalystDrive business decisions by providing quantitative and qualitative data analysis and reporting of patterns, insights, and trends to decision-makers. Collect, aggregate, and analyze data from multiple internal and external sources to drive insights into business performance. Produce actionable reports that show key performance indicators, identify areas of improvement into current operations, and display root cause analysis of problems. Use analytics and metrics to improve processes and provide data-driven forecasts of potential costs, risks, and profits of new business initiatives. Communicate findings and insight to stakeholders and provide business strategy recommendations for optimizing business performance. Provide reporting solutions and respond to ad-hoc report requests across multiple business areas. May participate in the design and development of business intelligence reporting tools.

Business Intelligence Analyst, IIRequires moderate skill set and proficiency in discipline. Conducts work assignments of increasing complexity, under moderate supervision with some latitude for independent judgment.

Requires a bachelor's (or equivalency) + 4 years or a master's (or equivalency) + 2 years of directly related work experience.

Business Intelligence Analyst, IIIConsidered highly skilled and proficient in discipline. Conducts complex, important work under minimal supervision and with wide latitude for independent judgment.

Requires a bachelor's (or equivalency) + 6 years or a master's (or equivalency) + 4 years of directly related work experience.

Minimum Qualifications

EQUIVALENCY STATEMENT: 1 year of higher education can be substituted for 1 year of directly related work experience (Example: bachelor's degree = 4 years of directly related work experience).

Department may hire employee at one of the following job levels:

Business Intelligence Analyst, II: Requires a bachelor's (or equivalency) + 4 years or a master's (or equivalency) + 2 years of directly related work experience.

Business Intelligence Analyst, III: Requires a bachelor's (or equivalency) + 6 years or a master's (or equivalency) + 4 years of directly related work experience.

Preferences

We will give preference to candidates with the following qualifications:

• Proficient in SQL
• Understanding of ETL processes and tools
• Experience with version control systems (Git)
• Ability to read/understand Python is a plus
• Experience using Jenkins
• Experience with data visualization tools (Tableau, SSRS, Power BI)
• Background in business intelligence 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.

Special Instructions

Requisition Number: PRN44779B

Full Time or Part Time? Full Time

Work Schedule Summary: Full-time, 40 hours per week. Monday - Friday from 8:00 am to 5:00 pmThis position offers a flexible, mostly remote work schedule for candidates who reside in the Salt Lake region of Utah. While most duties can be performed remotely, the employee must be available to attend essential meetings and events on campus as needed.A hybrid telework schedule is available for this position, dependent on operational needs and management approval. The arrangement will be established in partnership with the manager and is subject to ongoing departmental needs.This position may require occasional travel.

Department: 02228 - Data Coordinating Center

Location: Campus

Pay Rate Range: 50909 to 92618

Close Date: 7/17/2026

Open Until Filled:

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