ETL (Extract Transform Load) Developer - Classified

ETL (Extract Transform Load) Developer - Classified

Salary

$96,781.80 Annually

Location

Denver Metro, CO

Job Type

Full Time

Job Number

00763-ITDevIII-IMS-0826

Department

Department of Education

Division

Information Management Services

Opening Date

08/07/2026

Closing Date

8/14/2026 11:59 PM Mountain

FLSA

Determined by Position

Type of Announcement

This position is open only to Colorado state residents.

Primary Physical Work Address

Downtown/Denver Metro/Eligible for a hybrid (office/remote) work environment.*

FLSA Status

Exempt; position is not eligible for overtime compensation.

Department Contact Information

HR@cde.state.co.us

How To Apply

Please submit an online application for this position at https://www.governmentjobs.com/careers/colorado. Reach out to the Department Contact to apply using a paper application, including any supplemental questions. Failure to submit a complete and timely application may result in the rejection of your application. Applicants are responsible for ensuring that application materials are received by the appropriate Human Resources office before the closing date and time listed.

• Description
• Benefits
• Questions

Department Information

This position is only open to current Residents of Colorado.

Incumbent will be required to complete work for CDE within Colorado.

Colorado Department of Education - What We Do

The Colorado Department of Education (CDE) provides leadership, resources, support, and accountability to the states 178 school districts, 1,888 schools, over 53,000 teachers, and over 3,200 administrators to help them build capacity to meet the needs of the states approximately 905,000 public school students. In addition, CDE provides structural and administrative support to the Colorado School for the Deaf and the Blind and the Charter School Institute.

As the administrative arm of the State Board of Education, CDE is responsible for implementing state and federal education laws, disbursing state and federal funds, holding schools and districts accountable for performance, licensing all educators, and providing public transparency of performance and financial data.

CDE is a values-based agency that serves students, parents, and the general public by protecting public trust through ensuring adherence to laws, strong stewardship of public funds, and accountability for student performance.

CDE strives to incorporate five core values that we uphold in our work internally and externally. If you come to CDE, be prepared to incorporate Integrity, Equity, Accountability, Trust, and commitment to Service in what you do.

The State of Colorado strives to create a Colorado for All by building and maintaining workplaces that value and respect all Coloradans through a commitment to equal opportunity and hiring based on merit and fitness. The State is resolute in non-discriminatory practices in everything we do, including hiring, employment, and advancement opportunities.

Why Work For CDE

The work we do is rewarding and impacts the students, families, educators, and communities across Colorado. Our leadership also promotes a culture that puts families and self-care as a priority. Along with meaningful work and an environment that puts employees first, the state also offers rich benefits that intend to make us an Employer of Choice!

The following is a summary of the benefits we offer:

• Flexible work schedules and flexible workplace options that may include flexible working hours, working from home, working in the office, and/or a hybrid working environment.
• Premier medical, dental, vision, and dependent life insurance options. All with a generous employer contribution keeping employee costs as low as possible.
• Employer paid short-term disability and life insurance
• Up to 160 hours of Paid Family Medical Leave (PFML)
• 11 paid holidays per year
• Competitive vacation and sick leave accruals
• Retirement through the Public Employees Retirement Association (PERA) www.copera.org
• Employer paid RTD Eco Pass (certain restrictions may apply)
• Paid professional development opportunities

The final salary is anticipated to fall at $96,781.80 annually; however, it may be higher or lower, depending on the knowledge, skills, abilities, and other qualifications of the preferred internal candidate, while considering internal equity. If the preferred candidates current salary exceeds the posted range, a salary analysis will be conducted based on factors such as step, the candidates current experience, etc. No salary decrease will occur.

Description of Job

Work Environment:

This position is full-time, supported by state funds (contingent upon funding availability), and is eligible for a hybrid work environment.

• Extended hours during the evening or the weekend may be required by business needs.

• Commuting to the CDE buildings may be required occasionally.

• A Remote (Home) office is required.

• Required to report to the work location per business needs.

• Essential Functions (ADAAA)

• LIGHT/Office environment:

• Required to sit, view a computer screen, and utilize a keyboard and mouse for extended periods of time.

• May be required to lift and move up to 10 lbs of force frequently or 20 lbs occasionally.

• Required lifting, bending, stooping, pushing, walking, etc.

• Light work usually requires walking or standing to a significant degree.

• DL Not Required: Required to independently obtain and determine means to complete travel requirements.

Position Summary:

Turn data into impact at CDE. Join our Data Warehouse team to build and enhance Informatica ETL solutions that power critical reporting and help support education across Colorado.

The Information Management Services (IMS) unit provides technology, systems and information to help fulfill the goals of CDE. IMS supports CDE and Colorado School Districts through five teams: Network/Help Desk; Applications Development; Data Services, Project Management, and Data Warehouse. This position will be within the Data Warehouse team.

This position develops, maintains, and enhances Informatica Extract, Load, and Transform (ETL) processes to load data from the Operational Data Store (ODS) and external data sources to the Data Warehouse. It also develops, maintains, and enhances Informatica ETL processes for Data Marts and file creation for federal reporting. It must follow the Software Development Life Cycle (SLDC) process. This position may perform Informatica Administration functions, including software installation, tuning, defining best practices, and troubleshooting and resolution. This position may also require primary contact with the tool vendor or third-party vendors.

This position consults directly with business users, business analysts, and decision-makers to gather and document requirements and define scope. This position may require developing or assisting "data models" to help define project scope and requirements. This position assists with project plans, facilitates meetings, and assists with estimating and planning project deliverables and dependencies. This position attends planning sessions with internal customers to review upcoming enhancement requests and requirements for existing ETL processes and reports. This position as necessary, research background of requested enhancements to understand legislative requirements or educational practices driving the requests.

Major Duties and Responsibilities:

Developing Extract, Transform, Load Processes:

• Develop, maintain, and enhance Informatica Extract, Load, and Transform (ETL) processes to load data from the Operational Data Store (ODS), Assessment collections, and external data sources to the Data Warehouse
• Develop, maintain, and enhance Informatica ETL processes for Data Marts and file creation for federal reporting.
• In all the above, the Software Development Life Cycle (SDLC) process must be followed.
• Must know how the SDLC works.
• Gather functional requirements; develop detailed requirements; review the functional and detailed requirements with business users/owners; obtain signoff on requirements; develop software and unit test; migrate software to QA and get the business users/owners to test and approve; migrate approved software to production and set up runbooks and schedules.
• Utilize and develop best practices.

Gathering Requirements:

• Consult directly with business users, business analysts and decision-makers to gather and document requirements and define scope.

• This may require developing or assisting with "data models" to help define project scope and requirements.

• Assists with project plans and facilitates meetings.

• Assist with estimating and planning project deliverables and dependencies.

• Attend planning sessions with internal customers to review upcoming requested enhancements and requirements to existing ETL processes and reports.

• As necessary, research the background of requested enhancements to understand legislative requirements or educational practices driving the requests.

Documentation:

• Keep existing documentation up to date with changes and modifications applied.
• Create new detailed documentation for new solutions and reports.
• This would include adding documentation to related Informatica objects (mappings, workflows, etc.), comments in SQL code, updates to requirements and design documents (process, workflow, and data model documents).

Conducting Training:

• Coordinate and conduct training and testing for business analysts and other end-users.

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights

MINIMUM EDUCATION AND EXPERIENCE REQUIREMENTS:

This position requires three (3) years of experience, OR A combination of education and experience totaling three (3) years.

Experience Only:

Three (3) years of relevant professional experience in data integration (SSIS), data warehouse management, or database administration.

Relevant experience includes work that included systems, processes, and knowledge as described below:

• Experience in Data integration with systems like Informatica, SSIS, or other ETL tools.

• Experience in data warehouse management that included dimensional data modeling, index mgt, etc

• Experience with Informatica IDMC / Informatica Cloudor PowerCenter with migration exposure.

• Experience supporting or administering Informatica environments.

• Strong SQL skills with Oracle databases.

• Experience working with stored procedures and database-driven logic.

• Experience supporting ETL testing, validation, and issue resolution.

OR

Education and Experience Combination:

A combination of related education (e.g., computer science disciplines), a formalized apprenticeship program, certification, and/or relevant experience in an occupation related to the assigned work is equivalent to one (1) year of education and at least two (2) years of experience as described below as "Relevant Experience".

Relevant experience includes work that included systems, processes, and knowledge as described below:

• Experience in Data integration with systems like Informatica, SSIS, or other ETL tools.

• Experience in data warehouse management that included dimensional data modeling, index mgt, etc

• Experience with Informatica IDMC / Informatica Cloudor PowerCenter with migration exposure.

• Experience supporting or administering Informatica environments.

• Strong SQL skills with Oracle databases.

• Experience working with stored procedures and database-driven logic.

• Experience supporting ETL testing, validation, and issue resolution.

___

QUALIFICATIONS AND CONDITIONS:

Qualifications for Success in the Position:

• High level of proficiency with the Software Development Life Cycle (SDLC) process.

• At least two (2) years of development experience as an Informatica developer, including requirements gathering, data mapping, developing new mappings, transformations, and workflows.

• Experience with UNIX/LINUX scripting.

• Strong written and verbal communication skills.

• Strong attention to detail.

• Ability to effectively balance quality of work and productivity expectations.

• Ability to effectively collaborate with internal and external customers (i.e. school districts, other CDE units, etc.).

• Ability to prioritize and organize work to accommodate and meet the changing needs of the department and meet deadlines.

• Takes initiative and exhibits a proactive approach to work.

• Identifies problems and recommends solutions prior to the standard being jeopardized.

• Ability to work independently, as well as on a team.

• Exhibits CDEs mission, vision and values by the consistent expression of professional, respectful, and customer service. oriented behaviors.

Preferred Qualifications (Preferred/Not Required):

• High level of proficiency with relational databases, such as Oracle, and data warehouse concepts.
• Three (3) Years Hands-on experience data modeling and data warehouse design.
• Three (3) Years Hands-on experience Informatica PowerCenter and IDMC developer.

Conditions of Employment (Required):

• Must be willing and able to submit to the pre-screening process and pass a background check.

• Ability and willingness to independently determine, obtain means, and complete required traveling/commuting.

• Work extended schedule per business needs.

• Report to work location per business needs.

• DL Not Required: Required to independently determine and obtain means to complete travel requirements.

• Sign the acknowledgment form that this position is funded through state funds and is subject to availability.

Supplemental Information

Complete Applications must include:

• Completed Online Application: Required - Submitted through our ATS.
• Resume: Required - Copy and Paste into the Supplemental Questions (11,000 character limit, aprx. 3 pages)
• Resume Required - Attached as a separate document.
• Transcript: Required if using education to meet MQs - Attached to the online application and meeting requirements as described under "College Transcripts".

College Transcripts: If you are using education to qualify, a legible copy of your official or unofficial college transcript(s) or a foreign credential evaluation report must be submitted with your application. Transcripts must show the name of the school and that a degree was conferred. Transcripts from colleges or universities outside of the United States must be assessed for U.S. equivalency by a NACES educational credential evaluation service. Failure to provide a transcript or foreign credential evaluation report may result in your application being rejected and you will not be able to continue in the selection process for this position.

Failure to submit a complete application as defined above by the announcement close will result in your application being removed from consideration.

Resumes and Cover Letters WILL NOT be reviewed for minimum qualification screening.

FOR CURRENT OR FORMER EMPLOYEES OF THE STATE OF COLORADO:

Per the requirements of the Step Pay Program implemented on July 1, 2024, any State employee must be paid a rate that is equal to or greater than the appropriate step pay rate within their classification's pay range based on completed years in their current class series as of June 30. All current and former State employees must ensure that your entire work history within the State Classified System, including at Institutions of Higher Education, is indicated in your application so that your time-in-series can be calculated accurately.

Email Address:

All correspondence regarding your status in the selection/examination process will be conducted via email. Include a working email address on your application; one that is checked often as time-sensitive correspondence such as exam information or notification will take place via email. Please set up your e-mail to accept messages from "state.co.us" and "info@governmentjobs.com" addresses. It is your responsibility to ensure that your email will accept these notices and/or review your junk mail and spam-filtered email.

Appeal Rights:

If you receive notice that you have been eliminated from consideration for the position, you may protest the action by filing an appeal with the State Personnel Board/State Personnel Director within 10 days from the date you receive notice of the elimination.

Also, if you wish to challenge the selection and comparative analysis process, you may file an appeal with the State Personnel Board/State Personnel Director within 10 days from the receipt of notice or knowledge of the action you are challenging.

Refer to Chapters 4 and 8 of the State Personnel Board Rules and Personnel Directors Administrative Procedures, 4 CCR 801, for more information about the appeals process. The State Personnel Board Rules and Personnel Directors Administrative Procedures are available at www.colorado.gov/spb.

A standard appeal form is available at: https://spb.colorado.gov/ . If you appeal, your appeal must be submitted in writing on the official appeal form, signed by you or your representative, and received at the following address within 10 days of your receipt of notice or knowledge of the action: Colorado State Personnel Board/State Personnel Director, Attn: Appeals Processing, 1525 Sherman Street, 4th Floor, Denver, CO 80203. Fax: 303-866-5038. Phone: 303-866-3300. The ten-day deadline and these appeal procedures also apply to all charges of discrimination.

Equity, Diversity, and Inclusion (EDI) and Equal Employment Opportunity

The State of Colorado believes that equity, diversity, and inclusion drive our success, and we encourage candidates from all identities, backgrounds, and abilities to apply. The State of Colorado is an equal opportunity employer committed to building inclusive, innovative work environments with employees who reflect our communities and enthusiastically serve them. Therefore, in all aspects of the employment process, we provide employment opportunities to all qualified applicants without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity or expression, pregnancy, a medical condition related to pregnancy, creed, ancestry, national origin, marital status, genetic information, or military status (with preference given to military veterans), or any other protected status in accordance with applicable law.

The Colorado Department of Education is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or performing essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to hr@cde.state.co.us.

The State of Colorado offers permanent employees a variety of benefits including medical, dental, life and disability insurance, as well as a comprehensive leave program. Please click the following link for detailed information: www.colorado.gov/pacific/dhr/benefits

Please note that each agencys contact information is different; therefore, we encourage all applicants to view the full, official job announcement which includes contact information and class title. Select the job you wish to view, then click on the "Print" icon.

01

A resume is required that describes how your experience aligns with the minimum qualifications and exceptional candidate section of this announcement. Resumes must be copied & pasted in the respective Supplemental Question Box (3 pages or 11,500 character limit) without names or any contact information or PII information. Please note: The experience, education, abilities, and accomplishments listed in this announcement have been identified as critical to successful performance in this position. Your resume and cover letter should address your interest in and qualifications for this job with CDE. Please be specific and detailed in describing experience, abilities, and accomplishments as they relate to this positions requirements and major duties as described in the announcement. We recommend limiting your resume to experience that is applicable to this position. Please indicate your understanding of this requirement.

02

Please copy and paste your RESUME into this question (work history only). Do Not include any Personally Identifiable Information (Such as your name, any contact information, or social media account information). This area has a limit of 11,500 characters (approximately 3 pages {8*5}).

03

Resumes must be uploaded as an attachment to your online application. Resumes, or other required Supplemental Documentation, will not be accepted after the closing date and time of the announcement. Have you uploaded and attached your resume and other required documentation to this application?

• Yes
• No

04

Please indicate your understanding that failure to submit all items listed under "Complete Applications" at the time of application may remove your application from consideration. If have not uploaded the required items, you can go back now and upload those documents before submission of this application.

• Yes
• No

05

In an effort to encourage equity and diversity and meet legal requirements in hiring, items with personally identifiable information will not be released to Hiring Managers until the interview stage. Application work history must demonstrate that you meet minimum qualifications and detail any experience relevant to the position. Please indicate your understanding of this requirement.

06

Minimum Qualifications Your application as submitted is used to determine if you meet Minimum Qualifications. Please read the Minimum Qualifications and ensure that the information in your application describes experience, knowledge, skills, and abilities to the Minimum Qualifications. Human Resources Analysts will not infer that you meet the Minimum Qualifications if the information isnt detailed in your application. Years of experience will be expressed in terms of full-time equivalent service with full-time workload equal to one (1) Full-Time Equivalent (FTE) year. No more than 1.00 FTE year may be credited in any twelve (12) month period. Positions working 40 hours or less per week will be pro-rated: 30 hrs/wk=0.75 FTE=9 mos credit; 20 hrs/wk=0.5 FTE=6 mos credit; 10 hrs/wk=0.25 FTE=3 mos credit.)

07

Are you using substitutions to meet the minimum qualifications for the position?

• Yes
• No

08

If you are using substitutions to meet the minimum qualifications for the position, select which option applies to you.

• Using additional education to substitute for the required experience.
• Using additional relevant experience to substitute for the education requirement.
• Not using substitutions.

09

The Colorado Constitution requires that applicants for State of Colorado Classified positions be Colorado residents at the time the application is submitted. Are you a current resident of the State of Colorado who can provide proof of Colorado residency?

10

If you are a current or previous State of Colorado employee (including public Institutions of higher education), please provide your Employee Identification Number (EID) in order to verify your current or previous employment. If you indicated that you are a current State of Colorado employee, please list all State of Colorado Departments or institutions of Higher Education for which you have worked for and your Employee ID (if known): Your EID begins with 997 and is nine digits long. Please do not enter your Social Security Number. If not applicable, please state "N/A".

11

Former State employees who were disciplinarily terminated or resigned in lieu of termination must disclose the information on the application. In the space below, please provide an explanation as to why the prior termination or resignation should NOT disqualify your application from the current position. If this does not apply to you, please put "N/A".

12

If you are a veteran eligible for Veteran Preference Points, a copy of your DD-214 is required to be submitted as an attachment to your online application. If you have not attached a copy of your DD214 to your application, you may go back and do so now. Have you attached a copy of your DD-214 to this application?

• N/A - I am not a veteran.
• Yes - I attached a copy of my DD-214 to this application.
• No - I am a veteran, but I do not qualify for veterans preference.

13

This position is eligible for a Hybrid flex work place; the incumbent is required to maintain a home office within Colorado and report to the office as needed to complete the job duties of this position. Please indicate your understanding and acceptance of this requirement.

14

The salary range listed is the departments good faith range expected to be offered. Are you willing to accept an offer in the range listed in this announcement?

• Yes.
• Maybe. I believe my knowledge and skills encompass all of the minimum qualifications, the preferred qualifications, and special requirements of the position. I have detailed this in the work experience section of the application.

15

Tell me about the process you follow to develop an ETL workflow-from gathering requirements through testing, deployment, and ongoing support.

16

How do you document transformations, validate the data, manage failures, and handle changing requirements?

17

Tell me about a time you worked with business users, analysts, or other technical teams to develop or improve an ETL process. How did you clarify requirements, communicate issues, and ensure the final data met their needs? What was your role within that group.

18

Tell me how you keep your ETL, database, and data-integration skills current. Can you give an example of something new you learned and applied to your work?

19

If you experience technical difficulty with the NEOGOV system (e.g. uploading or attaching documents to your online application) call NEOGOV technical support at 855-524-5627 Mon-Fri between 6 am and 6 pm (Pacific Time). Helpful hints: if you are having difficulty uploading or attaching documents to your application first, ensure your documents are PDF or Microsoft Word files, and second, close the document before you attempt upload (attach) it.

• Yes
• No

Required Question

Employer State of Colorado

Address See the full announcement by clicking

the "Printer" icon located above the job title

Location varies by announcement, Colorado, --

Website https://careers.colorado.gov/