Data Migration and Integration Specialist

Public Consulting Group LLC (PCG) is a prominent public sector solutions firm that specializes in implementation and operations improvement for health, education, and human services agencies. Established in 1986, PCG employs around 2,000 dedicated professionals across the United States, all committed to creating impactful solutions that improve lives. As a member of a trusted family of companies, we serve clients across all 50 states, as well as in three Canadian provinces and Europe. To learn more about our mission, visit our website.As part of our Technology Consulting team, you will collaborate with organizations to streamline operations and meet strategic objectives to serve the public more effectively. We provide a comprehensive range of technology consulting services to assist state and local agencies in addressing operational challenges and enhancing user experiences.About the RoleWe are on the lookout for a skilled Data Migration and Integration Specialist to spearhead the transition of legacy data into a modern SaaS platform. This role demands a unique combination of technical expertise and business insight. Your responsibilities will encompass executing data conversion tasks while also working directly with clients to understand their data frameworks, business processes, and to ensure accurate mapping into the new system.Key Responsibilities: Data Analysis & Conversion: Evaluate legacy data sources and devise conversion strategies for SaaS implementations. Execute data extraction, transformation, and loading (ETL) using relevant tools. Ensure data integrity and accuracy post-migration. Safeguard client data, including managing Personal Identifiable Information (PII). Client Engagement & Leadership: Lead client meetings to gather requirements, clarify business processes, and identify data dependencies. Translate business workflows into data mapping for the new platform. Act as a trusted advisor, guiding clients through best practices for data conversion. Collaboration: Coordinate with project managers, developers, and QA teams to ensure seamless integration. Document conversion processes and provide training or support as necessary. Documentation & Methodology: Develop and implement Data Management strategies aligned with project and organizational goals. Update and maintain data management methodology documents and supporting materials, ensuring they are current and reusable across projects. Contribute to the creation of training materials and knowledge transfer documentation for internal and client stakeholders. Support data governance use cases, including documenting standards, processes, and controls related to data quality, lineage, and stewardship. Required Qualifications: 5+ years of hands-on experience in data conversion, migration, and ETL processes, including extracting data from legacy systems and loading it into new platforms. 5+ years of experience in designing, building, and executing ETL or data integration workflows using integration tools or custom scripts. Additional Qualifications: Proficiency in ETL, SQL/MySQL, XML, Data Bricks, Microsoft Excel, and stored procedures. Basic coding skills in languages such as Python and JavaScript. Experience with relational databases, including tables, views, queries, T-SQL, and stored procedures. Experience in leading data requirements sessions with customers and/or team members. Participation in at least one complete software implementation lifecycle. Understanding of the full software implementation lifecycle, including data requirements gathering and migration. 3+ years of experience in collaborating with cross-organizational partners to define requirements and resolve data issues. 3+ years of experience in mapping, transforming, and loading data from source to target systems. Experience in a Data Conversion work stream during a software implementation. Working Conditions: Office Setting Some travel required This position requires a hybrid work setup with travel/onsite obligations. To thrive at PCG, candidates must: Be available during designated working hours. Have a safe, private, and distraction-free workspace. Fully commit to fulfilling their job responsibilities. Some travel may be necessary for team and client meetings. We welcome applications on an ongoing basis until the position is filled.#LI-AH1#LI-remoteThe information provided above outlines the primary duties and expectations of this role. It does not cover every detail related to responsibilities or required skills.Compensation:PCG offers competitive compensation for this role based on various factors, including office location, role specifications, skills, and experience. The salary range for this position is $95,000 - $125,000.PCG does not sponsor newly hired foreign national workers for work authorization purposes.EEO Statement:Public Consulting Group is an Equal Opportunity Employer committed to fostering diversity and creating an inclusive workplace culture. We believe that our best work emerges from a team that feels empowered and accepted, rooted in respecting each person's unique experiences. At PCG, all employment aspects are based on merit and business needs, without discrimination based on any protected status.

Created: 2026-03-10