IT Data Management – Journey (Prevention BI Analyst)

State of Washington•Thurston County – Olympia, WA

18h•Hybrid

About The Position

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." 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.

Requirements

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.
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.
The ability to take action to learn and grow
The ability to take action to meet the needs of others.
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.

Nice To Haves

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.

Responsibilities

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.

Benefits

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 [email protected].
If you're experiencing technical difficulties creating, accessing or completing your application, call NEOGOV toll-free at (855)524-5627 or email [email protected].
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.
Applicants who meet the minimum qualifications and wish to claim Veteran's Preference MUST attach a copy of their DD214, NGB Form 22 or Predischarge Certification (issued not more than 120 days prior to End of Term of Service (ETS) by date of submission).
If claiming preference based on Predischarge Certification, individual will be required to provide their official discharge documentation, such as a DD form 214, NGB form 22, or equivalent, within 30 days after the date of discharge.
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 .
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.