Cost Allocation & Financial Data Analyst (Baton Rouge)
iVoyantPosition Overview: We are seeking a Data Analyst with experience in cost allocation, federal grant claiming, financial analysis, and data analysis to support Louisiana Works' federally funded programs.
The resource will support the development, analysis, documentation, and implementation of administrative cost allocation methodologies covering USDOL grants, Vocational Rehabilitation (VR) grants,
...
SNAP Employment & Training (SNAP E&T), TANF, and other federal funding programs.
This position requires cost allocation plan experience in addition to traditional data analysis experience. Candidates with only general SQL, Power BI, Python, or reporting experience without cost allocation/federal grant experience will not meet the requirement.
Key Responsibilities:
• Analyze current administrative cost structures, funding sources, cost pools, allocation bases, and cost-coding processes.
• Support the development and documentation of cost allocation methodologies for federally funded programs.
• Develop and maintain allocation matrices, formulas, financial models, and data analysis supporting federal and state cost allocation.
• Analyze personnel, IT, fiscal, policy, management, and shared administrative costs and determine appropriate allocation approaches.
• Support analysis of current versus proposed allocation methodologies and their impact on federal and state funding.
• Support preparation of Public Assistance Cost Allocation Plan (PACAP) documentation, schedules, and supporting analysis.
• Analyze timecoding, cost-capture, reporting, and financial system requirements needed to implement the approved methodology.
• Support federal claiming optimization and identify opportunities to maximize allowable federal reimbursement while maintaining compliance.
• Prepare analytical reports, documentation, and supporting materials for Louisiana W