Remote Data Migration & ETL Specialist - SaaS Transformation

Public Consulting Group; Springfield (IL); Hybrid; USD 75,000 - 125,000; Full time

Benefits offered by this job

Hybrid work environment

Travel opportunities

Job summary

Public Consulting Group is seeking a Data Conversion Specialist to lead legacy data migration into a modern SaaS platform. You will design conversion strategies, perform ETL, and engage with clients to map data and ensure accuracy.

Strong data governance and documentation experience are essential for this hybrid role with travel. The position emphasizes collaboration with PMs, developers, and QA, and requires experience with data migration, ETL workflows, and regulatory knowledge.

Qualifications

• Bachelor’s degree or 5 years’ related experience required.
• 5+ years of hands‑on experience with data conversion, data migration, and ETL processes, including extracting data from legacy systems, transforming data to meet target model requirements, and loading data into new platforms.
• 5+ years of experience designing, building, and executing ETL or data integration workflows, using custom scripts, integration tools, or database‑driven approaches.
• Ability to understand both the service delivery system for programs which are administered by states and monitored by federal regulators.
• Ability to understand and be an expert in complex federal regulations and requirements.
• Strong Microsoft Office applications skills, especially data analytics (i.e. ACCESS, SQL, SPSS)
• Ability to use sound judgment in completing tasks and to seek guidance when needed.
• Attention to detail and ability to work with large data sets with accurate results.

Responsibilities

• Assess legacy data sources and design conversion strategies for SaaS implementation.
• Perform data extraction, transformation, and loading (ETL) using appropriate tools.
• Validate data integrity and accuracy post-migration.
• Secure handling of client data, e.g. managing Personal Identifiable Information (PII).
• Lead client meetings to gather requirements, clarify business processes, and identify data dependencies.
• Translate business workflows into data mapping for the new platform.
• Serve as a trusted advisor, guiding clients through conversion best practices.
• Work closely with project managers, developers, and QA teams to ensure seamless integration.
• Document conversion processes and provide training or support as needed.
• Create and implement Data Management strategies, aligned with project and organizational objectives.
• Refine, maintain, and update data management methodology documents and supporting artifacts, ensuring they remain current, consistent, and reusable across projects.
• Contribute to the development of data management training materials and knowledge transfer documentation for internal teams and client stakeholders.
• Support and execute data governance use cases, including documentation of standards, processes, and controls related to data quality, lineage, and stewardship.

Skills

ETL processes

Data migration

SQL

Python

Data analytics

Education

Bachelor’s degree

5+ years’ related experience

Tools

ETL tools

SQL/MySQL

XML

Data Bricks

Excel

Stored procedures

Job description

Public Consulting Group is seeking a Data Conversion Specialist to lead legacy data migration into a modern SaaS platform. You will design conversion strategies, perform ETL, and engage with clients to map data and ensure accuracy.

Strong data governance and documentation experience are essential for this hybrid role with travel. The position emphasizes collaboration with PMs, developers, and QA, and requires experience with data migration, ETL workflows, and regulatory knowledge.