Director, Program Management - Remote

with Program financial management support to include the following services and activities:

a.     Maintain the Program’s Estimation Workbook as the central budget planning tool, which contains all cost data for the Program, both historical/actual data and estimated data for future periods

b.     Create budget scenarios based on adjustments to the Strategic Roadmap, other strategy decisions, and/or appropriation, including performing budget analyses on legislative budget offers prior to enactment of the annual General Appropriations Act

c.     Review and provide feedback on the budget requests within final drafts of Advance Planning Documents (APDs)

d.     Review and provide feedback on budget information within final drafts of D-3As, Schedule IV-Bs, and Operational Work Plans (OWPs)

e.     Develop a workbook to translate budget projections from state fiscal year into federal fiscal year, such that it conforms to CMS reporting requirements for Advance Planning Documents (APDs). This includes preparing budget tables in the format prescribed by CMS, preparing budget requested amounts by CMS Medicaid Detail Budget Table (MDBT) line numbers (2AB, 4AB, 5ABC), preparing the MDBT, and preparing expenditure data by budget line item using source information provided by the Agency.

f.      Develop a workbook to capture and analyze data for a fiscal year budget request, which supports the creation of the D-3A

g.     Prepare the Cost Benefit Analysis (CBA) for the Schedule IV-B

h.     Assist the Agency in responding to budget questions from funding stakeholders

a.     Perform analysis, review, and provide feedback on draft responses to questions from funding stakeholders

b.     Perform analysis on Legislative House and Senate proposed Program budgets and proviso language

c.     Develop preliminary and initial fiscal year spending plans

d.     Provide a high-level review each month of the Spending Plan. This activity may result in interactions with Agency staff to advise on needed corrections and/or modifications to information contained in the Spending Plan

e.     Prepare budget release amount calculations for inclusion in quarterly OWPs

f.      Meet with Agency budget staff to address their questions regarding quarterly OWP release calculations

g.     Develop cost allocation methodologies and formulas and advise the Agency on cost allocation decisions related to Medicaid Enterprise projects. This includes preparing budget information for the work activities cited above using cost allocation methodologies, as applicable.

h.     Upon request by the Agency, research issues regarding CMS Federal Financial Participation (FFP) percentages, funding authorization, and reimbursement processes

Required Knowledge, Skills & Abilities

a.     10+ years of IT and business/industry work experience

b.     5+ years of professional experience managing highly complex or enterprise-wide IT projects using the Project Management Institutes’ current Project Management Body of Knowledge

c.     3+ years of leadership experience

d.     Extensive knowledge of advanced spreadsheet design, data modeling, and financial/operational analysis using Microsoft Excel

1.     Deep understanding of complex formulas and functions

2.     Understanding of reporting tools including PivotTables, PivotCharts, and dashboard creation

3.     Ability to develop and maintain complex, largescale Excel workbooks with multiple interdependencies

4.     Advanced skill in creating dynamic dashboards and reports for executive-level decision-making

5.     Proficiency in automating repetitive processes using macros and VBA to improve efficiency and accuracy

a.     Ability to translate complex data into clear, actionable insights for both technical and non-technical stakeholders

b.     Strong attention to detail with a high degree of accuracy in data handling and reporting

c.     Ability to manage multiple projects and deadlines while maintaining data integrity

d.     Capability to train and support team members in advanced Excel techniques

e.     Knowledge and expertise in the use of Project Management methodologies and tools

f.      Prior state government accounting or leadership experience preferred

​

​