Data Analyst

Talentify; Baton Rouge (LA); On-site; USD 60,000 - 90,000; Full time

Job summary

Louisiana Works is seeking experienced Data Analysts with federal grant cost allocation and financial analysis experience to support the development, documentation, analysis, and implementation of administrative cost allocation methodologies across federally funded programs. The role covers USDOL grants, VR, SNAP E&T, TANF, and other federal funds.

The candidate will analyze costs across programs, review funding structures, develop allocation plans, model federal/state shares, and ensure

Qualifications

• Cost allocation plan generation experience.
• Data analysis experience.
• Additional data analysis experience beyond minimum is desirable.

Responsibilities

• Analyze financial, administrative, personnel, IT, policy, fiscal, and management costs across federally funded programs.
• Review funding structures and determine how direct, indirect, and shared administrative costs are allocated.
• Analyse cost pools, allocation bases, WBS structures, cost centers, internal orders, time coding, and administrative claiming flows.
• Support development and documentation of compliant cost allocation plans and methodologies.
• Perform data analysis supporting federal grant claiming and financial reporting.
• Develop and validate allocation matrices, formulas, cost pool calculations, and financial models.
• Analyze current vs proposed allocation methodologies and quantify financial impact.
• Model projected federal and state share impacts under different allocation approaches and reimbursement rates.
• Identify opportunities to properly identify and claim allowable administrative costs.
• Assist in identifying compliance risks, unsupported allocation practices, structural gaps, and corrective actions.
• Support PACAP narratives, schedules, allocation documentation, and supporting financial data.
• Validate allocation calculations during implementation and post-implementation.
• Maintain documentation supporting federal review and audit requirements.
• Participate in working sessions with Louisiana Works fiscal, program, and administrative stakeholders.
• Support responses to federal inquiries and revisions from federal review.
• Apply 2 CFR Part 200 and 45 CFR Part 95 Subpart E, and related USDOL, RSA, FNS, TANF guidance.

Skills

Cost allocation

Data analysis

Federal grants knowledge

Job description

Louisiana Works is seeking experienced Data Analysts with federal grant cost allocation and financial analysis experience to support the development, documentation, analysis, and implementation of administrative cost allocation methodologies across federally funded workforce and assistance programs. Programs include USDOL grants, Vocational Rehabilitation (VR), SNAP Employment & Training (SNAP E&T), TANF, and other federal funds. RFR SR-5279587

Key Responsibilities

• Analyze financial, administrative, personnel, IT, policy, fiscal, and management costs across multiple federally funded programs.
• Review existing funding structures and determine how direct, indirect, and shared administrative costs are currently allocated.
• Analyse existing cost pools, allocation bases, WBS structures, cost centers, internal orders, time coding, and administrative claiming flows.
• Support the development and documentation of compliant cost allocation plans and methodologies.
• Perform data analysis supporting federal grant claiming and financial reporting.
• Develop and validate allocation matrices, formulas, cost pool calculations, and financial models.
• Analyze current versus proposed allocation methodologies and quantify their financial impact.
• Model projected federal and state share impacts under different allocation approaches and reimbursement rates.
• Analyze opportunities to properly identify and claim allowable administrative costs.
• Assist in identifying compliance risks, unsupported allocation practices, structural gaps, and corrective actions.
• Support preparation of Public Assistance Cost Allocation Plan (PACAP) narratives, schedules, allocation documentation, and supporting financial data.
• Validate allocation calculations during implementation and post-implementation.
• Maintain documentation capable of supporting federal review and audit requirements.
• Participate in working sessions with Louisiana Works fiscal, program, and administrative stakeholders.
• Support responses to federal inquiries and revisions resulting from federal review.
• Apply relevant requirements including 2 CFR Part 200 and 45 CFR Part 95 Subpart E, along with applicable USDOL, RSA, FNS, TANF, and other federal program guidance. RFR SR-5279587

Mandatory Experience

The RFR explicitly states that Data Analyst candidates must have:

• Cost allocation plan generation experience
• Experience sufficient to perform the deliverables and requirements contained in the Scope of Services
• Data analysis experience

Additional data analysis experience beyond the project's minimum requirements is desirable.

Strong Candidate Profile

For recruiting purposes, I would target candidates with backgrounds such as Government Cost Allocation Analyst, Federal Grants Analyst, Financial Data Analyst, Grant Financial Analyst, Cost Allocation Consultant, Federal Claiming Analyst, PACAP Analyst, Government Financial Analyst, or Public Assistance Cost Allocation Analyst.

The strongest candidates will combine data/financial analysis + government grants + cost allocation plan development + federal claiming rather than being general SQL/BI/Data Analysts.