Fiscal Information and Data Analyst (WMS2/FS) - Internal Only

State of Washington•Thurston County – Olympia, WA

3d•Hybrid

About The Position

The Fiscal Information and Data Analyst develops and monitors key components of Medicaid services and benefits budgets, the HCA administrative budget, agency budget requests, fiscal notes, and financial analyses. The position ensures that processes and deliverables meet HCA and Office of Financial Management requirements and guidelines. It identifies and analyzes financial variances and communicates findings accurately and promptly to program managers, HCA executive management, OFM, and other relevant parties. The role develops financial models, projections, and strategies to support sound financial management and operations of Medicaid programs and services. It conducts fiscal impact analysis and requires detailed understanding of multiple program areas from business, legislative, regulatory, budget, and technical perspectives. A particular focus is financial analysis and funding for Indian Health Services and Tribal providers, including expenditure monitoring, forecasting, policy development, and rate setting. This is a full-time, 40-hour-per-week hybrid position based at the HCA office in Olympia, Washington. The role requires in-office attendance during initial training and, after training, every Tuesday and as needed for business. Standard business hours are Monday through Friday, 8 a.m. to 5 p.m.; alternative schedules may be considered based on business needs. The employee works in a shared, open-office environment, collaborates regularly with colleagues and internal and external stakeholders, and may travel occasionally for meetings, training, or other business needs. The opportunity is open only to current HCA employees, who must be Washington State residents by their first day of employment.

Requirements

Comprehensive knowledge and thorough understanding of State and Federal Medicaid regulations and responsibilities.
Knowledge of budget development in private industry or at the federal, state, or local level.
Knowledge of general principles of health insurance structure, purchasing, and employee benefits programs.
Knowledge of policy development and implementation.
Ability to manage multiple high-priority assignments and resources concurrently, take initiative to resolve problems, and recommend alternatives when appropriate.
Advanced Microsoft Excel skills, including designing complex models, structuring ad hoc data for pivot tables, and composing nested formulas.
Ability to design, build, and maintain sophisticated financial models.
Experience contributing to complex financial models, tracking utilization, and identifying long-term expenditure trends in data.
Ability to translate data into clear policy briefings, white papers, and actionable strategies for executive leaders.
Strong auditing capabilities for monitoring expenditures and ensuring appropriate payment distribution.
Ability to independently track and execute complex financial reconciliations.
Hands-on experience documenting data sources and fiscal assumptions with attention to detail.
Ability to develop and review complex written materials and provide detailed policy analysis.
Ability to serve as a subject matter expert on interagency policy and data workgroups.
Emotional intelligence and diplomacy to act as a fiscal liaison among internal accounting and program staff, federal partners, and external Tribal leadership.
Effective verbal and written communication skills, including the ability to explain complex financial and analytical information to non-financial audiences.
Required competencies include applying an equity lens, taking action to learn and grow, and taking action to meet the needs of others through listening, understanding perspectives, and responding with care and respect.

Nice To Haves

Experience working with Washington State Agency Financial Reporting System (AFRS) data.
Experience contributing to decision packages and fiscal notes.
Knowledge of protocols and processes of the executive and legislative branches of state government.
Knowledge of the Medicaid Management Information System (MMIS).
Experience with the Washington State Agency Budget System (ABS).
Familiarity with State and Federal laws, rules, and regulations governing Medicaid, CHIP, and state-funded health programs.
Significant experience with complex budget development processes and knowledge of the state budget process, including OFM and the State Legislature's approach to budgeting.
Experience querying data using programs such as SQL.
Experience developing financial models.
A bachelor's degree from an accredited college or university in statistics, science, mathematics, data science, public administration, or a related field; or an associate degree plus five years of professional experience working with large, complex financial systems or information; or seven years of such professional experience.

Responsibilities

Perform complex analysis and financial modeling for Medicaid services related to or affecting Indian Health Services and Tribal providers, for consideration by HCA's Office of Tribal Affairs, the HCA Director, Chief Financial Officer, OFM, and the Legislature.
Develop fiscal projections, impact analyses, and related models to support effective fiscal management and adequate funding for agency programs.
Present analyses to HCA decision makers and other stakeholders, and document development processes, assumptions, and data sources.
Monitor and analyze agency expenditures affecting IHS/Tribal provider services and MCO expenditures, comparing them with relevant budgets, forecasts, and projections.
Coordinate with internal and external fiscal and program staff to ensure the accuracy of information in agency proposals and alignment of budget policy objectives with HCA strategic goals.
Serve as a fiscal liaison and provide financial data and analysis to internal and external workgroups related to IHS/Tribal providers.
Contribute to development of the Medicaid per capita forecast and confirm the accuracy of forecast outputs related to IHS/Tribal provider services.
Assist with policy development and rate setting for Tribal provider cost-based rates for residential treatment facilities and secure withdrawal management facilities.
Analyze and communicate financial variances to program managers, HCA executive management, OFM, and other appropriate parties.