University of Utah Data Warehouse Analyst Sr in Salt Lake City, Utah


Open Date 04/16/2018

Requisition Number PRN16920B

Job Title Data Warehouse Analyst Sr

Working Title Sr Data Warehouse Developer/Analyst

Job Grade G

FLSA Code Computer Employee

Patient Sensitive Job Code? No

Standard Hours per Week 40.00

Full Time or Part Time? Full Time

Shift Day

Work Schedule Summary

M-F 8:00 am – 5:00 pm

VP Area Academic Affairs

Department 00286 - Budget and Analysis

Location Campus

City Salt Lake City, UT

Type of Recruitment External Posting

Pay Rate Range 75000 to 115300

Close Date

Open Until Filled Yes

Job Summary

The Sr Data Warehouse Developer/Analyst is a new position in the Office of Budget and Institutional Analysis at the University of Utah. This is a senior role for experienced data warehouse professionals. We are looking for someone that can bring their knowledge of data warehouse design, methodologies and techniques to our projects, and mentor and assist other team members in developingSQL,ETL, the meta data layer and data quality measures.

The ideal person will care about designing meaningful data transformations, ensuring quality data, building sustainable code, and understand strategies to meet these objectives.

This role will partner closely with the University’s central IT department that manages the campus enterprise data warehouse. The incumbent will have a primary role in building, testing and maintaining the meta data layer of our data warehousing environment, data management processes, and upstream ETL’s, with a supporting role across our end-to-end BI delivery, including requirements solicitation, business analysis, logical and physical design, report and dashboard development.

The University offers an amazing benefits package, including a fully-funded retirement plan for qualified individuals, with university contributions at an amount equal to 14.2% of the employee salary and no vesting period, generous paid leave time, great health insurance with employee costs significantly lower than many area employers, free transit on mostUTAbus and train services, 50% tuition reduction, among other benefits. See our benefits website for more information on the amazing package:


The primary responsibilities of this position will include:

•Create and maintain tables, queries, views, procedures, packages, indexes, functions, triggers.

•Write sql procedures and scripts to carry out data audits and manage data cleanup.

•Build, test and maintain extract, transform, load processes.

•Solve complex technical problems.

•Help design data models that simplify reporting and support front-end BI reporting tools.

•Create, maintain and advocate for strong data dictionary, requirements, design and process documentation.

•Carry out, share, and guide other team members in the practical application of data warehousing tools, concepts and best practices.

•Build collaborative working relationships with IT, campus administrative offices, internal developers and analysts, and others to serve as an effective liaison between teams.

•Serve as a leader in researching and adopting new tools and technologies.

Minimum Qualifications

Requires a bachelor’s degree in area of specialty or equivalency and 4-6 years of experience in the field or in a related area.

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


•4-6+ years of progressively responsible data warehouse orETLdevelopment experience, with at least 2 of those years in a role with significant data analysis or report development responsibilities.

•ExpertSQLskills, experience in Oracle Database 12c, OracleSQLDeveloper and InformaticaETLis a plus.

•Experience transforming large, complex, unstructured data into denormalized star or snowflake schemas.

•Working knowledge of leading data warehouse methodologies such as Kimball or Inmon.

•Strong communication and documentation skills.

•A Master’s degree inMISor related field.

•Experience with higher education data such as student, faculty, HR and finance.

•Experience with institutional research, including state and federal reporting such asIPEDS, and national surveys.

•Background in PeopleSoft, Tableau,SAPBusiness Objects Web Intelligence, or similar systems and BI Tools.

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.