Data Engineers

The University of Utah’s University Analytics & Institutional Reporting office seeks a data engineer to design, build, test, implement, and maintain data transformation pipelines. The role supports trusted university reporting and analytics through data modeling, quality processes, SQL queries, and documentation.

Responsibilities

Research source data structures, relationships, content and quality. Support requirements discovery

Design, build, implement, and maintain data transformation pipelines, processes and reporting structures formatted to support data science, strategic reporting, master data sources, enterprise integrations, point-in-time snapshots and more

Help automate and manage data quality audits and correction processes

Write complex SQL queries to support analytics needs

Develop and maintain data and process documentation, including data flow diagrams, data concepts, keys, definitions, process steps, etc

Share your ideas and knowledge, be open to learning from others, and grow with the team as we explore new ideas, methods and tools in our journey of continuous forward progress

Other duties as assigned

Preferred

Advanced Oracle SQL skills to query and manipulate data, create and manage objects

experience and acumen to move complex data transformation projects forward under minimal supervision

6 or more years of experience in any of the following areas:

Relational database or data warehouse programming/development with an aptitude for translating business needs into sound technical solutions

Data reporting and analysis, building queries from large relational databases to audit data, perform ad hoc analysis, generate standard reports, with a strong understanding of the back-end structures that facilitate reporting

Higher education administration with broad and deep knowledge of student, faculty, HR or finance data and processes, or experience managing data in an institutional research (IR) setting

Business systems analysis with a strong understanding of requirements analysis, data and process flows, liaising with functional and technical groups, testing, auditing data, troubleshooting and issue resolution

Experience with PeopleSoft data, Tableau, Lucid Chart, and/or similar ERP systems, visualization and diagramming tools

Experience building data pipelines in AWS using tools such as Glue and Apache Airflow

A Master's degree in MIS or related field

Advanced Oracle SQL

Data Querying

Database Object Management

Data Transformation

Relational Database Development

Data Warehouse Development

Business Requirements Translation

Data Reporting

Query Development

Ad Hoc Analysis

Standard Report Generation

Data Auditing

Back-End Data Structures

Higher Education Administration

Student Data

Faculty Data

HR Data

Finance Data

Business Systems Analysis

Requirements Analysis

Data Flow Analysis

Process Flow Analysis

Functional-Technical Coordination

Testing

Issue Resolution

PeopleSoft

Lucidchart

ERP Systems

Diagramming Tools

Data Pipeline Development

AWS

AWS Glue

Apache Airflow

Master's in MIS

Independent Work

Business-Technical Communication

Analytical Thinking

Benefits

Personal (401a) retirement account with employer contribution of 14.2%

Highly competitive health insurance

Generous paid leave time

Free public transportation pass (UTA)

50% tuition reduction for eligible employee and family members

Hybrid work environment with the ability to work from campus 3 days per week; residence in the state of Utah is required

Company

Flagship higher-education, research, and teaching institution in Utah

Salt Lake City, Utah, USA

http://utah.edu/

Founded in 1850

10001+ employees

Qualifications

Our office is not currently able to support individuals seeking sponsorship for visa

Bachelor's degree and 6 years of experience, or master's degree and 4 years of work experience in institutional research, business analytics, data science or related field

Proficiency in querying, manipulating and analyzing complex datasets

Excellent interpersonal and communication skills and the ability to present complex data to both technical and non-technical audiences

Demonstrated experience with data visualization tools such as Tableau, Microsoft Power Bi, etc

Experience with data querying languages such as SQL

Proficiency in python coding

Experience working with API's

Demonstrated ability to manage multiple projects and work collaboratively across teams

Data Engineer, II: Requires a bachelor's (or equivalency) + 4 years or a master's (or equivalency) + 2 years of directly related work experience

Data Engineer, III: Requires a bachelor's (or equivalency) + 6 years or a master's (or equivalency) + 4 years of directly related work experience

Data Engineer, IV: Requires a bachelor's (or equivalency) + 8 years or a master's (or equivalency) + 6 years of directly related work experience

Data Engineer, V: Requires a bachelor's (or equivalency) + 10 years or a master's (or equivalency) + 8 years of directly related work experience

Advanced Oracle SQL skills to query and manipulate data, create and manage objects

Experience and acumen to move complex data transformation projects forward under minimal supervision

6 or more years of experience in any of the following areas:

Relational database or data warehouse programming/development with an aptitude for translating business needs into sound technical solutions

Data reporting and analysis, building queries from large relational databases to audit data, perform ad hoc analysis, generate standard reports, with a strong understanding of the back-end structures that facilitate reporting

Higher education administration with broad and deep knowledge of student, faculty, HR or finance data and processes, or experience managing data in an institutional research (IR) setting

Business systems analysis with a strong understanding of requirements analysis, data and process flows, liaising with functional and technical groups, testing, auditing data, troubleshooting and issue resolution

Experience with PeopleSoft data, Tableau, Lucid Chart, and/or similar ERP systems, visualization and diagramming tools

Experience building data pipelines in AWS using tools such as Glue and Apache Airflow

A Master's degree in MIS or related field

Required skills

Oracle SQL, Python, API Integration, Tableau, Microsoft Power BI, Relational Database Development, Data Warehousing, Data Pipelines, AWS Glue, Apache Airflow, PeopleSoft, Lucidchart

Preferred skills

6 or more years of experience in any of the following areas:, A Master's degree in MIS or related field

Experience

2+ years