Juvenile Rehabilitation Forecast Analyst | Management Analyst 5 - Olympia

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

Job summary

An established industry player is seeking a detail-oriented Juvenile Rehabilitation Forecast Analyst to join their team. This role focuses on maintaining the Juvenile Rehabilitation Services portfolio, crucial for budgeting and financial forecasting. You will dive into data, design predictive models, and present findings to stakeholders, all while contributing to the mission of protecting and nurturing youth. If you have a passion for data analysis and want to make a positive impact in juvenile rehabilitation, this opportunity could be your next career step. Join a team that values diversity and equity, and help shape the future of youth services.

Qualifications

• 5+ years in financial/budget forecasting and statistical analysis.
• Proficiency in SQL and experience with large datasets.

Responsibilities

• Maintain the JR per-cap forecast portfolio accounting for over $175M.
• Design forecast models to predict expenditure volume and trends.

Skills

SQL

Statistical Analysis

Advanced Excel

Data Modeling

Problem-Solving

Education

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

Tools

Microsoft SQL Server

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 forecasts include facilities such as Echo Glen Children's Center (Snoqualmie), Green Hill School (Chehalis), and eight (8) Community Facilities across various regions. The ideal applicant enjoys diving into data and will have an opportunity to leverage that passion to positively impact youth in juvenile rehabilitation. There will also be opportunities to demonstrate problem-solving skills and creativity when analyzing the fiscal impacts of new policies.

Some of what you will do:

• Maintain the JR per-cap forecast portfolio, accounting 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 stakeholders regarding the fiscal impacts of policy and macroeconomic trends.
• Work with DCYF staff to design data collection systems, establish data integrity rules, and perform quality assurance.

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.
• Proficiency in SQL, experience with large data sets, familiarity with relational databases and systems like Microsoft SQL Server.
• Advanced knowledge of Microsoft Excel.
• Proficiency in statistical tools such as R, Python, SAS, Stata, MathLab, or similar for statistical analysis.
• Experience with advanced statistical modeling, including multivariate linear regression or time series models like ARIMA, exponential smoothing, etc.

Note: The incumbent must complete required training courses within one year of appointment.

Additional preferred qualifications:

• Familiarity with AFRS Data and reporting platforms like web-intelligence and Enterprise Reporting.
• Experience with Washington State Financial systems, public budgeting, and accounting.
• Ability to translate policy and budgetary needs into SQL queries.
• Experience with advanced statistical models such as ARIMA or exponential smoothing.

How do I apply?

Complete the online application and attach your current resume. Supplemental materials are welcome but not required.

Additional Information:

DCYF is committed to diversity and equity. We encourage all qualified candidates to apply, even if their experience doesn't align perfectly with every qualification. We are an equal opportunity employer and do not discriminate.

This recruitment may fill multiple vacancies. This position is in a bargaining unit represented by WFSE. For more info, visit https://wfse.org/.

Questions or accommodation requests? Contact Veronica Jones at [e-mail]. Technical support: call NEOGOV at [phone] or email [e-mail]. For TDD assistance, call [phone].