Tuesday, March 10, 2015

Data Analyst-Health Care Authority(Olympia,WA)

State of Washington Health Care Authority invites applications for the position of:
Fiscal Information and Data Analyst (71029130, 71028964, 71029099)
SALARY: Depends on Qualifications
OPENING DATE: 01/16/15
CLOSING DATE: Continuous

Fiscal Information and Data Analyst (71029130, 71028964, 71029099)
Permanent (WMS Band 2) Olympia, WA
*This recruitment will be used to fill three positions*
The Health Care Authority (HCA) is Washington’s largest health care purchaser, responsible for providing comprehensive health coverage to nearly 2 million residents through the Public Employees Benefits and Medicaid programs. The agency provides health purchasing leadership, benefitting both public and private sectors with a focus on moving the health delivery system away from volume toward higher value and better outcomes.
The Olympia office is located in downtown Olympia, within walking distance of shops, restaurants, bus lines, and less than two (2) miles from the freeway.
The Financial Services Division works in collaboration with the other divisions within the Health Care Authority (HCA) and a variety of external stakeholders and customers to provide financial services and agency-wide financial management which includes managing the operating budget ($15 billion per biennium, 1,050 FTEs), forecasting, accounting, provider rates development, hospital financing, internal audit and other critical financial functions for the HCA.
The Medicaid Budget Section is responsible for the entire HCA Medicaid and administrative budget which totals approximately $12 billion per biennium and approximately 1,000 FTEs and includes diverse funding sources. This section performs high level financial analysis to inform policy decisions with the agency leadership team, OFM, and the legislature. Additionally, individuals in this team track expenditures to ensure that the agency does not overspend its appropriation, monitor expenditures against the per-capita forecast, and provide explanations of variances to OFM and legislative fiscal staff. The Fiscal Information and Data Analyst (FIDA) in the Medicaid Budget Section reports directly to the Medicaid Budget Section Manager.

Position Objective:
The Fiscal Information and Data Analysts (FIDA) provide advanced level technical advice to the Medicaid Budget section manager and Chief Financial Officer (CFO) for the entire HCA Medicaid budget which totals approximately $12 billion per biennium and includes approximately 1,000 FTEs. The budget includes funding to provide low-income individuals throughout the state with medical services coverage through the federal Medicaid and Children’s Health Insurance Programs, and the state funded Disability Lifeline, Children’s Health .
The position is responsible for developing and monitoring HCA’s administrative and Medicaid clients’ benefits budget, agency budget requests, allotment processes, fiscal notes, and assuring that processes are completed within Office of Financial Management (OFM) guidelines and meet all budgetary requirements as directed by the Chief Financial Officer (CFO). In addition, this position is charged with monitoring expenditures against allotment and forecast to identify any fiscal issues for HCA, OFM, program managers and stakeholders, and assures the fiscal information reported to OFM, legislature staff, and the federal government is accurate.
This position is responsible for developing modeling and strategies for sound fiscal projections to ensure adequate funding for assigned agency programs. This position is also responsible for supporting and providing fiscal impact for the agency’s policy options. The analysis provided to the agency has substantial impact to the agency administration and citizens and/or clients who receive services if adopted by agency. This position is required to understand the elements of all HCA programs and how they interrelate; requires significant experience and knowledge of technical, programmatic, and budget, as well as state and federal legislation that impacts the agency.

Medicaid Budget Section:
This position is assigned to the Medicaid Budget Section, which provides advanced level technical expertise on all budget issues for the agency and all its programs. This position is responsible for developing complex financial models which are used to inform agency's budget request and policy decisions within its assigned areas of responsibility.
Developing, Maintaining, and Monitoring the HCA's administrative and Medicaid clients' benefits budget,
Develop the budget development process, allotment process, agency decision package submittals, fiscal notes, and assures that processes are completed within OFM guidelines and meet all budgetary requirements, as directed by the Health Care Authority Director.
Coordinate with fiscal and programmatic staff to ensure accuracy and that budget policy objectives are met to accomplish the strategic goals of the agency in the agency biennial and supplemental funding proposals.
Provide complex decision packages for consideration by the HCA director, OFM and legislature that outline issues with current funding and/or initiate policy proposals to address anticipated future fiscal needs.
Assure decision package and financial data are accurately and timely entered into the budget development system.
Develop, determine and prepare fiscal notes and bill analyses during the legislative session. Develop budget allocations for the agency, review and evaluate the legislative budget, determining impacts to allotments.
Develop methodology to allocate the enacted budget. Ensure the allocation is accurate and on time.
Provide compensation data, during the state's collective bargaining process.
Provide and maintain performance measure updates on the BASS system.
Produce and/or review monthly fiscal status report regarding agency expenditures.
Monitor and analyze agency expenditures as compared to budgets and forecasts.
Responsible for fiscal analyses to internal and external requests regarding the agency's financial performance.
Estimating Fiscal Impacts/Decision Support
Hold primary responsibility to develop modeling and strategies for sound fiscal projections to ensure adequate funding for agency programs.
Develop cost impact models that define fiscal impacts that proposed state and federal legislation will have on agency
Responsible for providing fiscal impact for agency's policy decision.
Perform all financial/budget-related tasks that assist the agency
Provide fiscal expertise and develop fiscal processes and estimate for new federal grants, studies and projects, and the State Plan Amendment.
Respond to internal and external requests regarding the agency's budget and fiscal status.
Coordination with other Units/Programs
Act as fiscal liaison in the workgroups that develop the agency's caseload and expenditures forecasts; Work closely with accounting to ensure monthly accruals and data corrections are developed properly and on time.
Work closely with forecast section and accounting section to ensure the accuracy of the fiscal year close activities.


Required Qualifications:
Master's Degree in public administration or related field, CPA, and two years of experience working with large and complex budget development processes is required. Experience within the State or other government entity is strongly preferred.
Bachelor's degree, in public administration, accounting, or related field, and three or more years of experience working with large and complex budget processes is required. Experience within the State or other government entity is strongly preferred. Additional 3 years state budget experience may subsitute for one year of the required education.

Significant experience in working with large and complex budget development processes, significant experience and knowledge of the state budgetary process, including knowledge of Office of Financial Management and the State Legislative approach to the budget process.
Expert/Advanced level skill and experience with Microsoft Excel and working knowledge of Access, designing complex modeling, structuring ad-hoc data for use in pivot tables, and composing nested function formulas. Working knowledge in ODBC-Iinked pivot tables, join querying, and/or macro development in Visual Basic for Applications (VBA) preferred;
Effective verbal and written communication skills, including the ability to translate complex financial/analytical information for non-financial/non-analytical audiences;
Ability to creatively use available resources to develop/document workload processes and analytical tools.
Experience using the Washington State Agency Financial Reporting System (AFRS);
Knowledge of the Automated Client Eligibility System (ACES) and the Medicaid Management Information
System (MMIS);
Experience using the Washington State Budget Development System (BDS);
Experience composing decision packages and fiscal notes for the annual Washington State legislative session;
Experience communicating with an array of audiences, ranging from staff with little financial background to elected government officials and federal auditors;
Experience in analytical querying protocols/software such as SAS or SQL;
Knowledge of the protocols and processes of the executive and legislative branches of state and local government;

Preferred/Desired Education, Experience, and Competencies.
Two or more years of experience conducting statistical analysis using SAS or other statistical analysis programs; Four or more years experience in the development of Excel spreadsheet models for use in financial projection and analysis.
A minimum of seven years experience working in the financial field; Experience working for the
Washington State legislature process;
Experience working for the federal government; and
Familiarity with the State and Federal laws, rules, and regulations that impact/govern the State's Medicaid, CHIP and state funded health programs.

Please Note the Following:
Application assessment will be ongoing and the hiring authority reserves the right to offer the position at any time during the recruitment process. It is to the applicant’s advantage to apply as early as possible.

How to Apply:
To apply for this position you will need to complete your profile within http://careers.wa.gov and attach to your profile before completion:
A cover letter
Current resume
Three professional references

If you have questions about the process, or need assistance, please contact the recruiter listed below before the posting closes. Failure to follow the application instructions below may lead to disqualification. The candidate pool certified for this recruitment may be used to fill future similar vacancies for up to the next six months.
Contact us:
For inquiries about this position, please contact Sanyu Tushabe at 360-725-1180 or email to Sanyu.Tushabe@hca.wa.gov.
Persons under final consideration for initial appointment with HCA are subject to a background check.

Washington State is an equal opportunity employer Persons with disabilities needing assistance in the application process, or those needing this job announcement in an alternative format may call the Human Resources Office at 360.725.1180 or email Sanyu.Tushabe@hca.wa.gov.