University of Utah Jr. Business Intelligence Analyst/Developer in Salt Lake City, Utah


Open Date 06/13/2018

Requisition Number PRN17484B

Job Title Data Warehouse Analyst

Working Title Jr. Business Intelligence Analyst/Developer

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

Monday – Friday, 8:00 am – 5:00 pm

VP Area U of U Health - Academics

Department 00850 - Pediatric Critical Care

Location Campus

City Salt Lake City, UT

Type of Recruitment External Posting

Pay Rate Range $47,600 to $79,699

Close Date

Open Until Filled Yes

Job Summary

The Division of Pediatric Critical Care at the University of Utah School of Medicine has an immediate opening for a Junior Business Intelligence (BI) Analyst/Developer. This position works with a high functioning, cutting edge team that will study, understand and improve multi-site translational research.

The BI Analyst will assist in the strategic design and maintenance of BI and Visualization solutions for the Data Coordinating Center. The primary focus of the BI Analyst will be to work as part of the data services team to support reporting, analysis and visualizations requirements using Microsoft technologies (e.g.,SQL,SSRS,SSAS, PowerPivot, Power View, PerformancePoint, and SharePoint). The work is fast paced, interesting and challenging.


•Participates within a multidisciplinary team to collect and interpret business requirements into optimum BI solutions to meet business needs

•Provides design support for the development of business intelligence solutions

•Develops visually informative dashboards and customized reports based on business requirements

•Performs analysis for a wide range of requests using data in different formats and from various platforms

•Performs quality review of new and existing reports

•Provides input to standards, policies and procedures for BI tools and systems

•Researches tools, frameworks and mechanisms for data analytics

•Designs and delivers end-user training and training materials

•Supports IT goals and objectives by being a proactive member of the Data Services team

Minimum Qualifications

Requires a bachelor’s degree in area of specialty or equivalency 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.


•Bachelor’s degree in Business, Computer Science, Information Systems or related field

•2-4 years of Business Analysis or related technical experience

•2-4 years full Microsoft Business Intelligence Stack (SSIS,SSRS,SSAS)

•Strong experience ofSQLServer 2008/2012/2014/2016

•Experience with 2013/2016 SharePoint Server

•Demonstrated ability to meet deadlines, balance multiple priorities, and ensure quality standards based on an Agile Development process

•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

•Hands-on experience withSSISto create and executeETLpackages a plus

•Experience with theMDXorDAXanalytical querying language is a plus

•SAS, R, Python preferred

•Knowledge of Tableau

•Healthcare experience

Type Benefited Staff

Special Instructions Summary

Additional Information

The University of Utah is an Affirmative Action/Equal Opportunity employer and is committed to diversity in its workforce. In compliance with applicable federal and state laws, University of Utah policy of equal employment opportunity prohibits discrimination on the basis of race or ethnicity, religion, color, national origin, sex, age, sexual orientation, gender identity/expression, veteran’s status, status as a qualified person with a disability, or genetic information. Individuals from historically underrepresented groups, such as minorities, women, qualified persons with disabilities, and protected veterans are strongly encouraged to apply. Veterans’ preference is extended to qualified applicants, upon request and consistent with University policy and Utah state law.

To inquire about this posting, email: or call 801-581-2300. Reasonable accommodations in the application process will be provided to qualified individuals with disabilities. To request an accommodation or for further information about University AA/EO policies, please contact the Office of Equal Opportunity and Affirmative Action, 201 S. Presidents Cr., Rm 135, (801) 581-8365 (V/ TDD ), email: .

The University is a participating employer with Utah Retirement Systems (“URS”). To be eligible for retirement contributions, you must be hired into a benefit-eligible position. Certain new hires are automatically assigned to the URS retirement plan and other employees with prior URS service, may elect to enroll in the URS within 30 days of hire. Regardless of whether they are hired into a benefit-eligible position or not, individuals who previously retired and are receiving monthly retirement benefits from URS must notify the Benefits Department upon hire. Please contact Utah Retirement Systems at (801)366-7770 or (800)695-4877 or the University’s Benefits Department at (801)581-7447 for information.

This position may require the successful completion of a criminal background check and/or drug screen.