Data Analyst – Federal Grants / Cost Allocation (Onsite)

Job Title: Data Analyst – Federal Grants / Cost Allocation

Location: Baton Rouge, LA (Onsite)

Duration: 2+ Years

Position Overview

We are seeking an experienced Data Analyst with strong governmental cost allocation and federal grant claiming experience to support a major Louisiana state government engagement involving federally funded workforce, vocational rehabilitation, employment and training, and assistance programs.

The Data Analyst will support the assessment, development, modeling, documentation, implementation, and ongoing refinement of administrative cost allocation methodologies supporting programs funded through U.S. Department of Labor (USDOL), Vocational Rehabilitation (VR), SNAP Employment & Training (SNAP E&T), TANF, and other federal funding sources.

The ideal candidate will have hands-on experience developing or materially supporting Public Assistance Cost Allocation Plans (PACAPs) and applying data analysis and financial modeling techniques to complex governmental funding and cost allocation environments.

Key Responsibilities

• Analyze current administrative cost structures, funding sources, cost pools, allocation methodologies, and cost-capture processes.
• Analyze personnel, IT, policy, fiscal, management, and other shared administrative costs across federally funded programs.
• Evaluate existing time-coding, cost-capture, WBS, cost center, internal order, and related financial structures.
• Identify unsupported allocation methodologies, compliance risks, and opportunities for improvement.
• Develop and analyze cost pools and appropriate allocation bases.
• Develop allocation formulas, distribution methodologies, allocation matrices, and supporting analyses.
• Perform financial modeling to quantify federal and state financial impacts under current and proposed allocation methodologies.
• Analyze allowable administrative costs and support federal claiming optimization.
• Support development and documentation of Public Assistance Cost Allocation Plans and associated schedules.
• Prepare data-driven analyses and documentation supporting federal claiming and financial reporting.
• Develop reporting and coding matrices showing how costs will be captured, tracked, and reported.
• Support implementation planning and operationalization of approved cost allocation methodologies.
• Validate allocation calculations following implementation.
• Assist with responses to federal reviewer questions and requests for supporting analysis.
• Prepare reports, analytical models, documentation, and executive-level summaries.
• Collaborate with Louisiana Works fiscal, program, and management personnel to validate assumptions and analytical conclusions.

Required Qualifications

• Demonstrated cost allocation plan generation experience – mandatory.
• Strong data analysis experience – mandatory.
• Experience performing analysis related to governmental, public-sector, federal grant, or program funding environments.
• Experience analyzing complex financial, operational, or administrative datasets.
• Experience developing allocation methodologies, cost pools, allocation bases, or financial models.
• Ability to translate complex analytical findings into clear documentation and recommendations.
• Experience preparing detailed supporting documentation suitable for governmental or regulatory review.
• Strong written and verbal communication skills.
• Ability to work collaboratively with fiscal, program, technical, and management stakeholders.

Highly Preferred Experience

• Public Assistance Cost Allocation Plan (PACAP) development or revision.
• Federal grant claiming and administrative cost allocation.
• Experience with 2 CFR Part 200.
• Experience with 45 CFR Part 95, Subpart E.
• Experience with USDOL, RSA, FNS, TANF, SNAP E&T, or similar federal funding programs.
• Experience with integrated workforce, vocational rehabilitation, employment/training, or public assistance programs.
• Experience analyzing federal participation, reimbursement, or matching structures.
• Experience with financial modeling involving federal and state funding shares.
• Experience with WBS, cost centers, internal orders, time coding, or similar governmental financial structures.

Key Deliverables Supported

The resource will contribute to deliverables including:

• Current-state assessment and compliance-risk analysis
• Administrative cost allocation methodology
• Allocation matrices and formulas
• Financial impact analysis
• Cost pool reporting and coding matrix
• Public Assistance Cost Allocation Plan documentation
• Federal claiming optimization analysis
• Fiscal impact projection models
• Implementation and operationalization documentation
• Post-implementation allocation validation and federal review support