Director, Program Management - Remote
Novalink Solutions, Tallahassee, FL, United States
Job Description
withProgram financial management support to include the following services and activities:
a. Maintain the Program’s EstimationWorkbook as the central budget planning tool, which contains all cost data for theProgram, both historical/actual data and estimated data for future periods
b. Create budget scenarios based onadjustments to the Strategic Roadmap, other strategy decisions, and/orappropriation, including performing budget analyses on legislative budgetoffers prior to enactment of the annual General Appropriations Act
c. Review and provide feedback on thebudget requests within final drafts of Advance Planning Documents (APDs)
d. Review and provide feedback onbudget information within final drafts of D-3As, Schedule IV-Bs, andOperational Work Plans (OWPs)
e. Develop a workbook to translatebudget projections from state fiscal year into federal fiscal year, such thatit 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 expendituredata by budget line item using source information provided by the Agency.
f. Develop a workbook to capture andanalyze data for a fiscal year budget request, which supports the creation ofthe D-3A
g. Prepare the Cost Benefit Analysis(CBA) for the Schedule IV-B
h. Assist the Agency in responding tobudget questions from funding stakeholders
a. Perform analysis, review, andprovide feedback on draft responses to questions from funding stakeholders
b. Perform analysis on LegislativeHouse and Senate proposed Program budgets and proviso language
c. Develop preliminary and initialfiscal year spending plans
d. Provide a high-level review eachmonth of the Spending Plan. This activity may result in interactions withAgency staff to advise on needed corrections and/or modifications toinformation contained in the Spending Plan
e. Prepare budget release amountcalculations for inclusion in quarterly OWPs
f. Meet with Agency budget staff toaddress their questions regarding quarterly OWP release calculations
g. Develop cost allocationmethodologies and formulas and advise the Agency on cost allocation decisionsrelated to Medicaid Enterprise projects. This includes preparing budgetinformation for the work activities cited above using cost allocationmethodologies, 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 andbusiness/industry work experience
b. 5+ years of professionalexperience managing highlycomplex or enterprise-wide IT projectsusing the ProjectManagement Institutes’ current Project Management Body of Knowledge
c. 3+ years of leadership experience
d. Extensive knowledge of advancedspreadsheet design, data modeling, and financial/operational analysis usingMicrosoft Excel
1. Deep understanding of complexformulas and functions
2. Understanding of reporting toolsincluding PivotTables, PivotCharts, and dashboard creation
3. Ability to develop and maintaincomplex, largescale Excel workbooks with multiple interdependencies
4. Advanced skill in creating dynamicdashboards and reports for executive-level decision-making
5. Proficiency in automatingrepetitive processes using macros and VBA to improve efficiency and accuracy
a. Abilityto translate complex data into clear, actionable insights for both technicaland non-technical stakeholders
b. Strongattention to detail with a high degree of accuracy in data handling andreporting
c. Abilityto manage multiple projects and deadlines while maintaining data integrity
d. Capabilityto train and support team members in advanced Excel techniques
e. Knowledgeand expertise in the use of Project Management methodologies and tools
f. Priorstate government accounting or leadership experience preferred
#J-18808-Ljbffr
a. Maintain the Program’s EstimationWorkbook as the central budget planning tool, which contains all cost data for theProgram, both historical/actual data and estimated data for future periods
b. Create budget scenarios based onadjustments to the Strategic Roadmap, other strategy decisions, and/orappropriation, including performing budget analyses on legislative budgetoffers prior to enactment of the annual General Appropriations Act
c. Review and provide feedback on thebudget requests within final drafts of Advance Planning Documents (APDs)
d. Review and provide feedback onbudget information within final drafts of D-3As, Schedule IV-Bs, andOperational Work Plans (OWPs)
e. Develop a workbook to translatebudget projections from state fiscal year into federal fiscal year, such thatit 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 expendituredata by budget line item using source information provided by the Agency.
f. Develop a workbook to capture andanalyze data for a fiscal year budget request, which supports the creation ofthe D-3A
g. Prepare the Cost Benefit Analysis(CBA) for the Schedule IV-B
h. Assist the Agency in responding tobudget questions from funding stakeholders
a. Perform analysis, review, andprovide feedback on draft responses to questions from funding stakeholders
b. Perform analysis on LegislativeHouse and Senate proposed Program budgets and proviso language
c. Develop preliminary and initialfiscal year spending plans
d. Provide a high-level review eachmonth of the Spending Plan. This activity may result in interactions withAgency staff to advise on needed corrections and/or modifications toinformation contained in the Spending Plan
e. Prepare budget release amountcalculations for inclusion in quarterly OWPs
f. Meet with Agency budget staff toaddress their questions regarding quarterly OWP release calculations
g. Develop cost allocationmethodologies and formulas and advise the Agency on cost allocation decisionsrelated to Medicaid Enterprise projects. This includes preparing budgetinformation for the work activities cited above using cost allocationmethodologies, 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 andbusiness/industry work experience
b. 5+ years of professionalexperience managing highlycomplex or enterprise-wide IT projectsusing the ProjectManagement Institutes’ current Project Management Body of Knowledge
c. 3+ years of leadership experience
d. Extensive knowledge of advancedspreadsheet design, data modeling, and financial/operational analysis usingMicrosoft Excel
1. Deep understanding of complexformulas and functions
2. Understanding of reporting toolsincluding PivotTables, PivotCharts, and dashboard creation
3. Ability to develop and maintaincomplex, largescale Excel workbooks with multiple interdependencies
4. Advanced skill in creating dynamicdashboards and reports for executive-level decision-making
5. Proficiency in automatingrepetitive processes using macros and VBA to improve efficiency and accuracy
a. Abilityto translate complex data into clear, actionable insights for both technicaland non-technical stakeholders
b. Strongattention to detail with a high degree of accuracy in data handling andreporting
c. Abilityto manage multiple projects and deadlines while maintaining data integrity
d. Capabilityto train and support team members in advanced Excel techniques
e. Knowledgeand expertise in the use of Project Management methodologies and tools
f. Priorstate government accounting or leadership experience preferred
#J-18808-Ljbffr