Data Analyst & Data Program Manager/Specialist

The Office of Technology Services (OTS) was established as a means of recognizing cost savings through the consolidation of State IT assets and resources. The creation of OTS consolidated a wide variety of existing hardware platforms, operating systems, database management systems, networks, third party software, and custom applications. OTS leads the State’s technology procurement process in order to standardize technology over the entire organization, seek efficiencies of operations, maintenance, and scalability of new products introduced to the OTS suite of services which can eventually be offered to all in-scope agencies. The State intends to secure temporary IT personnel for job title(s) listed below: IT Staffing Resource Area: 2 Data Analysts Number of resources: 2 IT Staffing Resource Area: 2 Data Program Manager/Specialist Number of resources: 2 The scope of the proposed services will include the following: This proposal by Louisiana Works is to obtain staff to complete cost allocation, financial modeling, documentation, implementation support, and federal claiming support for all United States Department of Labor (USDOL) grants, all Vocational Rehabilitation (VR) grants, the SNAP Employment and Training (SNAP E&T) grant, TANF grant, and any other federal funds awarded to Louisiana Works in their entirety. The resources should be available to work both onsite and remotely. ● Background and Purpose Louisiana Works administers and supports multiple federally funded workforce, employment and training, vocational rehabilitation, and assistance programs. These programs include all applicable USDOL grants, all VR grants, the SNAP E&T grant, TANF grant, and any other federal funds awarded to Louisiana Works in their entirety. Administrative functions, including program operations, information technology, policy development, fiscal oversight, and management support, may be shared across these funding sources. Personnel and shared administrative resources may perform work that materially benefits more than one covered grant program. Louisiana Works requires a compliant, documented, and sustainable cost allocation methodology to support integrated operations, ensure costs are charged to benefiting programs, and support accurate federal claiming and financial reporting. Louisiana Works may use prospective time coding and other cost-capture controls.to ensure personnel and other shared costs are charged to benefiting programs. The Contractor shall

assess these controls and recommend improvements needed to support compliant federal claiming under the covered grants. Differences among federal participation, reimbursement, maintenance-of-effort, and program-specific requirements increase the importance of accurate cost allocation, sound documentation, and timely financial reporting for all covered grant funds. Accordingly, Louisiana Works must establish a defensible administrative cost allocation methodology that supports integrated operations while ensuring compliance with federal and state cost principles and claiming requirements. The objective of this engagement is to establish a sustainable administrative cost allocation structure capable of supporting integrated program and administrative operations and maintaining compliance with federal claiming requirements as program structures evolve. The services described in this Scope of Work require the application of professional accounting judgement, including the interpretation and application of federal and state cost principles (2 CFR 200), development of cost allocation methodologies, and preparation of financial documentation supporting federal claiming. These services constitute professional accounting services involving the development, application, and documentation of cost allocation methodologies and financial reporting structures required for federal claiming. This engagement covers administrative cost allocation and related federal grant claiming for all USDOL grants, all VR grants, the SNAP E&T grant, TANF grant, and any other federal funds awarded to Louisiana Works in their entirety. The Contractor shall evaluate direct and indirect costs, shared services, program operations, information technology, fiscal functions, policy and oversight, management, and other applicable administrative functions that benefit one or more covered grants. Target implementation dates of July 1, 2027, and October 1, 2027, are dependent upon timely contract execution and are intended to reflect Louisiana Works’ operational objectives. The Contractor shall develop a timeline based on the actual contract execution date to support these targets to the extent practicable.Regulatory Framework The Contractor shall apply professional accounting standards and judgment in the development of cost allocation methodologies and support financial documentation for federal claiming. The Contractor shall ensure that all analysis, methodologies, and recommendations are consistent with, at minimum:  2 CFR Part 200 (Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards)  45 CFR Part 95 (Subpart E –Cost Allocation Plans) 11  USDOL, RSA, FNS, and other applicable federal agencies administrative claiming guidance  Applicable USDOL, Rehabilitation Services Administration (RSA), FNS, TANF, and other program-specific grant requirements The Contractor shall explicitly identify how proposed methodologies align with these requirements. The Contractor shall cite specific regulatory authority supporting each proposed cost pool, allocation base, and methodology.

The Contractor shall identify any areas where Louisiana Works’s current practices or interim controls may not fully align with federal requirements and provide recommendations to achieve compliance. All recommendations shall be supported by documentation sufficient to withstand federal review. ● Scope of Services Project Governance and Coordination The Contractor shall coordinate regularly with Louisiana Works Fiscal leadership and designated program staff throughout the engagement. The work shall be performed collaboratively with Louisiana Works personnel through structured working sessions designed to review findings, confirm operational assumptions, and ensure that development of the cost allocation methodology reflects the operational realities of USDOL, VR, SNAP E&T, TANF, and any other federal program administration. The Contractor shall not develop methodologies in isolation from Louisiana Works operational and fiscal input. The Contractor shall 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. Louisiana Works fiscal and program staff shall participate in working sessions necessary to validate operational assumptions and confirm allocation methodologies. A. Comprehensive Assessment of Current Administrative Cost Structure The Contractor shall: 1. Review existing funding structures for USDOL, VR, SNAP E&T, TANF and any other federal fund administrative functions. 2. Analyze the current allocation of personnel, IT, policy, fiscal, and management costs. 3. Evaluate the interim time coding controls implemented by Louisiana Works. 12 4. Identify areas of potential noncompliance, unsupported allocation methodology, or misalignment with federal cost principles. 5. Provide a written assessment identifying compliance risks and required corrective actions. 6. 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. Deliverable: Written Assessment Report identifying current state, compliance risks, and recommended corrective actions, to be submitted within thirty (30) business days of contract execution. Louisiana Works shall: 1. Provide all requested documentation, including written information on funding structures, current allocation methodologies, and time coding controls within five (5) business days of contract execution. The Report will be based on the available material reviewed as part of the current state analysis. 2. Review and provide written feedback of the draft Written Assessment Report within five (5) business days of receipt. Delays in provision of required documentation or feedback may impact the Contractor’s ability to meet established timelines. B. Development of Administrative Cost Allocation Methodology The Contractor shall 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. The Contractor shall: 1. Identify shared administrative cost pools across USDOL, VR, SNAP E&T, TANF, and any other federal programs. 2. Define appropriate and supportable allocation bases for each cost pool. 3. Develop allocation formulas and distribution methodologies that are fully supported and consistent with federal and state cost principles. 4. 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

Requirements

Provide financial modeling quantifying projected federal and state share impacts under both current and proposed allocation methodologies. 6. 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. 7. The methodology shall include recommended internal control procedures and documentation requirements to ensure ongoing compliance and audit support, and consistency in application of methodology. 8. 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. The Contractor is not responsible for configuring Louisiana Works systems but shall provide sufficient detail to enable Louisiana Works to implement the methodology within existing systems. Deliverables: 1. Draft Administrative Cost Allocation Methodology Document, including detailed cost pools, allocation bases, and supporting justification 2. Allocation Matrices and Formulas 3. Financial Impact Analysis 4. Cost Pool Reporting and Coding Matrix identifying how each cost pool and allocation base will be tracked and reported Louisiana Works shall: 1. Identify and provide documentation of existing cost pools within five (5) business days of the contract execution. 2. Provide current financial modeling quantifying projected federal and state share within ten (10) business days of the contract execution. 3. Review and provide written feedback on submitted deliverable(s) within five (5) business days of receipt of the deliverable(s). 4. Deliverables above will be based on documentation provided by Louisiana Works as part of the comprehensive assessment. All required documentation shall be provided within five (5) business days of contract execution. Delays in providing required documentation or feedback may impact the Contractor’s ability to meet established timelines. C. Public Assistance Cost Allocation Documentation Preparation and Submission Support Based on the cost allocation methodology developed under this engagement, the Contractor shall determine and document the appropriate public assistance cost allocation plan structure and supporting documentation needed for the covered grants. 14 Preparation of final submission-ready documentation shall occur after Louisiana Works review and formal approval of the proposed allocation methodology. The Contractor shall: 1. Determine whether revisions to the existing cost allocation documentation are required. 2. Determine whether new or amended grant-specific cost allocation documentation is required for any covered funding source. 3. Prepare complete Public Assistance Cost Allocation Plan narratives, schedules, and allocation documentation necessary to support federal submission. 4. Assist Louisiana Works in developing and providing responses to federal questions associated with the methodology and Public Assistance Cost Allocation Plan submission. Deliverables: 1. Draft Public Assistance Cost Allocation Plan Submission Package 2. Final Public Assistance Cost Allocation Plan Submission Package 3. Supporting Public Assistance Cost Allocation Documentation and Allocation Schedules Public Assistance Cost Allocation Plan development and submission support is considered a core component of this engagement and is included within the scope of services. Additional Federal Review Support The Contractor shall 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. This includes preparing written responses to federal inquiries, participating in meetings or technical discussions with federal reviewers as requested by Louisiana Works, and revising documentation as necessary to address federal feedback. Support shall continue through resolution of federal review comments associated with the methodology and documentation developed under this Scope of Work.

Implementation and Operationalization The Contractor shall: 1. Develop a detailed implementation roadmap to support implementation of the methodology aligned with Louisiana Works’ target date of July 1, 2027. 2. Provide specific guidance for aligning administrative allocation effective July 1, 2027, including interim steps necessary prior to full implementation. 15 3. Provide comprehensive documentation sufficient for Louisiana Works to maintain, apply, and update the methodology internally. 4. Identify any required changes to time reporting, coding structures, or financial system configuration necessary to support the approved allocation methodology. The Contractor is not responsible for configuring Louisiana Works financial systems but shall provide sufficient technical guidance to enable Louisiana Works to implement the methodology within existing systems. Deliverables: 1. Implementation Plan outlining timeline, key activities, responsible parties, and dependencies required to operationalize methodology 2. Methodology Documentation for Louisiana Works Operational Use, including procedures for ongoing application, monitoring, and updates to the methodology 3. Operational Transition Guidance for July 1, 2027 alignment Louisiana Works shall: 1. Provide any existing written procedures relevant to administrative cost allocation within five (5) business days of contract execution. 2. Review and provide written feedback on submitted deliverable(s) within five (5) business days of receipt. Delays in providing required documentation or feedback may impact the Contractor’s ability to meet established timelines. E. Federal Claiming Optimization and Fiscal Impact Analysis The Contractor shall evaluate and quantify opportunities to maximize allowable federal reimbursement consistent with federal and state cost principles and claiming requirements. 1. Analyze the financial impact of the anticipated change in applicable federal participation and reimbursement rates beginning Federal Fiscal Year 2028. 2. 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. 3. 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 16 4. Develop detailed fiscal modeling to project federal and state share impacts under:  Current allocation structure  Proposed allocation methodology  Revised federal participation rates 5. 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. Deliverable: 1. Federal Claiming Optimization Memorandum documenting identified opportunities, supporting analysis, and recommended actions 2. Fiscal Impact Projection Model quantifying federal and state share impacts under current and proposed methodologies 3. Executive Summary for Louisiana Works Leadership Louisiana Works shall: 1. Review and provide written feedback on submitted deliverable(s) within five (5) business days of receipt. ● Period of Performance The period of performance for this contract shall begin on the date of contract execution and continue through December 31, 2028. Activities under this contract shall be completed within this period of performance. The Contractor shall adhere to the timeline and milestones outlined in this Scope of Work. ● Deliverables and Milestones Deliverable timelines tied to calendar dates reflect Louisiana Works’s target operational milestones. Actual deliverable due dates shall be adjusted based on the contract execution date while maintaining the sequence and intent of the phases described.