University of Colorado - Denver, CO
posted about 2 months ago
The Principal Data Warehouse Engineer will play a crucial role in supporting the University of Colorado's growing needs for data-driven decision-making through the use of an enterprise data warehouse, data integrations, analytics, and business intelligence initiatives. This position is integral to the university's ETL team and will serve as a domain expert in data warehousing, applying industry-standard processes. The role requires extensive collaboration with various departments, including Procurement Services, Campus Solutions, Finance, Human Resources, Advancement, and Grants and Research, as well as UIS departments such as database administrators, system admins, middleware, infrastructure, production services, enterprise data architects, developers, and quality assurance testers. The Principal Data Warehouse Engineer will be responsible for conducting data engineering tasks, which include requirement gathering, ETL development, system testing, deployments, documentation, and production support. The role involves working with data sources such as CU's PeopleSoft Student, HCM, Finance, InfoEd, and Advancement systems. The engineer will also engage in data and BI business/data analyst efforts, collaborating with key partners to gather requirements and assist with User Acceptance Testing. Additionally, the engineer will design supportable solutions to meet customer needs and support CU's long-term business goals through the development of new data warehouse data marts and enhancements to existing data marts and reports. This position will require the creation and maintenance of source to target mappings across multiple domains at the University, as well as the use of development tools including IBM DataStage, SAS, and Perl. The engineer will act as a domain expert in ETL Development and Solutions Architecture, providing support and guidance to ETL developers throughout all phases of the Software Development Life Cycle (SDLC). The role also includes planning and conducting system integration test cases to ensure successful solutions, deploying code and objects through various SDLC environments, and investigating data, process, logic, or scheduling issues to identify root causes and resolution plans. As a technical lead, the Principal Data Warehouse Engineer will participate in technology projects and initiatives, working closely with project managers to identify technical solutions and track project plans. The engineer will also lead and mentor team members on data and BI concepts and best practices, provide recommendations on data strategies and application infrastructure, and assist in designing a multi-year data warehouse roadmap. Continuous education and professional development are encouraged, including attending trainings and conferences and engaging in self-directed learning.