Compliance Analyst, Management Analyst 5 (MA5) - Olympia

Description

Our vision ensures that “Washington State’s children and youth grow up safe and physically, emotionally and educationally, nurtured by family and community."

Job Title: Compliance Analyst (MA5)

Location: Olympia, WA - Hybrid. Mostly remote with occasional travel to the Olympia Headquarters office for training and audit related meetings.

Closes: Tuesday, March 04, 2025

Salary: $74,724 - $ 100,524 Annually.

To accomplish our mission of protecting children and strengthening families so they flourish, the Dept. of Children, Youth, and Families (DCYF) relies on funding from a variety of sources, each of which carries its own requirements. DCYF is looking for prudent individuals to help ensure that DCYF maintains compliance with the Child Care Development Grant (approximately $408M per year) and meets its reporting requirements through a variety of tasks focused on quality assurance and process control.

DCYF Finance Division would like to take this opportunity to provide our cultural principles to help candidates familiarize themselves with the work environment we aim to keep

We serve the mission. DCYF’s mission is to protect children and strengthen families so they flourish. Finance is fundamental to the agency achieving its strategy.

We are great partners and focused on the work that matters so we drive great results. Great partnership starts with having the right people at the table early and often.

We are the finance team/employer of choice. We will be respectful and create a positive work environment without judgements.

We are curious and continue to learn. We see mistakes as an opportunity to better understand where things need to change.

We are future focused. We understand that things change but we stay focused on serving those who serve our mission (strategic outcomes).

Click here to learn more about DCYF.

The Opportunity (Management Analyst 5):

In this role, you will provide a highly specialized and technical skillset, expert level analysis, and extensive documentation that will help to ensure DCYF is meeting its financial accountability standards. Due to a multi-million-dollar audit finding, this position is critical to the elimination of future findings and is mandated by the Legislature. In addition, your fund utilization analysis will serve a crucial role in informing the Working Connections Child Care per capita forecast; A program which is expected to exceed $1B in fiscal year 2027.

This position provides an opportunity for growth and can function as a stepping stone to other roles. It fills a niche that requires both the knowledge of Washington State accounting practices that and technical know-how, both of which would be applicable to any Washington State agency. In addition, we also offer resources to refine new skills and stay up to date on the new methods through our office's DataCamp license.

Through this position, an individual is able to make a difference by helping to preserve funding that over 42,000 families in Washington State rely on for access to affordable child care.

An assessment of programming competency may be administered due to the technical nature of this position.

Some of what you will do:

• Coordinate, validate and document highly complex financial data.
• Utilize SQL knowledge to isolate specific transactions made through the Social Services Payment System (SSPS).
• Coordinate with program staff and the SSPS team each month to ensure that all account coding related to the child care subsidy program is correct and up to date.
• Ensure payments are marked for the correct source of funds and accounts when transmitted to AFRS.
• Work with the Economic Services Administration (ESA) division of the Department of Health and Human Services (DSHS) to ensure that any problems are documented, corrected, and fully resolved.
• Work with the cost allocation unit, budget office, and program to ensure corrections to funding are accurately reflected in the financial data.
• Analyze and research cost allocation forecasting data.
• Forecast state and federal split for use in the forecast-to-budget files .
• Remain up to date on current rules and maintain awareness of any changes to available programmatic funding streams.
• Document all aspects of processes for auditors to reference to convey the soundness of established processes.

Required Qualifications:

• Bachelor’s degree in finance, information science, or computer science, AND five years of experience in the following:
• Experience in writing moderately complex SQL scripts, views, stored procedures and triggers using MS SQL TSQL. Considerations will be made for SAS or languages such as Python, R, etc.
• Experience with ETL (Extract, Transform, Load) using SQL Server Management Studio. Considerations will be made for SAS or languages such as Python, R, etc.
• Experience with quality assurance and process control.

OR

Equivalent combination of education and experience totaling nine years in the following:

• Experience in writing efficient and moderately complex SQL scripts, views, stored procedures and triggers using MS SQL TSQL. Considerations will be made for SAS or languages such as Python, R, etc.
• Experience with ETL (Extract, Transform, Load) using SQL Server Management Studio.Considerations will be made for SAS or languages such as Python, R, etc.
• Experience with quality assurance and process control.

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

Previously demonstrated knowledge, skills, and abilities:

• Familiarity with the Agency Financial Reporting System (AFRS).
• Familiarity with the Social Services Payment System (SSPS).
• Familiarity with Child Care Development Fund (CCDF) and Temporary Assistance for Needy Families (TANF) rules.
• Familiarity social service program funding.
• Ability to conduct through analysis and assessments from a variety of information sources.
• Analytical and reasoning skills: document processes and outcomes for consistency and completeness.
• Proficient in Microsoft products, with advanced level in Excel.

How do I apply?

Complete your applicant profile and attach the following documents:

• Letter of interest describing how you meet the specific qualifications for this position.
• Current resume detailing experience and education.

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 position is in a bargaining unit represented by the Washington Federation of State Employees (WFSE). For more information: https://wfse.org/.

This recruitment may be used to fill multiple vacancies.

Benefits eligibility for this position may be different than what’s listed in the benefits tab of this recruitment announcement, for more information on employee benefits eligibility visit- Public Employee Benefits Board (PEBB).

If you have any questions pertaining to this recruitment or if you would like to request an accommodation throughout the application/interview process, contact David Ozment (Talent Acquisition Specialist) at david.ozment@dcyf.wa.gov.

If you're experiencing technical difficulties creating, accessing or completing your application, call NEOGOV toll-free at (855)524-5627 or email support@neogov.com.Persons needing accommodation in the application process or this announcement in an alternative format may call (360) 902-2276 or the Telecommunications Device for the Deaf (TDD) at (800) 833-6388.

00914