IT Data Management Journey (Olympia) ETL Developer

Not Interested
Bookmark
Report This Job

profile Job Location:

Thurston County, WA - USA

profile Monthly Salary: $ 7361 - 9900
Posted on: 18 hours ago
Vacancies: 1 Vacancy

Job Summary

Description


Our vision is to ensure that Washington states 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:$731.00 - $9900.00 Monthly


The Opportunity:
Join DCYFs 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 agencys mission-critical this role youll support complex legacy and modern applications ensure reliable data integrations and integrity set development standards and provide strategic SQL guidance. Youll 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 Washingtons 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 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

Bachelors degree or higher in computer science data management information systems or related fieldAND 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 schemas 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 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 Washingtons 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 .


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 If youre experiencing technical difficulties creating accessing or completing your application call NEOGOV toll-free at or


Applicants who meet the minimum qualifications and wish to claim Veterans 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 Veterans 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

Required Experience:

IC

DescriptionOur vision is to ensure that Washington states 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 DeveloperLocation: Thurston County Olympia Washington (this po...
View more view more

Key Skills

  • SQL
  • Pentaho
  • PL/SQL
  • Microsoft SQL Server
  • SSIS
  • Informatica
  • Shell Scripting
  • T Sql
  • Teradata
  • Data Modeling
  • Data Warehouse
  • Oracle