ETL Developer & Data Modeler

Job description

University Information Systems (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 ETL Developer / Data Modeler works closely with stakeholders, UIS Enterprise Architects, Business Analysts and other UIS resources to refine requirements, create or modify detailed technical designs, programs, logical and physical data models, execute functional tests and partake in a rotating on-call production support schedule. 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:

Responsibilities of this position include, but are not limited to, the following:

  • ETL architecture, development, test, documentation and support of data sources such as PeopleSoft's Campus Solutions and HCM and SalesForce CRM systems
    • Utilizing the development tools IBM DataStage, Oracle Data Integrator (ODI), and SAS
    • Development will include occasional work on Perl and Kornshell scripts
  • Developing a broad and in-depth knowledge of all Higher Education functional areas
  • Working closely with UIS resources and stakeholders to help identify and create business requirements into system requirements, as well as contributing to or creating the standard requirement documentation
  • Performing source system analysis, data profiling and design mapping logic between source systems and the Central Information Warehouse (CIW).
  • Developing Conceptual, Logic, and Physical data models/design data access layer specifications and communicate design for implementation
  • Creating (or advising in the creation of) data extraction, cleansing and load programs to move data from source systems to the CIW
  • Tuning the university's installation of IBM DataStage and ODI
  • Assisting with technical upgrades, including testing and incorporating required modifications
  • Developing and maintaining documentation, such as:
    • technical specifications
    • source to target mappings
    • standards for coding, error handling, error notification, logging, data model, etc
    • functional test cases
    • implementation plans and release notes
    • the run book for production support
  • Loading of data into test environments and executing test plans for data validation
  • Troubleshoot data or processing issues during development and production support
  • Weekly participation of an on-call support rotation
  • Continuing education and professional development including attending trainings and conferences and self-directed learning
  • Compliance with UIS standards, policies and procedures

Knowledge, Skills, and Abilities:

To be successful in this position a candidate will need the following:

  • Excellent written and verbal communication skills
  • Expert SQL skills
  • Strong knowledge of Data Warehouse and Business Intelligence concepts
  • Experience with Oracle data bases and related tuning skills

Who we are:

System Administration, which also houses the Office of the President, is located in the uptown neighborhood of Denver with an office in Broomfield and a few smaller offices located on the campuses. This position is located in Denver. Many of our departments support the educational and research missions of the four University of Colorado campuses. We provide diverse opportunities for professional development, innovation, and collaboration with talented staff and faculty.

What we offer:

Salary: The salary range for this position is $79,000 - $83,000.

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 Day: 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.

For more information on benefits programs, including eligibility, is available at


Minimum Qualifications:
  • Bachelor's degree from an accredited institution of higher education
  • 3+ years' experience working with all phases in the Software Development Life Cycle SDLC
  • 3+ years' experience developing in ETL tools such as Oracle Enterprise Databases, DataStage or SAS
  • 3+ years data modeling experience within Data Warehouse environments in Conceptual, Logical, and Physical data models

Preferred Qualifications:

  • Previous experience in an institution of higher education
  • Knowledge of Java and PL/SQL programming
  • Experience with PeopleSoft data models including Campus Solutions, Finance and/or HCM version 9.0 or higher
  • Experience as an administrator of an ETL or Middleware tool (DataStage, ODI, Informatica, OSB, Etc.)
  • Experience using data modeling tools

Special Instructions to Applicants:This position will be open until filled. 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.*

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 a verification of employment eligibility be documented for all new employees by the end of the third day

Application Materials Required:Cover Letter, Resume/CV

Application Materials Instructions:You must attach a cover letter, resume, and list of references to your application as three separate documents. Please ensure you check the "Job Specific Attachments" box next the each document on the "Required Documents" page of the application for the appropriate documents to be attached.

Job Category: Information Technology

Primary Location: Denver

Department: S0001 -- System Administration - 50119 - University Information Systems

Schedule: Full-time

Posting Date: May 16, 2018

Closing Date: Ongoing

Posting Contact Name: Lauren Morain

Posting Contact Email: [email protected]

Position Number: 00705078





Diversity Profile: University



View more

Learn more on Inside Higher Ed's College Page for University

Arrow pointing right
Job No:
Posted: 5/17/2018
Application Due: 7/16/2018
Work Type: