Colorado Department of Revenue
Principal Data Warehouse Engineer
Colorado Department of Revenue, Denver, Colorado, United States, 80285
Principal Data Warehouse Engineer
Colorado Department of Revenue
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. This role is to support the university’s quickly growing needs and demands to make data‑driven decisions, using an enterprise data warehouse, data integrations, analytics, and business intelligence initiatives. The Principal Data Warehouse Engineer will be a key member of the university’s ETL team and serve as a Data Warehouse domain expert applying standard processes in the industry. This position reports to the Assistant Director of Data and Business Intelligence and is exempt from the State of Colorado Classified Staff system.
Descripción Del Empleo Duties and Responsibilities
Conduct data engineering, including requirement gathering, Extract, Transform, and Load (ETL) development, system testing, deployments, documentation, and production support with data sources such as CU’s PeopleSoft Student, HCM, Finance, InfoEd, and Advancement systems.
Collaborate with key partners to gather requirements and assist with User Acceptance Testing (UAT) for data and BI initiatives.
Design supportable solutions to satisfy customer needs and support CU’s long‑term business goals via new data warehouse data marts and enhancements to existing data marts and reports.
Conduct detailed data profiling and analysis for data modeling and design.
Create conceptual, logical, and physical data models for simple to medium complexity work efforts.
Maintain source‑to‑target mappings across multiple domains at the University.
Use development tools including IBM DataStage, SAS, shell scripting, and Perl; act as a domain expert in ETL Development and Solutions Architecture.
Partner with management to allocate responsibilities among ETL developers.
Provide support and guidance to ETL developers throughout all Software Development Life Cycle (SDLC) phases.
Plan and conduct system integration test cases (SIT) to ensure solutions are successful throughout the entire system.
Deploy code and objects through SDLC environments (Development, QA, and Production) while partnering with production services to ensure correct job scheduling.
Investigate data, process, logic, or scheduling issues to identify root cause and develop mitigation plans.
Participate in technology projects and initiatives as a technical lead, managing project plans, estimates, cut‑over plans, resources, and communications.
Lead, advise, and mentor team members on data and BI concepts and standard methodologies.
Recommend data strategies, platforms, and infrastructure required to implement solutions.
Assist with designing a multi‑year data warehouse roadmap, balancing short‑ and long‑term goals and investments.
Participate in and lead team meetings, peer design and code reviews.
Perform ETL DataStage administration, including tool and Linux structure configuration, setup, and monitoring of environment health.
Partner with the BI team to communicate data warehouse enhancements and suggest architecture modifications to Cognos Framework Manager.
Commit to continuous education and professional development, attending trainings, conferences, and engaging in self‑directed learning.
Minimum Qualifications
Bachelor’s degree from an accredited institution of higher education, or equivalent professional experience (profession can be substituted for the educational requirement on a year‑for‑year basis).
Four (4) years of experience in the following areas: IBM DataStage or equivalent.
Data modeling or database design; Data Warehouse/Mart design; or data architecture.
Kimball methodologies, including star schema design and periodic snapshots.
SQL, including familiarity with Oracle analytic functions and techniques for tuning large‑volume queries.
Administration of an ETL or middleware tool (DataStage, ODI, Informatica, OSB, etc.).
Preferred Qualifications
Bachelor’s or post‑baccalaureate degree in computer science, computer engineering, information systems, information technology, or related field.
Six (6) years’ equivalent experience in:
IBM DataStage or equivalent.
Kimball methodologies, including star schema design and periodic snapshots.
SQL, including familiarity with Oracle analytic functions and tuning techniques.
Experience in one or more of the following:
Commitment to SDLC standard processes for data warehousing.
Experience with Linux environments and shell scripting (Perl/Korn).
Technical lead experience managing a development team responsible for design, development, and implementation of high‑quality, high‑performance programs, scripts, and data objects.
Experience in a University or Higher Education setting.
Java and PL/SQL programming.
PeopleSoft data models including Campus Solutions, Finance, and/or HCM version 9.0 or higher.
Projects implementing an ETL or information management tool.
Knowledge, Skills, And Abilities
Knowledge of ETL architecture, tools, Kimball methodology, and SQL.
Proficiency with Oracle analytic functions and performance tuning.
Understanding of data warehousing & BI SDLC standard processes.
Experience with Linux environments and shell scripting.
Ability to document, manage, and test multiple projects concurrently.
Team leadership and development skills.
Strong collaboration skills across diverse stakeholders.
Digital literacy with Microsoft Office and ability to learn new software.
Excellent interpersonal, oral, written, and listening communication skills.
Organizational skills for goal setting, scheduling, and decision making.
Resilience under stress, multitasking, and adaptability.
Independence with minimal direction and effective collaboration.
Professional judgment, positive problem‑solving demeanor, and passion for work.
Self‑start initiative for daily tasks and special projects.
Focus on high‑impact activities and commitment to partnership.
Effective communication across diverse backgrounds.
How To Apply For full consideration, please attach the following as separate documents to your application:
https://cu.taleo.net/careersection/2/jobdetail.ftl?job=38064
Cover letter identifying the job‑specific minimum qualifications you possess.
Resume including all relevant experience to be accurately assessed against the qualifications listed in the posting.
Benefits
No‑cost or low‑cost medical & dental plan options, some inclusive of IVF assistance.
Disability, Life, Vision Insurance options.
Multiple retirement planning options including a mandatory 401(a) plan where CU contributes 10% of your gross pay, a 401(k) or 403(b) plan, and a 457 deferred compensation plan.
Pre‑tax savings plans such as Health Care and Dependent Care Flexible Spending Accounts.
Healthy work‑life balance with ample sick and vacation leave and at least 12 paid holidays, including a dedicated week off for winter break.
Six weeks of parental leave to adjust to the joys of parenthood.
Tuition benefit program for you and/or your dependents.
Free RTD EcoPass and free onsite parking at our 1800 Grant Street Office.
Many additional perks & programs with the CU Advantage.
Employment type Full‑time
Seniority level Mid‑Senior level
Job function Information Technology Government Administration
Industries Government Administration
#J-18808-Ljbffr
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. This role is to support the university’s quickly growing needs and demands to make data‑driven decisions, using an enterprise data warehouse, data integrations, analytics, and business intelligence initiatives. The Principal Data Warehouse Engineer will be a key member of the university’s ETL team and serve as a Data Warehouse domain expert applying standard processes in the industry. This position reports to the Assistant Director of Data and Business Intelligence and is exempt from the State of Colorado Classified Staff system.
Descripción Del Empleo Duties and Responsibilities
Conduct data engineering, including requirement gathering, Extract, Transform, and Load (ETL) development, system testing, deployments, documentation, and production support with data sources such as CU’s PeopleSoft Student, HCM, Finance, InfoEd, and Advancement systems.
Collaborate with key partners to gather requirements and assist with User Acceptance Testing (UAT) for data and BI initiatives.
Design supportable solutions to satisfy customer needs and support CU’s long‑term business goals via new data warehouse data marts and enhancements to existing data marts and reports.
Conduct detailed data profiling and analysis for data modeling and design.
Create conceptual, logical, and physical data models for simple to medium complexity work efforts.
Maintain source‑to‑target mappings across multiple domains at the University.
Use development tools including IBM DataStage, SAS, shell scripting, and Perl; act as a domain expert in ETL Development and Solutions Architecture.
Partner with management to allocate responsibilities among ETL developers.
Provide support and guidance to ETL developers throughout all Software Development Life Cycle (SDLC) phases.
Plan and conduct system integration test cases (SIT) to ensure solutions are successful throughout the entire system.
Deploy code and objects through SDLC environments (Development, QA, and Production) while partnering with production services to ensure correct job scheduling.
Investigate data, process, logic, or scheduling issues to identify root cause and develop mitigation plans.
Participate in technology projects and initiatives as a technical lead, managing project plans, estimates, cut‑over plans, resources, and communications.
Lead, advise, and mentor team members on data and BI concepts and standard methodologies.
Recommend data strategies, platforms, and infrastructure required to implement solutions.
Assist with designing a multi‑year data warehouse roadmap, balancing short‑ and long‑term goals and investments.
Participate in and lead team meetings, peer design and code reviews.
Perform ETL DataStage administration, including tool and Linux structure configuration, setup, and monitoring of environment health.
Partner with the BI team to communicate data warehouse enhancements and suggest architecture modifications to Cognos Framework Manager.
Commit to continuous education and professional development, attending trainings, conferences, and engaging in self‑directed learning.
Minimum Qualifications
Bachelor’s degree from an accredited institution of higher education, or equivalent professional experience (profession can be substituted for the educational requirement on a year‑for‑year basis).
Four (4) years of experience in the following areas: IBM DataStage or equivalent.
Data modeling or database design; Data Warehouse/Mart design; or data architecture.
Kimball methodologies, including star schema design and periodic snapshots.
SQL, including familiarity with Oracle analytic functions and techniques for tuning large‑volume queries.
Administration of an ETL or middleware tool (DataStage, ODI, Informatica, OSB, etc.).
Preferred Qualifications
Bachelor’s or post‑baccalaureate degree in computer science, computer engineering, information systems, information technology, or related field.
Six (6) years’ equivalent experience in:
IBM DataStage or equivalent.
Kimball methodologies, including star schema design and periodic snapshots.
SQL, including familiarity with Oracle analytic functions and tuning techniques.
Experience in one or more of the following:
Commitment to SDLC standard processes for data warehousing.
Experience with Linux environments and shell scripting (Perl/Korn).
Technical lead experience managing a development team responsible for design, development, and implementation of high‑quality, high‑performance programs, scripts, and data objects.
Experience in a University or Higher Education setting.
Java and PL/SQL programming.
PeopleSoft data models including Campus Solutions, Finance, and/or HCM version 9.0 or higher.
Projects implementing an ETL or information management tool.
Knowledge, Skills, And Abilities
Knowledge of ETL architecture, tools, Kimball methodology, and SQL.
Proficiency with Oracle analytic functions and performance tuning.
Understanding of data warehousing & BI SDLC standard processes.
Experience with Linux environments and shell scripting.
Ability to document, manage, and test multiple projects concurrently.
Team leadership and development skills.
Strong collaboration skills across diverse stakeholders.
Digital literacy with Microsoft Office and ability to learn new software.
Excellent interpersonal, oral, written, and listening communication skills.
Organizational skills for goal setting, scheduling, and decision making.
Resilience under stress, multitasking, and adaptability.
Independence with minimal direction and effective collaboration.
Professional judgment, positive problem‑solving demeanor, and passion for work.
Self‑start initiative for daily tasks and special projects.
Focus on high‑impact activities and commitment to partnership.
Effective communication across diverse backgrounds.
How To Apply For full consideration, please attach the following as separate documents to your application:
https://cu.taleo.net/careersection/2/jobdetail.ftl?job=38064
Cover letter identifying the job‑specific minimum qualifications you possess.
Resume including all relevant experience to be accurately assessed against the qualifications listed in the posting.
Benefits
No‑cost or low‑cost medical & dental plan options, some inclusive of IVF assistance.
Disability, Life, Vision Insurance options.
Multiple retirement planning options including a mandatory 401(a) plan where CU contributes 10% of your gross pay, a 401(k) or 403(b) plan, and a 457 deferred compensation plan.
Pre‑tax savings plans such as Health Care and Dependent Care Flexible Spending Accounts.
Healthy work‑life balance with ample sick and vacation leave and at least 12 paid holidays, including a dedicated week off for winter break.
Six weeks of parental leave to adjust to the joys of parenthood.
Tuition benefit program for you and/or your dependents.
Free RTD EcoPass and free onsite parking at our 1800 Grant Street Office.
Many additional perks & programs with the CU Advantage.
Employment type Full‑time
Seniority level Mid‑Senior level
Job function Information Technology Government Administration
Industries Government Administration
#J-18808-Ljbffr