Functional Data Specialist

MANAGEMENT OPERATIONS ANALYST II – 25542

Salary:
Anticipated Starting Salary $6,589/monthly;
Full Range $6,589 – $9,541/monthly. Job Type: Salaried. Category:
Full Time. County:
Cook.

The Department of Central Management Services (CMS) is seeking to hire qualified candidates for a Functional Data Specialist role in a major digital transformation project. This position will lead the planning, execution, and validation of data migration from a legacy mainframe system to SAP ERP. Following successful implementation, the role will expand to support data conversion and integration across CMS’s legacy systems.

The ideal candidate brings hands‑on ETL experience, strong SQL skill, and deep understanding of large‑scale enterprise data migration.

• Serve as the Functional Data Specialist for CMS, performing complex studies and independent analysis using a variety of data analysis techniques.
• Oversee CMS’s data conversion and stabilization activities, ensuring migration strategies are finalized, data loads are validated, and processes are completed to deliver accurate data.
• Develop and implement data validation and quality assurance processes to ensure data integrity throughout the migration lifecycle.
• Coordinate and participate in testing and reconciliation activities to ensure the accuracy and completeness of converted data.
• Assess post‑transition system needs and develop standardized frameworks for enterprise‑wide data migration.
• Provide ongoing thought leadership in continuous data readiness and long‑term system alignment across the enterprise.
• Perform other duties as required or assigned that are reasonably within the scope of the duties enumerated above.

• Four (4) years of college education supplemented by a master’s degree in business or public administration, with coursework in areas such as economics theory, accounting and finance, organizational theory, and operations research.
• Three (3) years progressively responsible professional experience in management operations analysis.

• Three (3) years of professional experience executing data transformation efforts, including consolidation of data from multiple sources or large‑scale data conversion and system implementation projects.
• Extensive knowledge of relational database structures and various data integration methods, including flat files, APIs, and other database connections.
• Extensive knowledge of data transformation processes, data mapping, data cleansing, and data reconciliation techniques, particularly in enterprise HR systems.
• Extensive knowledge of ERP data migration, including finalizing migration strategies, validating data loads, and overseeing post‑migration stabilization efforts.
• Experience applying data governance, quality assurance, and reconciliation processes to ensure accurate and complete data delivery into ERP systems such as SAP.
• Ability to coordinate and execute data testing, validation, and reconciliation activities within ERP environments, including participation in test planning, defect tracking, and use of data validation tools.
• Ability to collaborate with technical teams, business analysts, and end‑users to identify and resolve data discrepancies.

• Completion of a background check and self‑disclosure of criminal history.
• Overtime may be required, including evenings, weekends, and unscheduled shifts.
• Ability to travel, including overnight stays, and possession of a valid driver’s license.
• Competence in using agency technology such as mobile phones and laptops in accordance with security policies.
• Commitment to attend seminars, conferences, and training to stay current on relevant methods and tools.

Central Management Services (CMS) is the operational engine behind more than 60 state agencies, universities, boards, and commissions. CMS supports the State by delivering innovative, responsive, and effective services, including human resources facilitation, benefits programs, property and facilities management, diversity initiatives, joint purchasing support, vehicle oversight, surplus property programs, electronic…