Sr. Data Warehouse Engineer

Job description

Description

University InformationServices (UIS) provides technical services and enterprise applications to theUniversity of Colorado campuses and the Office of the President. UIS iscommitted to excellence in customer service and technical expertise. Throughthe development of enterprise applications, UIS supports the University as awhole with systems used by students, faculty, human resources employees,finance employees, and others.


The Senior Data Warehouse Engineer will support the university’s quickly growing needs and demands to make data driven decisions, utilizing an enterprise data warehouse, data integrations, analytics, and business intelligence initiatives. This position will be a key member of the university’s ETL team and will serve as a Data Warehouse subject matter expert utilizing best practices 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. The Senior Data Warehouse Engineer will also collaborate with UIS departments such as database administrators, system admins, middleware, infrastructure, production services, enterprise data architects, developers, and quality assurance testers to ensure deliverables and system needs are being met. 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: 
  • ETL development (which includes unit testing), functional testing, 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
    • Development tools include IBM DataStage, Oracle Data Integrator (ODI), and SAS, Perl, Groovy, and Kornshell scripts
  • Data Modeling and data profiling, creating Star schema logical and physical models for an Oracle environment
  • Leading, advising, and coaching team members on data warehouse concepts and best practices
  • Serve as co-technical lead with autonomy to make technical decisions on projects and smaller initiatives
  • Identifying task level of effort and duration estimates, assisting with project plan creation, and leading the technical coordination efforts
  • Administering and tuning the university’s installation of IBM DataStage
  • Continuing education and professional development including attending trainings and conferences and self-directed learning
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
  • Ability to manage and develop the team’s technical skills
  • Strong problem solving skills and effective communication, along with the ability to work independently, as well as part of a cross-functional team
  • Strong verbal and written communication skills
  • Strong problem solving skills and effective communication, along with the ability to work independently, as well as part of a cross-functional team

Who we are:

System Administration, which also houses theOffice of the President, is located in the uptown neighborhood of Denver withan office in Broomfield and a few smaller offices located on the campuses.However, this position is located in Denver.  Many of our departmentssupport the educational and research missions of the four University ofColorado campuses. We provide diverse opportunities for professionaldevelopment, innovation, and collaboration with talented staff andfaculty. 


The University of Colorado is committed torecruiting 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, ethnicminorities, persons with disabilities and all veterans.


The salary range for this position is $100,000 - $110,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 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 Qualifications:
  • 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 
    • SAS (Software as a Service) 
    • Working in a Linux environment and with shell scripting (Perl/Korn) 
    • Experience with Kimball methodologies including star schema design, and accumulating and periodic snapshots, creating logical and physical data models with applicable indexes 
    • 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 
    • 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
Preferred Qualifications:
  • Relevant work experience for a college or university 
  • Knowledge of Java and PL/SQL programing 
  • 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 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: Apr 23, 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: 4/24/2019
Application Due: 8/23/2019
Work Type:
Salary: