Utah State University
Data Engineer
Job Description
About University Analytics & Institutional Reporting
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/.
- 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.
- 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.
- 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:
- 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.
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
- 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
EWJP2
