Data Warehouse Analyst Sr. - University of Utah
Open Date 01/26/2018
Requisition Number PRN16175B
The Office of Budget & Institutional Analysis is seeking a Sr Data Warehouse Analyst with strong experience in the design and development of dimensional data warehouse models to support our internal data landscape, help drive improvements in our design, techniques and maintenance processes, and help build out the semantic layer of our reporting environment.
Our team is comprised of skilled data gurus, passionate about our role in reporting official university data and providing analysis used by University leadership in making data-informed decisions. We manage a varied data landscape with multiple data sources and leverage several BI tools. This position will share technical expertise in support of the end-to-end BI solution, with primary emphasis in managing our internal database schemas, data quality, and serving as liaison to the University’s central UIT Business Intelligence team, collaborating onETLprocesses and DBA support functions.
This brief description is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to the job.
The primary responsibilities of this position will include:
•Serve as a leader in researching and adopting new tools and technologies
•Build relational database objects
•Write sql procedures and scripts to carry out data audits and manage data cleanup
•Develop and maintainETLprocesses
•Design data models to support front-end BI reporting tools, such as Tableau
•Solve complex technical problems
•Gather and document reporting requirements
•Collaborate with leadership, IT, and internal analysts and external offices
Requires a bachelor’s degree in area of specialty or equivalency 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.
Strongly preferred qualification
•Have a sound understanding of Business Intelligence best practices, relational structures, and dimensional data sets
•Demonstrate expert OracleSQLskills
•Experience with data quality management
•Applicants must demonstrate the potential ability to perform the essential functions of the job as outlined in the position description.
•A Master’s degree inMISor related field
•Experience in data analysis
•Experience with higher education data, including HR and financials
•Experience with PeopleSoft, InformaticaETL,SAPBusiness Objects Web Intelligence, Tableau, or similar systems and BI Tools.
Apply at employment.utah.edu.