This job has expired

Lead ETL Engineer & Solution Architect

University of Colorado - Denver and the Health Sciences Center
Denver, CO

View more

Employment Type
Full Time
Institution Type
Four-Year Institution
You need to sign in or create an account to save a job.
Position SummaryUniversity 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.

In order to support the University’s data warehouse, data integrations, analytics, and business intelligence initiatives, this role will be a key member of the University’s Data and Business Intelligence (BI) team and will serve as a data and BI subject matter expert. This position is accountable for ETL Development, Solutions Architecture operations, processes, and efficiencies for multiple functional areas. This position supports educating the University on best practices for ETL development and solution architecture and will lead the training, coaching, and mentoring of other Data and BI team members, including the successful onboarding of any new employees on the team. This position also requires the ability to perform some of the tasks and duties of the Assistant Director of Data and BI when they are unavailable.

This position reports to the Assistant Director of Data and Business Intelligence and is exempt from the State of Colorado Classified Staff system.

Duties and Responsibilities Duties and responsibilities of the position include, but are not limited to: 

  • Conducts data engineering duties, including requirement gathering, solution design, data modeling, Extract, Transform and Load (ETL) design/development, system testing, deployments, documentation and production support with data sources such as CU’s PeopleSoft Student, HCM, Finance, InfoEd and Advancement systems
  • Partners with the Data and BI Business Analyst to collaborate with stakeholders to gather requirements and assist with User Acceptance Testing
  • Collaborates with the integrations team to design and develop 3rd party system integrations sourced from the data warehouse
  • Designs supportable solutions to satisfy customer needs and support CU’s long-term business goals via the creation of new Data Warehouse data marts and enhancements to existing data marts
  • Creates conceptual, logical, and physical data models by conducting data profiling analysis
  • Creates and maintains source to target mappings across multiple domains at the University
  • Utilizes development tools including IBM DataStage, SAS and Perl
  • Acts as a subject matter expert in ETL Development and Solutions Architecture
  • Allocates and delegates responsibilities among ETL developers
  • Provides feedback to ETL developers throughout the performance management cycle
  • Ensures effective working relationships within the Data and BI team and those with whom the team interacts
  • Provides oversight, support, and guidance to ETL developers, as required 
  • Provides mentoring to support professional development of ETL developers
  • Conducts system integration testing to ensure solutions are successful throughout the entire system
  • Deploys 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
  • Investigates data, process, logic or scheduling issues to identify the root causes, mitigation and resolution plans
  • Participation in technology projects and initiatives as the Technical Lead partnering with the project manager to identify and track project plans, time estimates, cut over plans, resource availability, and communications
  • Provides recommendations on data strategies, platforms, and application infrastructure required to implement solutions
  • Assists with design and assists with 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
  • Facilitates and participates in peer design, code, testing and deployment reviews
  • Administers and tunes the university’s installation of IBM DataStage
  • Works with BI team to design and implement data models in the CU System supported reporting tools Tableau and Cognos 
  • Continues education and professional development including attending trainings and conferences and self-directed learning
Who we are:

System Administration, which also houses the Office of the President, is located in the uptown neighborhood of Denver with a few smaller offices located on the campuses.  However, this position has the ability to work remotely. Many of our departments support the educational and research missions of the four University of Colorado campuses, but System Administration is not considered a campus. We provide diverse opportunities for professional development, innovation, and collaboration with talented staff and faculty.  Learn more about CU System Administration.

The University of Colorado has been proactive in response to the COVID-19 pandemic. You can visit our COVID-19 webpage for more information.

What we offer:


The anticipated hiring salary range has been established at $81,400 - $116,900.

The market salary range for this position is $81,400 - $116,900.

The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training.

The above salary range (or anticipated hiring range) represents the University’s good faith and reasonable estimate of the range of possible compensation at the time of posting.

Benefits: The University of Colorado offers an excellent benefits package including:

  • Medical: Multiple plan options
  • Dental: Multiple plan options
  • Additional Insurance: Disability, Life, Vision and Wellness
  • Retirement 401(a) Plan: Employer contributes 10% of your gross pay
  • Paid Time Off: Accruals over the year
    • Vacation Days: 22
    • Sick Days: 15
    • Holiday Days: 10
  • Tuition Benefit: System employees have the benefit on all campuses 
  • ECO Pass: RTD Bus and light rail service
  • Additional Perks & Programs: Click here to access a few more Perks and Programs
Click here to access our Total Compensation Calculator to see what your total rewards could be at CU. This position is a University Staff position.

Additional taxable fringe benefits may be available.

More information on benefits programs, including eligibility, is available at

Knowledge, Skills, and Abilities To be successful in this position, candidates will need the following:

  • Knowledge of ETL Architecture, IBM Data Stage, Kimball Methodology, and SQL
  • Ability to utilize Oracle analytic functions and techniques
  • Ability to utilize and understand best practices in regards to 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
  • Knowledge of the business and organizational structure of CU
  • Collaboration skills, including the ability to work with others from different areas and backgrounds to reach a common goal
  • Computer skills, including the ability to utilize Microsoft Office programs (i.e. Word, Excel, PowerPoint, Outlook, etc.) and learn and experiment with new software and systems
  • Interpersonal skills, including the ability to facilitate interaction, communication, and teamwork between others
  • Oral, written, and listening communication skills, including the ability to accurately interpret what others are saying and convey messages, information, concepts, and details accurately and clearly
  • Organizational skills, including the ability to set and meet goals and deadlines, manage appointments, create schedules, coordinate and facilitate meetings, and make decisions
  • Ability to work under pressure, manage multiple concurrent and competing tasks and responsibilities, and adapt to changing priorities while maintaining personal effectiveness
  • Ability to prioritize work, meet deadlines, and stay on task when completing special projects and daily assignments
  • Ability to work independently with minimal supervision and reliable professional judgment, as well as collaboratively with a team to achieve desired results
  • Ability to maintain a strong work ethic, positive problem-solving attitude, and enthusiasm 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 diverse backgrounds, cultures, and ages
  • Ability to navigate a complex political environment

Minimum Requirements
  • Bachelor’s degree from an accredited institution of higher education. A combination of education, technology training and industry certifications, and related experience may substitute for the degree on a year for year basis.
  • Five (5) years of experience to include any of the following:
    • IBM DataStage
    • 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
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 field of study related to the work performed
  • Seven (7) years’ equivalent experience to include any of the following:
    • IBM DataStage
    • 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
  • One (1) year of experience in a team lead or supervisory role, which includes assigning and reviewing the work of others, providing guidance to internal and external team members, and assisting management with performance reviews (this requirement may be substituted by formal leadership training)
  • Experience in one or more of the following:
    • Commitment to SDLC best practices 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 complex programs, scripts, data objects resulting in high quality and performance
    • Higher education
    • Java and PL/SQL programming
    • PeopleSoft data models including Campus Solutions, Finance, and/or HCM version 9.0 or higher
    • Administration of an ETL or middleware tool (DataStage, ODI, Informatica, OSB, etc.)
    • One or more projects to implement an ETL, or information management tool, and/or data catalog

Job Category: Information Technology
Primary Location: Denver
Schedule: Full-time
Posting Date: Oct 8, 2021
Unposting Date: Ongoing
You need to sign in or create an account to save a job.

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert