Senior Data Conversion & ETL Specialist (Public Sector)

LE04 Public Consulting Group LLC (TC); Town of Texas (WI); Hybrid; USD 75,000 - 125,000; Full time

Benefits offered by this job

Medical and dental care benefits

401k

PTO

Parental leave

Bereavement leave

Job summary

Public Consulting Group LLC (PCG) is seeking a data integration & migration professional to lead conversion efforts for SaaS implementations. You will assess legacy data, design ETL strategies, and ensure data integrity while safeguarding PII.

Collaboration with project managers, developers, and QA teams will be essential to deliver a seamless data migration and governance framework across client engagements.

Qualifications

• Bachelor’s degree or 5+ years of experience required; Master’s degree preferred.
• 5+ years 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 state service delivery systems and federal regulations governing programs.

Responsibilities

• Data Analysis & Conversion: assess legacy data sources and design conversion strategies for SaaS implementation.
• ETL: perform data extraction, transformation, and loading using appropriate tools.
• Data validation: ensure data integrity post-migration.
• PII: secure handling of client data.
• Engagement & Leadership: lead client meetings to gather requirements and identify data dependencies.
• Translate workflows into data mapping for the new platform.
• Act as trusted advisor on data conversion best practices.
• Collaboration: work with PMs, developers, and QA for seamless integration.
• Documentation: document conversion processes and provide training or support as needed.
• Documentation & Methodology: create data management strategies aligned with project goals.
• Maintain and update data management docs and reusable artifacts across projects.
• Develop data governance training materials for internal and client stakeholders.
• Support data governance use cases with standards, processes, and controls for data quality, lineage, and stewardship.

Skills

ETL processes

Data migration

SQL

Data analysis

PII handling

Client engagement

Leadership

Python basics

JavaScript basics

Education

Bachelor’s degree or 5 years’ experience

Master’s degree (MPA or government focused MBA) preferred

Tools

SQL/MySQL

XML

Data Bricks

Excel

T-SQL

Stored procedures

Python

JavaScript

Job description

Public Consulting Group LLC (PCG) is seeking a data integration & migration professional to lead conversion efforts for SaaS implementations. You will assess legacy data, design ETL strategies, and ensure data integrity while safeguarding PII.

Collaboration with project managers, developers, and QA teams will be essential to deliver a seamless data migration and governance framework across client engagements.