Data Migration & ETL Specialist — SaaS Platforms

Public Consulting Group; United States; Hybrid; USD 75,000 - 125,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

401(k)

PTO

Parental leave

Bereavement leave

Job summary

Public Consulting Group (PCG) is seeking a Data Conversion Specialist to lead migration of legacy data into a modern SaaS platform. This role blends technical data work with client interactions to map data structures to the new system.

You will collaborate with project managers, developers, and QA to ensure accurate data mappings, while following data governance standards and best practices. Hybrid work with travel is required.

Qualifications

• 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 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.
• Strong Microsoft Office applications skills, especially data analytics (i.e. ACCESS, SQL, SPSS)
• Ability to use sound judgment, attention to detail, and work with large data sets.

Responsibilities

• Data Analysis & Conversion: Assess legacy data sources and design conversion strategies for SaaS implementation.
• Perform data ETL using appropriate tools and validate data integrity post-migration.
• Secure handling of client data, including PII.

Skills

Data analytics

Attention to detail

Large data handling

Communication

Education

Bachelor's degree

Tools

ETL tools

SQL/MySQL

XML

DataBricks

Excel

Stored procedures

Job description

Public Consulting Group (PCG) is seeking a Data Conversion Specialist to lead migration of legacy data into a modern SaaS platform. This role blends technical data work with client interactions to map data structures to the new system.

You will collaborate with project managers, developers, and QA to ensure accurate data mappings, while following data governance standards and best practices. Hybrid work with travel is required.