Architect, Data Warehouse, Decision Support
University of Nevada, Reno
Reno, NV
Job posting number: #7113181
Posted: October 12, 2022
Application Deadline: Open Until Filled
Job Description
Job DescriptionThe University of Nevada, Reno Office of Decision Support seeks candidates for the position of Architect, Data Warehouse.
The Architect, Data Warehouse reports to the Manager, Decision Support and leads development and maintenance of the campus enterprise data warehouse. This includes data extraction from third party applications as well as the mapping and uploading of data from various sources to the warehouse, including, but not limited to, student information, finance, and human resource systems. The Architect ensures data integrity in the data warehouse, assuring consistency of data elements for historical reporting trends as well as the design and maintenance of report-oriented data structures. This position provides extensive data warehouse end user support, shares expert knowledge of data structures, and serves as a resource concerning the data warehouse, data structures and SQL queries/ETL processes.
The ideal candidate should be a self-motivated individual capable of transforming theoretical data requirements into real-world solutions.
Required Qualifications
Bachelor’s Degree and four (4) years of related professional work experience OR Master’s Degree and two (2) year of related work experience
Relevant Experience: information technology experience including relational database and some data warehouse experience and SQL or related
Preferred Qualifications
Knowledge of:
Star Schema data models
Cloud Data Architecture (Amazon/Microsoft/Google, etc.)
ETL/ELT development and management (using various tools/programming languages)
Data Quality monitoring
Microsoft Powershell
Workday
Peoplesoft Campus Solutions
Data Indexing/Query Optimization
Calendar/Date modeling
Data Privacy/Data Security
Compensation Grade
Administrative Faculty - C