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 - $ 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…