IT Data Management – Journey (Reports Designer/Developer – Licensing)

Full Job Description

Job Title: - IT Data Management – Journey (Reports Designer/Developer – Licensing)
Location: Thurston County – Olympia, Washington (this position is Hybrid, and may be required to attend in-person meetings when requested)
Closes: Thursday, April 2nd, 2026
Salary: $7,147.00 - $9,612.00 Monthly

DCYF's mission 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. The DCYF Office of Innovation, Alignment, and Accountability (OIAA) contributes to this mission and provides leadership on agency reform efforts through strategic planning, strategic policy work, as well as strategic use of data, analysis, and research. If you’d like to make a difference in the lives of children and youth in your community, apply today!

Click here to learn more about DCYF.

The Opportunity:
The Reports Designer/Developer serves as a report application and database developer with a focus on licensing data and products. This position supports the need for useful foster care licensing reporting from WA CAP and FamLink source systems through the design, development, and implementation of reports that incorporate licensing administrative data and their intersection with other child welfare client and provider data.

Some of what you will get to do:

• Provide technical consultation to the customer on potential reporting solutions that can meet their need identifying the pros and cons of each solution.
• Design Extract Transform and Load (ETL) transformation logic specific to reporting needs.
• Assist in the implementation and transition to a cloud-based data solution in Azure.
• Design report layout(s), define parameters that allow users to build their own custom report, and develop data reporting systems[DA1] .
• Create data structures to integrate reports into DCYF’s report navigation application.
• Debug and maintain code for existing reports, which can involve reverse engineering of existing SQL code.
• Analyze and define data requirements and specifications to design, normalize, develop and implement multi-user reporting databases.
• Plan, develop, implement, test and maintain data structures using Transact SQL, Microsoft SQL Server Management Studio, and/or Visual Studio[DA2] .
• Design, develop, and maintain data reporting systems and business intelligence solutions for licensing data.
• Work closely with the licensing-focused staff across OIAA and the product team.

Required Qualifications:
Four (4) years of IT experience, consulting, analyzing, designing, coding and/or maintaining software applications and/or databases, and providing technical support in Information Technology.
*(Experience may substitue in lieu of education year for year)

AND
Three (3) years of experience developing reports using a Business Intelligence reporting tool (SQL Server Reporting Services) including Visual Studio and SQL Server Management Studio and implementing Report Models.

AND

• The ability to take action to learn and grow.
• The ability to take action to meet the needs of others.

Additional Required Qualifications:

• Three years or more of recent experience working with relational databases (SQL server preferred).
• Three years or more of experience writing T-SQL.
• Two years or more of recent experience working with star schema Data Warehouse databases.

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

• Experience working with WA CAP datasets, models and topics and/or FamLink datasets, models and topics.
• Experience testing complex reports and reporting systems.
• Experience using an automated flowcharting tool such as MS Visio.
• Knowledge and understanding of the business of foster care licensing and/or child welfare.

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

• Current resume detailing experience and education.
• Letter of Interest that details how you meet the qualifications for the 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.

This recruitment may be used to fill multiple vacancies.

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.