Data Engineer
Salary undisclosed
Apply on
Original
Simplified
Details
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
Job Summary
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:
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 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 or or University Human Resource Management at 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:
Online reports may be submitted at oeo.utah.edu
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.
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
Job Summary
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:
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 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 or or University Human Resource Management at 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:
Online reports may be submitted at oeo.utah.edu
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job Similar Jobs
