Data Analyst & Data Program Manager/Specialist

NOVALINK SOLUTIONS LLC is providing IT staffing support for Louisiana Works and the Louisiana Office of Technology Services. The Data Analyst and Data Program Manager/Specialist resources will develop compliant administrative cost allocation methodologies, financial models, documentation, implementation guidance, and federal claiming support for federally funded workforce, employment, training, vocational rehabilitation, SNAP E&T, and TANF programs.

Responsibilities:

• Coordinate regularly with Louisiana Works Fiscal leadership and designated program staff throughout the engagement
• Designate a project lead responsible for coordinating project activities, facilitating working sessions with Louisiana Works staff, and maintaining a project timeline aligned with the milestones identified in this Scope of Work and ensuring adherence to those timelines
• Review existing funding structures for USDOL, VR, SNAP E&T, TANF and any other federal fund administrative functions
• Analyze the current allocation of personnel, IT, policy, fiscal, and management costs
• Evaluate the interim time coding controls implemented by Louisiana Works
• Identify areas of potential noncompliance, unsupported allocation methodology, or misalignment with federal cost principles
• Provide a written assessment identifying compliance risks and required corrective actions
• Document current cost pools, allocation bases, coding structures (including WBS, cost centers, internal orders), and administrative claiming flows for each affected program, including identification of any undocumented allocation assumptions currently relied upon for federal claiming
• Apply professional accounting principles to develop a compliant and fully supportable administrative cost allocation methodology in accordance with federal and state cost principles and reporting requirements
• Identify shared administrative cost pools across USDOL, VR, SNAP E&T, TANF, and any other federal programs
• Define appropriate and supportable allocation bases for each cost pool
• Develop allocation formulas and distribution methodologies that are fully supported and consistent with federal and state cost principles
• Address treatment of: Eligibility operations; Integrated IT systems and system development costs; Policy and program oversight; Fiscal and administrative support functions; Management and supervisory functions
• Provide financial modeling quantifying projected federal and state share impacts under both current and proposed allocation methodologies
• For each cost pool and allocation base, the Contractor shall provide written justification demonstrating that the allocation method is necessary, reasonable, allocable, and consistently applied in accordance with federal and state cost principles
• The methodology shall include recommended internal control procedures and documentation requirements to ensure ongoing compliance and audit support, and consistency in application of methodology
• Define, for each cost pool and allocation base, the reporting and coding structure necessary to operationalize the methodology, including how costs will be captured, tracked, and reported within Louisiana Works financial systems and federal claiming processes
• Determine whether revisions to the existing cost allocation documentation are required
• Determine whether new or amended grant-specific cost allocation documentation is required for any covered funding source
• Prepare complete Public Assistance Cost Allocation Plan narratives, schedules, and allocation documentation necessary to support federal submission
• Assist Louisiana Works in developing and providing responses to federal questions associated with the methodology and Public Assistance Cost Allocation Plan submission
• Provide technical and accounting support to Louisiana Works during the federal review and approval process associated with the cost allocation methodology and public assistance cost allocation documentation developed under this engagement
• Develop a detailed implementation roadmap to support implementation of the methodology aligned with Louisiana Works’ target date of July 1, 2027
• Provide specific guidance for aligning administrative allocation effective July 1, 2027, including interim steps necessary prior to full implementation
• Provide comprehensive documentation sufficient for Louisiana Works to maintain, apply, and update the methodology internally
• Identify any required changes to time reporting, coding structures, or financial system configuration necessary to support the approved allocation methodology
• Evaluate and quantify opportunities to maximize allowable federal reimbursement consistent with federal and state cost principles and claiming requirements
• Analyze the financial impact of the anticipated change in applicable federal participation and reimbursement rates beginning Federal Fiscal Year 2028
• Evaluate the current and proposed allocation methodology to ensure all allowable administrative costs benefiting USDOL, VR, SNAP E&T, TANF, and any other federal programs are properly identified, supported, and claimed
• Identify and document opportunities to maximize allowable federal reimbursement in accordance with: 2 CFR Part 200 cost principles; 45 CFR Part 95 Subpart E Public Assistance Cost Allocation Plan requirements; USDOL, RSA, FNS, and other applicable federal agencies administrative claiming guidance
• Develop detailed fiscal modeling to project federal and state share impacts under: Current allocation structure; Proposed allocation methodology; Revised federal participation rates
• Based on materials reviewed and analyzed in Sections A through E of the Scope of Services, provide recommendations to stabilize and protect federal revenue streams associated with integrated program and administrative operations and quantify the estimated annual fiscal impact of recommended allocation changes under applicable federal participation and reimbursement rates