IT Data Management - Journey (Olympia) ETL Developer

Full Job Description

Our vision is to ensure that “Washington state’s children and youth grow up safe and healthy —thriving physically, emotionally, and academically, nurtured by family and community."

Job Title: IT Data Management - Journey (Olympia) ETL Developer

Location: Thurston County – Olympia, Washington (this position is full-time Remote)
Closes: February 4th, 2026
Salary: $7,31.00 - $9,900.00 Monthly

The Opportunity:Join DCYF’s Application Development team as a Journey ETL Developer, serving as a technical lead who designs, develops, and integrates data using SSIS solutions that power the agency’s mission-critical systems.

In this role, you’ll support complex legacy and modern applications, ensure reliable data integrations and integrity, set development standards, and provide strategic SQL guidance.

You’ll work closely with Application Development leadership, DevOps, Project Management, Testing, DBAs, Trainers, and Product Owners to maintain secure, stable operations and deliver new features that help DCYF programs serve Washington’s children, youth, and families.

Some of what you will get to do:

• Ensures confidentiality, availability, integrity and quality of DCYF interfaces and data systems.
• Work regularly with .NET developers, DBAs, and DevOps to ensure regular, controlled data deployments of existing and new database driven applications across various platforms.
• Develop plan and roadmap for cloud migration and modernization of legacy databases.
• Perform design, development, quality assurance, verification, testing, optimization, and maintenance tasks.
• Perform data scrubbing tasks to prepare for system modernization efforts.
• Create and maintain data models, data dictionaries, and provides entity diagrams when requested.
• Coach and mentor team members on best practices, new technologies, and data architecture.
• Meet regularly with product team, project teams, and management to perform requirement gathering, iterations, best practices, design, deployment and on-going enhancements.

Required Qualifications:Six (6) years of progressively more complex responsibility for Data Architecture, Solution Architecture, Database Management, analyzing, designing, or programming data systems, applications or databases in a large organization with 24/7 mission critical systems and complex regulatory, privacy and security requirements.

OR

Bachelor’s degree or higher in computer science, data management, information systems or related field AND four (4) years of progressively more complex responsibility for Data Architecture, Solution Architecture, Database Management, analyzing, designing, or programming data systems, applications or databases in a large organization with 24/7 mission-critical systems and complex regulatory, privacy and security requirements.

AND Commitment to equity, inclusion, and respectful workplace principles. Additional Required Qualifications:

• Experience working in a highly regulated environment.
• Experience making presentations and developing documentation for a large, diverse audience.
• Ability to understand relational databases, data modeling, database schema's, SQL Server Information Services(SSIS) packages, Extract, Transform, Load (ETL) processes and SQL Server Reporting Services (SSRS.)

In addition to the requirements above, our ideal candidate will possess some or all of the following:

• SQL certification or knowledge of SQL Server TSQL.
• Experience maintaining and supporting Databases in a 24/7 availability situation.
• Agile Training or Certification.
• Experience in SCRUM, Agile, and iterative development processes.
• Experience using a source code versioning management tool.

How do I apply?
Complete your applicant profile on careers.wa.gov and attach the following documents:

• Current chronological resume detailing your experience and education specific to the requirements for this position.
• Letter of Interest clearly describing how your experience, knowledge, skills, and abilities align with the job duties and required qualifications of this position.

Supplemental Information:

The Department of Children, Youth, and Families (DCYF) is committed to Washington’s children and youth growing up safe, healthy, and thriving.

We invite all candidates to join us in our mission to create a diverse and equitable workplace that reflects the communities we serve.

If you are excited about this role but you believe that your education and/or experience might not align perfectly with every qualification in the job posting, we encourage you to apply anyway.

The Department of Children, Youth, and Families (DCYF) is an equal opportunity employer and does not discriminate on the basis of age, sex, marital status, sexual orientation, race, creed, color, national origin, honorably discharged veteran or military status, or the presence of any sensory, mental, or physical disability or the use of a trained service animal by a person with a disability.

DCYF complies with the employment eligibility verification requirements of the federal employment eligibility verification form, I-9.

The selected candidate must be able to provide proof of identity and eligibility to work in the United States consistent with the requirements of that form on the first day of employment.

DCYF does not use E-Verify; therefore, we are not eligible to extend STEM-Optional Practice Training (OPT). For information, please visit www.uscis.gov.

If you have any questions pertaining to this recruitment or if you would like to request an accommodation throughout the application/interview process, contact Cole Alford (Talent Acquisition Specialist) at cole.alford@dcyf.wa.gov.

If you're experiencing technical difficulties creating, accessing or completing your application, call NEOGOV toll-free at (855)524-5627 or emailsupport@neogov.com.

“Applicants who meet the minimum qualifications and wish to claim Veteran's Preference MUST attach a copy of their DD214 or NGB Form 22, or other verification of military service.

Please blackout (redact) the social security number before attaching any documents. For additional information on Veteran's Preference and guidance on how to determine if you are eligible, click here.

Persons needing accommodation in the application process or this announcement in an alternative format may call the Telecommunications Device for the Deaf (TDD) at 360-664-1960