Data Analyst

TRIWAVE Solutions INC; Baton Rouge (LA); Hybrid; USD 70,000 - 110,000; Full time

Job summary

TRIWAVE Solutions INC is seeking two Data Analysts onsite in Baton Rouge, LA, with remote availability in the continental US. You will turn financial and time coding data into allocation statistics, building models and projections behind PACAP and related methodologies.

Responsibilities include collecting and reconciling data across multiple federal funds, documenting cost pools, and developing allocation matrices. Strong Excel, SQL, and BI skills are required for model building and reporting.

Qualifications

• Experience generating cost allocation plans and related deliverables.
• Data analysis experience across financial data sources.
• Strong understanding of cost pools, allocation bases and coding structures.

Responsibilities

• Collect and analyze expenditure, payroll, time coding and grant data across federal funds.
• Document cost pools, allocation bases, coding structures and claiming flows.
• Test time coding controls and reconcile hours to charges and claims.
• Build allocation matrices and formulas, and calculate allocation statistics (e.g., FTEs, caseload).
• Develop the Fiscal Impact Projection Model comparing federal and state shares.
• Prepare Cost Pool Reporting and Coding Matrix in LW financial systems.
• Prepare PACAP allocation schedules and supporting documentation.
• Validate allocation calculations after implementation and update models from feedback.
• Support responses to federal reviewer data requests.
• Maintain audit-ready workpapers and submit timesheets.

Skills

Data analysis

Cost allocation

Advanced Excel

SQL

Power BI

Tableau

Power Query

Education

Accounting or finance degree

CPA / CGFM or similar credential

Tools

Excel

SQL

Power BI

Tableau

Job description

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

• 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).