Juvenile Rehabilitation Forecast Analyst | Management Analyst 5 - Olympia

State of Washington; Washington (District of Columbia); Remote; USD 74,000 - 101,000; Full time

Job summary

Join a leading agency in Washington as a Juvenile Rehabilitation Forecast Analyst. This role involves maintaining a significant budget portfolio, designing forecast models, and collaborating with stakeholders to ensure fiscal responsibility. If you have a passion for data and making a positive impact on youth rehabilitation, this position offers a unique opportunity to leverage your skills in a meaningful way.

Qualifications

• 5 years in financial/budget forecasting or advanced analysis.
• Proficiency in SQL and large data sets.
• Experience with advanced statistical modeling.

Responsibilities

• Maintain the JR per-cap forecast portfolio accounting for over $175M.
• Design forecast models for JR programs.
• Present findings and recommendations to stakeholders.

Skills

SQL

Statistical Analysis

Data Analysis

Education

Bachelor's degree in finance, statistics, mathematics, economics

Tools

Microsoft SQL Server

Microsoft Excel

R

Python

SAS

Stata

MathLab

Job description

"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: Juvenile Rehabilitation Forecast Analyst (MA5)
Location:Olympia, WA. Remote Optional. This is planned to be an almost fully remote position with the occasional in-person meetings in Olympia, however, this is still to be determined.
Closes: Wednesday, May 21st, 2025
Salary:$74,724.00 - $100,524.00 Annually.The indicated salary does not include a 3% general wage increase effective July 1st, 2025.

The Department of Children, Youth and Families (DCYF) is looking for a Juvenile Rehabilitation Forecast Analyst (Management Analyst 5) to maintain the Juvenile Rehabilitation Services (JR) portfolio. The forecast is essential to the agency’s budgeting process and helps ensure the agency’s future financial position. This work allows us to carry out our organizational mission of protecting children and families so that they flourish.

Click here to learn more aboutDCYF.

The Opportunity:
As a Juvenile Rehabilitation Forecast Analyst (MA5), your primary responsibility is to maintain the Juvenile Rehabilitation Services portfolio. The individual forecasts included in this portfolio are Echo Glen Children's Center (Snoqualmie), Green Hill School (Chehalis), and eight (8) Community Facilities located throughout several regions.The ideal applicant enjoys diving into data and will have an opportunity to leverage that passion to make a positive impact on the lives of youth in juvenile rehabilitation. There will also be ample opportunities to demonstrate problem-solving skills and creativity when finding ways to answer questions regarding the fiscal impact of new policies.

Some of what you will do:

• Maintain the JR per-cap forecast portfolio. This portfolio will account for over $175M of DCYF’s operating budget for the 2023-2025 biennium.
• Design forecast models to predict expenditure volume and trends in JR programs.
• Aggregate data into tables, charts, and statistical measures of outcomes.
• Present research and findings along with recommendations to internal staff, other agencies, and external organizations.
• Facilitate the JR Technical Work Group meetings as a representative of DCYF.
• Collaborate with a wide range of stakeholders regarding the fiscal impacts of policy and macroeconomic trends.
• Work alongside other DCYF staff to design new data collection systems, create business rules on data integrity, and perform quality assurance tasks.

Required qualifications:

• A Bachelor's degree in finance, statistics, mathematics, economics, or a related field, AND five (5) years in financial/budget forecasting, advanced mathematical/statistical analysis, macroeconomic, microeconomic, or labor market analysis.
• Demonstrated proficiency in SQL, experience with working with large and complex data sets (e.g. millions of rows of observations); familiarity with relational database framework, and relational databases management systems such as Microsoft SQL Server.
• Demonstrated advanced knowledge of Microsoft Excel.
• Demonstrated proficiency using at least one of the following statistical tools: R, Python, SAS, Stata, MathLab or other similar language/tool to conduct statistical analysis.
• Experience with advanced statistical modeling utilizing multivariate linear regression, or time series models such as autoregressive integrated moving average models, exponential smoothing with dampening, etc.

Note:
The incumbent must successfully complete formal training courses as required by law, policy, and regional requirements within one (1) year of their appointment.

In addition to those required qualifications, our ideal applicant will also have some or all of the following:

• Demonstrated familiarity with the AFRS (Agency Financial Reporting System) Data, and reporting platforms such as web-intelligence and Enterprise Reporting.
• Experience with Washington State Financial in public budgeting and/or Accounting.
• Demonstrated ability to translate policy and budgetary needs into queries using SQL.
• Experience with advanced statistical modeling utilizing multivariate linear regression, or time series models such as autoregressive integrated moving average models, exponential smoothing with dampening, etc.

How do I apply?
In addition to completing the online application, applicants must attach the following documents to their profile to be considered for this position:

• Resume (current/updated)

Note:
Applicants are welcome to submit any supplemental materials they'd like to be considered, but only the resume is required.

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.

This position is in a bargaining unit represented by the Washington Federation of State Employees (WFSE). For more information:https://wfse.org/.

If you have any questions pertaining to this recruitment or if you would like to request an accommodation throughout the application/interview process, contact Veronica Jones (Talent Acquisition Specialist) at [e-mail]. If you're experiencing technical difficulties creating, accessing or completing your application, call NEOGOV toll-free at [phone] or [e-mail].

Persons needing accommodation in the application process or this announcement in an alternative format may call the Telecommunications Device for the Deaf (TDD) at [phone].

2025-03091