Data Analyst Cost Allocation / Federal Programs

Job description: Data Analyst (2 positions)

Cost allocation analysts who will build the allocation models, matrices and fiscal impact projections behind the methodology and PACAP.

Location: Onsite in Baton Rouge, LA (primary), with remote availability in the continental US. Term: 12/14/2026 to 12/31/2028, full time.

Role summary

The analysts turn Louisiana Works financial, payroll and time coding data into supportable allocation statistics and models. They work under the Program Managers and alongside LW fiscal staff.

Responsibilities

• Collect and analyze LW expenditure, payroll, time coding and grant data across USDOL, VR, SNAP E&T, TANF and other federal funds.
• Document current cost pools, allocation bases, coding structures (WBS, cost centers, internal orders) and claiming flows.
• Test interim time coding controls and reconcile coded hours to charges and federal claims.
• Build allocation matrices and formulas, and calculate allocation statistics (FTEs, time study results, caseload, square footage, transaction counts, system usage).
• Build the Fiscal Impact Projection Model comparing federal and state share under the current structure, the proposed methodology and revised FFY 2028 participation rates.
• Prepare the Cost Pool Reporting and Coding Matrix showing how each pool is captured, tracked and reported in LW financial systems.
• Prepare PACAP allocation schedules and supporting documentation.
• Validate allocation calculations after the 7/1/2027 implementation and update models from federal or operational feedback.
• Support responses to federal reviewer data requests.
• Keep audit-ready workpapers and submit timesheets as required.

Mandatory qualifications (per RFR)

• Cost allocation plan generation experience.
• Experience needed to meet all deliverables, qualifications and requirements in the scope of services.
• Data analysis experience.

Strongly preferred (needed to be competitive)

• Hands-on work on state public assistance cost allocation plans or SWCAP/indirect cost rate proposals.
• Financial modeling of federal and state share under different match rates (50%, enhanced, VR, SNAP E&T, TANF).
• Knowledge of 2 CFR Part 200 cost principles and 45 CFR Part 95 Subpart E.
• Advanced Excel (complex models, Power Query, pivot tables); SQL, Power BI, Tableau or similar a plus.
• Experience extracting data from state ERP and payroll systems (for example SAP, LaGov, PeopleSoft, Workday).
• Experience with time study or random moment sampling data.
• Accounting or finance degree; CPA, CGFM or similar credential a plus.
• Additional data analysis experience beyond the scope requirement (listed as desirable in the RFR).

Team qualifications the 4 candidates must cover together

The State may reject the proposal if the team as a whole does not show these, so each resume should make clear which items that candidate covers.