Data Analyst & Data Program Manager/Specialist

LW Federally Funded Programs 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 AnalystsIT Staffing Resource Area: 2 Data Program Manager/Specialist 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 claiming requirements as program structures evolve. 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.