Department Information

To apply, please go to: https://cu.taleo.net/careersection/2/jobdetail.ftl?job=38064

Join Our Team and Make a Difference in Higher Education!

At the System Administration office at the University of Colorado, we are dedicated to building a workplace where everyone feels valued, supported, and empowered to thrive. Our office is committed to fostering a culture where employees find community, a sense of belonging, and the opportunity to contribute meaningfully to our mission and purpose.

By joining our team, you’ll have a direct impact on shaping the future of higher education. In addition to the Office of the Board of Regents, the University of Colorado’s system administration includes 19 units that provide essential services to CU’s campuses in Aurora, Boulder, Colorado Springs, and Denver, as well as the Office of the President. While not a part of any one campus, we are proud to serve in the centralized office for the University system. Together, we ensure CU continues to deliver outstanding education, groundbreaking research, and valuable service to our communities.

We believe in creating an environment where the unique experiences and perspectives of everyone are embraced, enriching the work we do and the strategic outcomes we pursue. If you’re passionate about making a difference, contributing to a dynamic team, and supporting a mission that matters, we encourage you to apply and be part of our journey. Learn more about CU System Administration.

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 Colorado.

Description of Job

Duties and Responsibilities:

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
Conduct data and BI business/data analyst efforts collaborating with key partners to gathering requirements and assist with User Acceptance Testing (UAT)
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 detailed data profiling and data analysis for data modeling and design
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, shell scripting 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, processes, logic, or scheduling issues to identify the root cause, mitigation plans, 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 team meetings, peer design and code reviews
ETL DataStage administration including tool and Linux structure configuration, setup and monitoring of the health of the environment.
Partner with BI team to communicate data warehouse enhancements, suggest architecture modifications to Cognos Framework Manager
Continue education and professional development including attending trainings and conferences and self-directed learning

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights

Minimum Qualifications:

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 data warehousing & BI SDLC
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
Organizational skills to set and meet goals, manage appointments, create schedules, coordinate and facilitate meetings, and make decisions
Ability to work under stress, handle multiple concurrent and contending tasks and responsibilities, and adapt to changing priorities while maintaining personal effectiveness
Ability to prioritize work, meet goals, and stay on task when completing special projects and daily assignments
Ability to work independently with minimal direction and reliable professional judgment, as well as collaboratively with a team to achieve desired results
Ability to maintain a good work ethic, positive problem-solving demeanor, and passion for the work performed
Ability to self-start and take initiative in completing daily tasks and special projects
Ability to focus on activities that have the greatest impact on meeting work commitments
Ability to establish and maintain partnerships with a variety of internal and external constituencies
Ability to communicate and work effectively with individuals from a diverse set of backgrounds, cultures, and ages

Supplemental Information

How to Apply:

For full consideration, please attach the following as separate documents to your application at https://cu.taleo.net/careersection/2/jobdetail.ftl?job=38064:

A cover letter identifying the job specific minimum qualifications you possess
A resume including any and all relevant experience to be accurately assessed against the qualifications listed in the posting.

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.

No-cost or low-cost medical & dental plan options, some inclusive of IVF assistance.
Disability, Life, Vision Insurance options.
Multiple retirement planning options including a mandatory 401(a) plan where CU contributes 10% of your gross pay, a 401k or 403b plan and a 457 deferred compensation plan.
Pre-tax savings plans, such as Health care and Dependent care flexible spending accounts.
Embrace a healthy work-life balance with ample sick and vacation leave, along with at least 12 paid holidays. This includes a dedicated week off for winter break.
6 weeks of parental leave to adjust to the joys of parenthood.
A tuition benefit program for you and/or your dependents.
Free RTD EcoPass and Free Onsite Parking at our 1800 Grant Street Office.
Many additional perks & programs with the CU Advantage.

Additional taxable fringe benefits may be available.

For more information on benefits programs, please review our Comprehensive Benefits Guide.

Access our Total Compensation Calculator to see what your total rewards could be at CU. (This position is a University Staff position)

University of Colorado - System Administration jobs

Principal Data Warehouse Engineer

Never Miss a New Opportunity