ETL Developer

Job description

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

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.

In order to support the university’s data warehouse, data integrations, data analytics, and business intelligence initiatives, the ETL Developer will be a member of the university’s Extract Transform and Load (ETL) team and will serve as a subject matter expert in ETL. In addition to development, this role includes requirement gathering, data profiling/analysis, data modeling, testing, deploying code, troubleshooting, production support, creating, and maintaining documentation. This role will interact with departments such as Data Base Engineers, Middleware, Enterprise Cloud Services, Business Analysts, ERP developers, and stakeholders from Finance, Advancement, Human Resources (HCM), UIS, electric research and grants (eRA), and student Campus Solutions to accomplish goals. The ETL Developer 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:

Primary Responsibilities: Duties that are directly under the purview of this position.

  • Assisting in the Software Development Life Cycle (SDLC) including:
    • ETL development (which includes unit testing)
    • Functional/system testing
    • Code deployment
    • Documentation creation and production support with data sources such as CU’s PeopleSoft Campus Solutions, Finance, HCM, InfoEd, Advance and SalesForce CRM systems, among others
  • Creating development tools include IBM DataStage, Oracle Data Integrator (ODI), and SAS, Perl, Groovy, and Kornshell scripts.
  • Data modeling, data analysis, and data profiling for creation and maintenance of Star schema models for an Oracle environment.
  • Collaborating and working closely with a team of ETL developers, Business Analysts, and BI Reporting Analysts utilizing data warehouse concepts and best practices.
  • Participating in technology projects and initiatives, designing and developing new data marts and enhancements to existing data marts.
  • Serving as lead on smaller enhancements, identifying time estimates, coordinating with requestors, and collaborating with the Sr ETL Developer.
  • Assisting with administering and tuning the university’s installation of IBM DataStage and SAS.
  • Continuing education and professional development including attending trainings and conferences and self-directed learning
Secondary Responsibilities: Duties that this position may be asked to support or provide coverage on.
  • Facilitate requirement gathering sessions and provide support for User Acceptance Testing (UAT)
  • Functional testing of peer ETL code
  • Peer design and code reviews
Applications/Tools
Used:

  • Cherwell
  • DataStage
  • Excel
  • Stash
  • HTML
  • JavaScript
  • Perl
  • SharePoint
  • SQL Developer
  • SQL Tools
  • TeamDynamix
  • Toad
  • XML
Managed:
  • DataStage
  • SAS
Knowledge, Skills, and Abilities:
To be successful in this position, candidates will need the following:
  • Knowledge of ETL Architecture and IBM Data Stage.
  • Knowledge of Data Modeling for Oracle.
  • Knowledge of SDLC best practices.
  • 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 on multiple work efforts at once, playing multiple roles.
  • Strong problem solving skills and effective communication, along with the ability to work independently, as well as part of a cross-functional team.
  • Knowledge of ETL Architecture, IBM Data Stage, Kimball Methodology and SQL
  • 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
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. However, 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.

The University of Colorado is committed to recruiting and supporting diversity and equality in education and employment. The university strives to promote a culture of inclusiveness, respect, communication and understanding. We encourage applications from women, ethnic minorities, persons with disabilities and all veterans.

Salary:
The salary for this position is commensurate with skill and experience.

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.


For more information on benefits programs, including eligibility, is available at www.cu.edu/employee-services/.



QualificationsMinimum Requirements:
  • Bachelor’s degree from an accredited institution of higher education or equivalent professional experience. (The educational requirement may be substituted by professional experience on a year for year basis).
  • Three (3) years of experience to include the following:
    • Experience with IBM DataStage
    • Experience with 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 with SDLC best practices as they relate to data warehousing
    • Experience working in a Linux environment and with shell scripting (Perl/Korn)
Preferred Qualifications:
  • Experience working in IT, data analysis, reporting, or Business Intelligence within a higher education environment.
  • Knowledge of Java and PL/SQL programing
  • Experience with PeopleSoft data models
  • Experience on one or more projects to implement an ETL or information management tool



Job Category: Information Technology
Primary Location: Denver
Schedule: Full-time
Posting Date: Aug 29, 2019
Unposting Date: Ongoing

 

 

 

Diversity Profile: University

 

AAUP COMPENSATION SURVEY DATA

View more

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

Arrow pointing right
Job No:
Posted: 9/3/2019
Application Due: 12/2/2019
Work Type:
Salary: