Job Information
University of Utah Data Warehouse Architect in Salt Lake City, Utah
Details
Open Date 07/11/2024
Requisition Number PRN39142B
Job Title Data Architect
Working Title Data Warehouse 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
- M-F 8am – 5pm, additional as required
VP Area President
Department 00417 - UIT Univ Support Services
Location Campus
City Salt Lake City, UT
Type of Recruitment External Posting
Pay Rate Range 90,000 - 95,000
Close Date
Open Until Filled Yes
Job Summary
UIT -University Support Services has an immediate opening for a Data Architect. This position supports the data architecture, data modeling, and creation and maintenance of ETL workflows within the University of Utah’s Data Management and Analytics group in UIT on Main campus.
The direct responsibilities for this position will be to support the Vice President for Research ( VPR ) data needs, research administration related data, and overall research data governance. This position will report to UIT but will have a strong line of communication and shared oversight with the Vice President for Research Office, and specifically the Research Data Analytics group in the Office of Research Information Systems ( ORIS ).
Responsibilities
This position will be responsible for development of data movement, maintenance of the metadata layer, and designing of ETL jobs and data models, as well as daily maintenance of technical and business requirements for the entire Data Management life cycle. This position will be dedicated to working with the VPR Office and in turn the ORIS Office.
This may include gathering requirements from their user community; the design, development/implementation, and maintenance of data models, creating ETL programs, semantic layers, reports and dashboards, metadata definition, and end user training. Translates business requirements into conceptual, logical, and physical data models. Coordinates data integrity and migration activities to eliminate redundancy and to improve operating efficiency. Works with a team to design, build, and support a strategic data management and integration initiative to support university-wide data needs. Other duties as assigned.
Designs, build, and maintain relational and non-relational databases for data storage or processing
Develops strategies for data warehouse implementation, data acquisition, and archive recovery.
Evaluate new data sources for adherence to the organization’s quality standards and ease of integration.
Oversee and maintain all current VPR data needs in the university’s data warehouse.
Work with data stewards to ensure data integrity and overall compliance with university regulations
Troubleshoots data warehouse software. Identifies and works with appropriate staff to resolve technical issues.
Monitoring and recovery of ETL jobs, which may require working earlier in the AM.
Responsible for attending weekly coordination meeting to understand IT changes that could impact data flows.
Responsible for weekend work required to maintain our ETL flows during IT maintenance weekends which currently occurs around once every 2 months.
Minimum Qualifications
Requires a bachelor’s degree or equivalency (one year of education can be substituted for two years of related work experience) 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
Highly proficient in SQL , preferably in an Oracle environment
Knowledgeable about data warehousing concepts
Experience with Informatica PowerCenter
Experience with cloud based ETL technologies (NiFi, Jitterbit)
Experience with metadata management tools
Experience with at least one programming language (Python, R, C/C++, Java, etc)
Knowledgeable about data governance best practices
Experience in research administration and/or higher education
Type Benefited Staff
Special Instructions Summary
Additional Information
About UIT :University Information Technology ( UIT ), the central IT service provider for the University of Utah, reports to the U’sChief Information Officerand is responsible for many of the U’s shared IT services including the wired and wireless network; Campus Information Services ( CIS ) portal; UMail, telephone, and online collaboration; digital learning technologies; information security; software licensing; and a host of other IT systems and services.
About the University of Utah : Located in Salt Lake City, the U is the flagship institution of the State of Utah’s system of higher education, home toarts and museum venuesand a member of theBig 12 Conference.Skiing and snowboarding opportunitiesare a short distance from campus, and opportunities to pursue activities frombiking to hiking to fishing abound. Salt Lake City is home to theUtah Symphony and Opera,Ballet West,professional sports teams, and a wide range of other cultural and recreational activities.
University of Utah Benefits
·Health, dental, and wellness coverage
Automatic and immediately vested14.2% employer contributionto personal retirement account (401a)
Freepublic transportation pass(Utah Transit Authority)
·Paid leave time
·Reduced tuition benefits for employee and family members
More information:https://www.hr.utah.edu/benefits/
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.
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: https://www.utah.edu/nondiscrimination/
Online reports may be submitted at oeo.utah.edu
https://safety.utah.edu/safetyreport 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.
