Director, Program Management - Remote

Novalink Solutions LLC•Tallahassee, FL

20h•Remote

About The Position

This Director, Program Management role focuses on providing comprehensive program financial management support. Key responsibilities include maintaining and developing budget planning tools like the Program’s Estimation Workbook, creating various budget scenarios based on strategic adjustments and appropriations, and performing detailed budget analyses on legislative offers. The role involves reviewing and providing feedback on budget requests within critical documents such as Advance Planning Documents (APDs), D-3As, Schedule IV-Bs, and Operational Work Plans (OWPs). Additionally, the Director will be responsible for developing workbooks to translate budget projections between state and federal fiscal years to meet CMS reporting requirements, preparing detailed budget tables (MDBT), and capturing data for fiscal year budget requests. Other duties include preparing Cost Benefit Analyses, assisting the Agency with funding stakeholder questions, analyzing proposed legislative budgets, developing and reviewing spending plans, calculating budget release amounts for OWPs, and advising on cost allocation methodologies for Medicaid Enterprise projects. The position also involves researching CMS Federal Financial Participation percentages, funding authorization, and reimbursement processes upon request.

Requirements

10+ years of IT and business/industry work experience
5+ years of professional experience managing highly complex or enterprise-wide IT projects using the Project Management Institutes’ current Project Management Body of Knowledge
3+ years of leadership experience
Extensive knowledge of advanced spreadsheet design, data modeling, and financial/operational analysis using Microsoft Excel
Deep understanding of complex formulas and functions
Understanding of reporting tools including PivotTables, PivotCharts, and dashboard creation
Ability to develop and maintain complex, largescale Excel workbooks with multiple interdependencies
Advanced skill in creating dynamic dashboards and reports for executive-level decision-making
Proficiency in automating repetitive processes using macros and VBA to improve efficiency and accuracy
Ability to translate complex data into clear, actionable insights for both technical and non-technical stakeholders
Strong attention to detail with a high degree of accuracy in data handling and reporting
Ability to manage multiple projects and deadlines while maintaining data integrity
Capability to train and support team members in advanced Excel techniques
Knowledge and expertise in the use of Project Management methodologies and tools

Nice To Haves

Prior state government accounting or leadership experience preferred

Responsibilities

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
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
Review and provide feedback on the budget requests within final drafts of Advance Planning Documents (APDs)
Review and provide feedback on budget information within final drafts of D-3As, Schedule IV-Bs, and Operational Work Plans (OWPs)
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.
Develop a workbook to capture and analyze data for a fiscal year budget request, which supports the creation of the D-3A
Prepare the Cost Benefit Analysis (CBA) for the Schedule IV-B
Assist the Agency in responding to budget questions from funding stakeholders
Perform analysis, review, and provide feedback on draft responses to questions from funding stakeholders
Perform analysis on Legislative House and Senate proposed Program budgets and proviso language
Develop preliminary and initial fiscal year spending plans
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
Prepare budget release amount calculations for inclusion in quarterly OWPs
Meet with Agency budget staff to address their questions regarding quarterly OWP release calculations
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.
Upon request by the Agency, research issues regarding CMS Federal Financial Participation (FFP) percentages, funding authorization, and reimbursement processes