Additional Verification Required

Data Engineer

11 October 2024
Apply Now
Deadline date:
£75000 - £120000 / year

Job Description

University Analytics & Institutional Reporting (UAIR) is seeking an intermediate or senior-level Data Engineer to join our Data Warehouse Team. This role will participate in and may lead the design, build, testing, implementation and maintenance of data transformation pipelines. The incumbent will follow our department’s general design guidelines and approaches, but have wide latitude for independent judgment and extensive opportunity to contribute to the ideas and knowledge that shape our strategies and direction forward.
This is a remote position with the potential for some onboarding and infrequent meetings in-person. Incumbents are required to live and work in the U.S. Remote work arrangements are subject to change at any time and will be reviewed annually.

About University Analytics & Institutional Reporting

The UAIR office houses a transformational group of data professionals that turn complex university data into information trusted by leadership to drive strategic decisions, generate official university figures, and support the data needs of academic campus as a whole.
As a member of the team, you’ll work with a group of SQL developers dedicated to delivering thoughtful data pipeline and process designs, and wrangling data with care. We operate with an iterative mindset of continuous improvement, adapting strategies and code as we go. We believe the strengths and knowledge each person brings to the team bolster our collective work, and aim for a collaborative environment where we thrive together while tapping into our strongest individual contributions. If you’re the type of person who loves data and wants to know your work has meaning, you may find your career home in our office.
About the University of Utah
Located in Salt Lake City, in the foothills of the Wasatch Mountains, the University of Utah is the flagship institution of the State of Utah’s system of higher education, a tier-one research institution with membership in the Association of American Universities (AAU) and Big 12 Athletic Conference.

The University offers a strong benefits package, including a personal (401a) retirement account with employer contribution of 14.2% and immediate vesting, highly competitive health insurance, generous paid leave time, free public transportation pass (UTA), 50% tuition reduction for eligible employee and family members, and more: https://benefits.utah.edu/.

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.

Minimum Qualifications
  • Bachelor’s degree in area of specialty (one year of education can be substituted for two years of related work experience) and 2-4 years of experience in the field or in a related area.
  • Proficiency using Oracle SQL or similar programming language to query and manipulate data, create and manage database objects.
  • Solid understanding of relational database concepts.
  • A problem solver at heart, energized by a data challenge, ready to independently dive in and uncover the source of an issue or explore new data.
  • Strong attention to detail with an analytical mindset, willing to work in the weeds, able to see and support the big picture.
  • Professional interpersonal skills, will thoughtfully and productively collaborate with and support the contributions of a variety of technical and non-technical groups and individuals.

Preferences
  • 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:
o Relational database or data warehouse programming/development with an aptitude for translating business needs into sound technical solutions.
o 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.
o 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.
o 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.
  • A Master’s degree in MIS or related field.

Type
Benefited Staff

Special Instructions Summary

Additional Information
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.

Posting Specific Questions

Required fields are indicated with an asterisk (*).

  • * Do you have a related Bachelor’s degree or equivalency? (2 years related work experience may be substituted for 1 year of education)
    • Yes
    • No
  • * Indicate your level of knowledge/expertise in Advanced SQL, ETL, data analysis and data modeling.

    (Open Ended Question)

  • * How many years of experience using SQL do you have?

    (Open Ended Question)

  • * Are you legally eligible to work in the U.S.?

    (Open Ended Question)

  • * Will you now or in the future require visa sponsorship for employment?

    (Open Ended Question)

Applicant Documents

Required Documents

  • Resume
  • Cover Letter

Optional Documents

  • Appropriate discharge document (such as a DD-214 – Member Copy 4) – Veteran Only – Call 801.581.2169
  • Addendum to the University of Utah – Veteran Only – Call 801.581.2169 after submission

Open Date
10/07/2024

Requisition Number
PRN40043B

Job Title
Data Warehouse Analyst

Working Title
Data Engineer

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 Remote

VP Area
Academic Affairs

Department
00002 – SR VP Academic Affairs Oper

Location
Campus

City
Salt Lake City, UT

Type of Recruitment
External Posting

Pay Rate Range
75000 to 120000

Close Date
11/30/2024

Open Until Filled
No


EWJP2