Job Information

University of Utah Data Architect in Salt Lake City, Utah

Open Date 06/11/2021

Requisition Number PRN26468B

Job Title Data Architect

Working Title Data Architect

Job Grade G

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

VP Area U of U Health - Academics

Department 00952 - Division of Epidemiology

Location Campus

City Salt Lake City, UT

Type of Recruitment External Posting

Pay Rate Range 60,700 to 101,649

Close Date

Open Until Filled Yes

Job Summary

Work with talented team of developers, researchers and clinicians in the University of Utah Division of Epidemiology to build application systems in an agile/scrum environment. Architect for tenant analytic environments within the VA Corporate Data Warehouse infrastructure. Responsible for stage and data mart modeling, ETL patterns and daily load operations as well as reporting and cube implementations.

Supports prototype data engineering projects through tuning and augmentation. Responsible for reliability engineering of growing services and working new elements into a unified model. Supporting ongoing data quality efforts through metadata management and ETL automation. Responsible for the integration and adoption of new features in defined software toolkits.

Must be a proficient data engineer familiar with Microsoft Business Intelligence stack. Experience in TSQL and SSIS required with SSRS , SSAS and Pyramid Analytics preferred.

Familiar with Kimball Data Warehouse concepts in both modeling and ETL processing.

Previous experience within the VA data system and/or with healthcare data preferred.

Opportunity for advancement to lead developer depending upon experience and performance.

This position is considered Category IIA : Not required on campus and has the ability to telework remotely for the duration of the University of Utah’s response to COVID -19. An employee hired into this role will be responsible for providing space, telephone, printing, networking and/or internet capabilities at the telecommute location and agree to the terms of the University of Utah campus and Health Academics COVID -19 Telecommuting Agreement.

Responsibilities

Must be able to independently perform all activities with minimal oversight and high degree of quality.

Responsible for:

• All daily data operations (Data Refresh SLA )

• Data quality issues

• Storage and compute resource management

• Merge and Deploy operations

• Database performance for ETL and Reports

Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. Works under general supervision. A certain degree of creativity and latitude is required. Typically reports to a supervisor or manager.

This job description 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.

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 or equivalency in a related area and 2-4 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.

Preferences

Type Benefited Staff

Special Instructions Summary

Additional Information

The University of Utah values candidates who have experience working in settings with students from diverse backgrounds and possess a strong commitment to improving access to higher education for historically underrepresented students.

Individuals from historically underrepresented groups, such as minorities, women, qualified persons with disabilities and protected veterans are 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:

Director/ Title IX Coordinator

Office of Equal Opportunity and Affirmative Action ( OEO /AA)

135 Park Building

Salt Lake City, UT 84112

801-581-8365

oeo@utah.edu

Online reports may be submitted at oeo.utah.edu

For more information: https://www.utah.edu/nondiscrimination/

To inquire about this posting, email:employment@utah.edu (%20employment@utah.edu) or call 801-581-2300.

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 (801) 581-7447 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 (801) 366-7770 or (800) 695-4877 or University Human Resource Management at (801) 581-7447 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.