Data Analyst Federal Grants Cost Allocation (Onsite)
About The Position
The Data Analyst will support a Louisiana state government engagement involving federally funded workforce, vocational rehabilitation, employment and training, and assistance programs. The role focuses on assessing, developing, modeling, documenting, implementing, and refining administrative cost allocation methodologies for programs funded through USDOL, Vocational Rehabilitation, SNAP E&T, TANF, and other federal funding sources. The analyst will use data analysis and financial modeling to support governmental funding and cost allocation work, including Public Assistance Cost Allocation Plans (PACAPs), federal claiming, and financial reporting. The resource will contribute to current-state assessments and compliance-risk analysis; allocation methodologies, matrices, and formulas; financial impact analysis and projection models; cost-pool reporting and coding matrices; PACAP documentation; federal claiming optimization analysis; implementation documentation; and post-implementation validation and federal review support. The role collaborates with Louisiana Works fiscal, program, and management personnel to validate assumptions and analytical conclusions.
Requirements
- 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.
Nice To Haves
- Public Assistance Cost Allocation Plan (PACAP) development or revision.
- Federal grant claiming and administrative cost allocation experience.
- 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.
Responsibilities
- Analyze 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 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Education Level
No Education Listed
