Data Warehouse Analyst Sr
DetailsOpen Date 12/06/2024Requisition Number PRN40529BJob Title Data Warehouse Analyst SrWorking Title Data Warehouse Analyst SrJob Grade GFLSA Code Computer EmployeePatient Sensitive Job Code? NoStandard Hours per Week 40Full Time or Part Time? Full TimeShift DayWork Schedule SummaryMonday – FridayVP Area Academic AffairsDepartment 00002 - SR VP Academic Affairs OperLocation CampusCity Salt Lake City, UTType of Recruitment External PostingPay Rate Range 75,000 to 120,000Close Date 12/13/2024Priority Review DateJob SummaryUniversity Analytics & Institutional Reporting ( UAIR ) is seeking a 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 position is primarily remote with the potential for some onboarding and infrequent meetings in-person. Preference will be given to candidates that reside in or are willing to relocate to Utah within a commuting distance to the main U of U campus in Salt Lake City prior to start. Remote work arrangements are subject to change at any time and will be reviewed annually.About University Analytics & Institutional ReportingThe 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 UtahLocated 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 QualificationsRequires a bachelor’s degree in area of specialty or equivalency (one year of education can be substituted for two years of related work experience) and 4-6 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.Departmental Qualifications
Advanced Oracle SQL skills to query and manipulate data, create and manage objects.
Solid understanding of relational database concepts.
Experience and acumen to move complex data transformation projects forward under minimal supervision.
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.
PreferencesExperience with PeopleSoft data, Tableau, Lucid Chart, and/or similar ERP systems, visualization and diagramming tools.A Master’s degree in MIS or related field.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.
Type Benefited StaffSpecial Instructions SummaryAdditional InformationThe 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.eduhttps://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.