Data Analyst

Project Overview

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

Duties/Responsibilities

Analyze how personnel, IT, policy, fiscal and management costs are currently allocated.

Document current cost pools, allocation bases, coding structures (WBS, cost centers, internal orders) and claiming flows for each program.

Find undocumented allocation assumptions that current federal claims rely on.

Build allocation formulas, distribution methods and allocation matrices.

Create the Cost Pool Reporting and Coding Matrix, showing how each pool and base will be captured, tracked and reported in Louisiana Works' financial systems.

Prepare allocation schedules and supporting documents for the PACAP package.

Build the Fiscal Impact Projection Model comparing federal and state shares under the current structure, the proposed methodology, and the revised federal participation rates starting in Federal Fiscal Year 2028.

Quantify the financial effect of the federal rate change starting in FFY 2028.

Find allowable administrative costs that aren't currently being claimed, and estimate the annual fiscal impact of the recommended changes.

Validate allocation calculations after implementation.

Adjust models and documents based on operational or federal feedback.

Keep detailed time records, since monthly invoices for ongoing support must itemize the work performed and the hours used.

Requirements

Education

Bachelor?s degree in Computer Science, Computer Engineering, Data Science, Management Information Systems, Information Technology, or related field.

Required Experience

Experience with cost allocation plan generation.

Experience to meet all deliverables, qualifications and reequipments mentioned in the scope of services.

Data analysis experience.

Preferred Experience

Additional data analysis experience beyond what is required for this Scope of Services is desirable.

Benefits