IT Data Management - Journey (Prevention BI Analyst)

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

*INTERNAL APPLICANTS ONLY

Job Title: IT Data Management – Journey (Prevention BI Analyst) Location : Olympia, WA, Thurston County (Flexible/Hybrid) Closes: August 12th, 2026 Salary: $90,096.00 - $121,176.00 Annually The Opportunity: In this position as a Business Intelligence Analyst, you will help transform data into meaningful insights that improve outcomes for children, youth, and families across Washington. You will develop and maintain complex datasets, dashboards, and data visualizations, collaborate with partners across the agency, and provide analytics that support data-driven decision-making, program improvement, and strategic initiatives focused on prevention and child welfare. Some of what you will get to do: Design, develop, and maintain complex BI analytic data solution systems and business intelligence solutions for Primary Prevention using child welfare and other data. Develop a programmatic understanding of Washington’s Prevention and associated child welfare business processes to effectively serve the business customers. Work closely with the staff across OIAA to ensure solutions meet the business needs of DCYF’s stakeholders and implementation. Troubleshoot and resolve complex data related issues. Provide technical consultation to the customer on potential analytic and dashboard solutions that can meet their need identifying the pros and cons of each solution. Write, update, and maintain complex SQL code to produce complex automated data products and dashboards. Monitor, evaluate, propose, and design solutions regarding the validity of data used for analysis. Debug and maintain code for existing analytic products; which can involve reverse engineering of existing SQL code as needed. Participate and engage in peer code reviews in order to ensure data integrity/quality of the analytics team. Provide expertise on relevant data as well as present case outcomes. Serve as a resource for designated program Evaluators (internal and/or external to DCYF) as to analytic data used in BI analytic products developed. Analyze data, build data sets, and create data visualizations for presentation to the relevant primary business team, as well as internal stakeholders and external partners relevant to the program. Contribute to presentations by the identified primary business partners and/or program Evaluators that they use for presenting to external stakeholders, DCYF staff, and public groups as necessary and directed. Required Qualifications: Four (4) years of IT experience, such as consulting, analyzing, designing, coding and/or maintaining software applications and/or databases, and providing technical support in Information Technology. AND Three (3) years of recent experience developing analytic data solutions using a Business Intelligence analytic tool preferably, Power BI or Tableau, including Visual Studio and SQL Server Management Studio, and implementing Analytic 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 (3) years of recent experience working with relational databases, preferably SQL server, and writing T-SQL. Experience using a source code versioning management tool. Two (2) years of recent experience working with star schema Data Warehouse databases. Good communication skills, both orally and written. Ability to communicate from a technical and business perspective. Ability to work in a team environment. Demonstrated and verifiable customer service skills. Preferred Qualifications: Demonstrated knowledge and understanding of the business of DCYF. Experience with Primary Prevention datasets, models and topics. Experience testing complex analytic data products and analytic systems. Experience using an automated flowcharting tool such as MS Visio. Experience with at least one of the scripting languages (R, Python). Experience with visualization software such as Tableau or Power BI. Experience with front-end web development for data display (i.e. PowerShell, C#/VB.net, HTML, CSS and/or JavaScript). *Experience may be gained concurrently. 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 View email address on click.appcast.io. If you're experiencing technical difficulties creating, accessing or completing your application, call NEOGOV toll-free at View phone number on click.appcast.io or View email address on click.appcast.io. Persons needing accommodation in the application process or this announcement in an alternative format may call the Telecommunications Device for the Deaf (TDD) at View phone number on click.appcast.io. DCYF participates in the federal E-Verify program. The selected candidate must provide proof of identity and authorization to work in the United States, consistent with E-Verify requirements, on their first day of employment. #J-18808-Ljbffr Washington Department of Natural Resources