Job Directory Sr. Data Warehouse Engineer

Sr. Data Warehouse Engineer
Denver, CO

Companies like
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.


Job Description

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

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

Minimum 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

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.