State of Washington · 3 weeks ago
Fiscal Information & Data Analyst (WMSG2/FS)
Walla Walla, WA
Full-time
Hybrid
Mid, Senior Level
3+ years expThe State of Washington is seeking a Fiscal Information & Data Analyst to provide high-impact, mission-oriented work in public service. This role involves advanced technical analysis to influence financial and policy decisions for Washington State's healthcare programs, specifically managing the HCA Medicaid budget and developing fiscal projections and analyses.
AssociationCommunitiesEducationEmploymentEventsGovernmentInformation TechnologyNewsNon Profit
Responsibilities
Perform and provide complex analysis and financial modeling for decision packages under consideration by the HCA director, Chief Financial Officer, OFM, and legislature that outline issues with current funding and/or initiate policy proposals to address anticipated future needs
Lead the development of modeling and strategies for sound fiscal projections to ensure adequate funding for agency programs
Annual development, updating, and reconciliation of financial models and data used for fiscal notes involving state and Medicaid funds
Develop and review fiscal notes, bill analyses, and budget versions during the legislative session as needed
Develop fiscal projections/impact analyses and related models in support of effective fiscal management of, and adequate funding for, agency programs; present analyses to HCA decision makers and other stakeholders; document development process, including assumptions, data sources, etc
Coordinate with fiscal and programmatic staff internal and external to the HCA to ensure the accuracy of data and information presented in agency biennial and supplemental funding proposals
Contribute to the development of the Medicaid per capita forecast; confirm accuracy of forecast output
Oversee any necessary adjustments, specialty payments, and journal vouchers (JVs) for Medicaid services
Provide technical assistance and contribute to the development of Medicaid managed care rates
Qualification
Required
Intermediate/Advanced level skills with Microsoft Excel and working knowledge of designing complex modeling, structuring and ad-hoc data for use in pivot tables
Ability to creatively use resources to create and document work processes and analytical tools
Working knowledge of analytical query protocols/software such as SQL
Ability to analyze data, identify data needs, develop problem solving strategies, support ideas using data as evidence, develop goals and priorities, and establish benchmarks
Ability to analyze and research the differences among budgeted and forecasted expenditures and actual expenditures and effectively communicate the reason for the differences
Analytical skills for financial research and modeling in complex multi-system environments
Effective verbal and written communication skills, including the ability to translate complex financial/analytical information for non-financial/analytical audiences
Experience communicating with an array of audiences, ranging from staff with little financial background to elected government officials and federal auditors
Ability to coordinate and build consensus among internal/external stakeholders toward the development of department and legislative initiatives
Ability to develop and review complex written materials and provide detailed policy analysis
The ability to take action to learn and grow
The ability to take action to meet the needs of others
Ability to communicate in a positive manner with diverse audiences and facilitate large and small teams
Ability to maintain a high level of confidentiality
Bachelor's degree in public administration or related field and three (3) or more years of professional experience working with large, complex financial systems/information is required
Seven (7) years of professional experience in financial, analytical, accounting, or relevant Medicaid/HCA experience
Preferred
Master's degree in public administration or related field, and two (2) years of professional experience working with large, complex financial systems/information. Experience within the State or other government entity is strongly preferred
Two (2) or more years of experience querying data through programs such as SQL
Four (4) or more years of experience in the development of financial modeling
Seven (7) years of experience working in the financial field
Expert/advanced level skill with Microsoft Excel and working knowledge of designing complex modeling, structuring ad-hoc data for use in pivot tables and composing nested formulas
Experience working with the Washington State Agency Financial Reporting System (AFRS) data
Experience contributing to decision packages and fiscal notes
Knowledge of protocols/processes of the executive/legislative branches of state government
Knowledge of Provider One System
Experience with the Washington State Budget Development System (BDS)
Experience working with the federal government
Familiarity with State and Federal laws, rules, and regulations that impact/govern the State's Medicaid, CHIP, and state funded health programs
Benefits
Meaningful work with friendly co-workers who care about those we serve Voices of HCA.
A clear agency mission that drives our work and is person-centered HCA's Mission, Vision & Values.
A healthy work/life balance, including alternative/flexible schedules and mobile work options.
A great total compensation and benefit package WA State Government Benefits.
A safe, pleasant workplace in a convenient location with restaurants, and shopping nearby.
And free parking!
Insurance Benefits
Employees and their families are covered by medical (including vision), dental and basic life insurance.
Staff are eligible to enroll each year in a medical flexible spending account which enables them to use tax-deferred dollars toward their health care expenses.
Employees are also covered by basic life and long-term disability insurance, with the option to purchase additional coverage amounts.
Dependent care assistance allows the employee to save pre-tax dollars for a child or elder care expenses.
Other insurance coverage for auto, boat, home, and renter insurance is available through payroll deduction.
The Washington State Employee Assistance Program promotes the health and well-being of employees.
Retirement And Deferred Compensation
State Employees are members of the Washington Public Employees' Retirement System (PERS).
New employees have the option of two employer contributed retirement programs.
Employees also have the ability to participate in the Deferred Compensation Program (DCP).
Public Service Loan Forgiveness
If you are employed by a government or not-for-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program.
Holidays
Full-time and part-time employees are entitled to paid holidays and one paid personal holiday per calendar year.
Sick Leave
Full-time employees earn eight hours of sick leave per month.
Vacation (Annual Leave)
Full-time employees accrue vacation leave at the rates specified in WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA).
Military Leave
Washington State supports members of the armed forces with 21 days paid military leave per year.
Bereavement Leave
Most employees whose family member or household member dies, or for loss of pregnancy, are entitled to five (5) days of paid bereavement leave.
Company
State of Washington
Washington state public employees help to create a working Washington built on education and innovation, where all Washingtonians thrive.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Matt Manweller
State Representative
Company data provided by crunchbase