What are the responsibilities and job description for the Data Analyst Cost Allocation / Federal Programs position at Triwave Solutions Inc?
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.
Requirement | What we need from candidates |
|---|---|
At least one licensed CPA with governmental cost allocation and federal claiming experience | CPA license state, number and expiration |
Authored or materially revised at least 3 PACAPs in the past 5 years | List of each PACAP: state, agency, year, candidate's role |
Supported states in federal review, negotiation or approval (USDOL, DHHS, USDOE, FNS) | Agency, federal reviewer, outcome, dates |
Expertise: 50% and enhanced match claiming, SNAP E&T, TANF, integrated workforce/VR/E&T systems, 2 CFR 200, 45 CFR 95, state-funded programs in PACAPs | Specific project bullets showing each area |
Key personnel roles filled: Project Lead, Senior Cost Allocation Specialist, Federal Claiming SME | Which role the candidate is proposed for |
At least 2 state references for similar cost allocation work in the past 5 years | Name, title, agency, address, phone, email |
Percentage of time each key person will dedicate | Confirm full-time availability (100%) or state the percentage |