IT Data Management - Journey (Olympia) ETL Developer

Other Jobs To Apply

No other job posts for this day.

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 Apply tot his job

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...