Principal Data Warehouse Engineer

Position Summary:University Information Services (UIS) provides technical services and enterprise applications to the University of Colorado campuses and the Office of the President. UIS is committed to excellence in customer service and technical expertise. Through the development of enterprise applications, UIS supports the University as a whole with systems used by students, faculty, human resources employees, finance employees, and others.The Principal Data Warehouse Engineer will support the university’s quickly growing needs and demands to make data driven decisions, using an enterprise data warehouse, data integrations, analytics, and business intelligence initiatives. This role will be a key member of the university’s ETL team and will serve as a Data Warehouse domain expert applying standard processes in the industry. This role requires collaboration with leaders, developers and analysts from the Procurement Services Center, Campus Solutions, Finance, Human Resources, Advancement and Grants and Research departments from all four campuses and UIS departments such as database administrators, system admins, middleware, infrastructure, production services, enterprise data architects, developers, and quality assurance testers. This position reports to the Assistant Director of Data and Business Intelligence and is exempt from the State of Colorado Classified Staff system.Where You Will Work:This role is eligible to work remotely within the United States.Diversity and Equity:The University of Colorado System Administration Office is committed to recruiting and supporting a diverse workforce. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnic minorities, persons with disabilities, persons within the LGBTQ+ community and all veterans.Duties & Responsibilities:Duties and responsibilities of the position include, but are not limited to: - Conduct data engineering, including requirement gathering, Extract, Transform and Load (ETL) development, system testing, deployments, documentation, and production support with data sources such as CU’s PeopleSoft Student, HCM, Finance, InfoEd, and Advancement systems - Partner with team on data and BI business/data analyst efforts to collaborate with key partners gathering requirements and assist with User Acceptance Testing - Design supportable solutions to satisfy customer needs and support CU’s long-term business goals via new data warehouse data marts and enhancements to existing data marts and reports - Conduct data profiling and analysis - Create conceptual, logical, and physical data models for simple to medium complexity work efforts - Create and maintain source to target mappings across multiple domains at the University - Use development tools including IBM DataStage, SAS, and Perl Acts as a domain expert in ETL Development and Solutions Architecture - Partner with management to allocate responsibilities among ETL developers - Provide support and guidance to ETL developers, as required for all Software Development Life Cycles (SDLC) phases - Plan and/or conduct system integration test cases (SIT) to ensure solutions are successful throughout the entire system - Deploy code and objects through SDLC environments including development, QA, and Production along with partnering with production services to ensure the correct job scheduling is in place - Investigate data, process, logic, or scheduling issues to identify the root cause, mitigation, and resolution plans - Participate in technology projects and initiatives as a technical lead working with the project manager to identify the technical solutions and track project plans, estimates, cut over plans, resources, and communications. For smaller efforts without a project manager, this position will lead the effort assigning tasks to owners with timeframes identified along with the communication and follow-up required to ensure the work is completed successfully on time. - Lead, advise, and mentor team members on data and BI concepts and standard methodologies - Provide recommendations on data strategies, platforms, and application infrastructure required to implement solutions - Assist with design and leading a multi-year data warehouse roadmap, balancing short- and long-term goals and investments to scale and deliver our solutions globally and fulfill the organization's high-level reporting & analytics needs - Participate in and lead peer design and code reviews - Partner with BI team to communicate data warehouse enhancements and suggest modifications to Cognos Framework Manager - Continue education and professional development including attending trainings and conferences and self-directed learning

What We Offer:Salary: The anticipated hiring range has been established at $113,000-$116,700.Benefits: With our unparalleled range of benefits, including top-notch healthcare, comprehensive wellness programs, enriching professional development, and a dynamic work-life balance, we ensure your holistic growth and happiness. Additional taxable fringe benefits may be available.Minimum Qualifications:You must meet all minimum requirements listed at the time of application to be considered for this role. - Bachelor’s degree from an accredited institution of higher education, or equivalent professional experience (professional experience may be substituted for the educational requirement on a year-for-year basis) - Four (4) years of experience to include any of the following: - IBM DataStage or equivalent - Data modeling or database design or Data Warehouse/Mart design or data architecture - Kimball methodologies including star schema design, and accumulating and periodic snapshots - SQL, including familiarly with Oracle analytic functions and techniques for tuning large-volume queries - Administration of an ETL or middleware tool (DataStage, ODI, Informatica, OSB, etc.)

Preferred Qualifications: - Bachelor’s or post-baccalaureate degree from an accredited institution of higher education in computer science, computer engineering, information systems, information technology, or related field of study - Six (6) years’ equivalent experience to include any of the following: - IBM DataStage or equivalent - Kimball methodologies including star schema design, and accumulating and periodic snapshots - SQL, including familiarly with Oracle analytic functions and techniques for tuning large-volume queries - Experience in one or more of the following: - Commitment SDLC standard processes as they relate to data warehousing - Experience working in a Linux environment and with shell scripting (Perl/Korn) - Technical Lead experience managing a development team responsible for the design, development and implementation of highly sophisticated programs, scripts, data objects resulting in high quality and performance - Working in a University or Higher Education setting - Java and PL/SQL programming - PeopleSoft data models including Campus Solutions, Finance, and/or HCM version 9.0 or higher - One or more projects to implement an ETL or information management tool

Knowledge, Skills, and Abilities: - Knowledge of ETL Architecture, ETL Tools, Kimball Methodology, and SQL - Ability to use Oracle analytic functions and techniques - Ability to use and understand standard processes regarding SDLC and data warehousing - Ability to work in a Linux environment with shell scripting - Ability to document, manage, and test multiple projects at once - Ability to manage and develop team skills - Collaboration skills to work with others from different areas and backgrounds to reach a common goal - Digital literacy to use Microsoft Office programs (i.e., Word, Excel, Outlook, etc.) and learn and experiment with new software and systems - Interpersonal skills to facilitate interaction, communication, and teamwork between others - Oral, written, and listening communication skills to accurately interpret what others are saying and convey messages, information, concepts, and details accurately and clearly

How to Apply:For full consideration, please attach the following as separate documents to your application:1. A cover letter identifying the job specific minimum qualifications you possess2. A resume including any and all relevant experience to be accurately assessed against the qualifications listed in the posting.When to Apply:For full consideration completed applications must be submitted by February 9th. Reference checking is a standard step in our hiring process. You may be asked to provide contact information, including email addresses, for up to five references as part of the search process for this position. Please note: All application materials must be submitted through CU Careers; emailed materials will not be considered.Sponsorship Statement:We are unable to sponsor applicants for work visas for this position.Background Check Statement:The University of Colorado is committed to providing a safe and productive learning and living community. To achieve that goal, we conduct background investigations for all final applicants being considered for employment. Background investigations include a criminal history record check, and when appropriate, a financial and/or motor vehicle history. The Immigration Reform and Control Act requires that a verification of employment eligibility be documented for all new employees by the end of the third day of work. The University of Colorado is committed to diversity and equality in education and employment.ADA Statement:We are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting. Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: systemhr@cu.edu.