Data Conversion Specialist

Public Consulting Group LLC (PCG) is a leading public sector solutions implementation and operations improvement firm that partners with health, education, and human services agencies to improve lives. Founded in 1986, PCG employs approximately 2,000 professionals throughout the U.S.—all committed to delivering solutions that change lives for the better. The firm is a member of a family of companies with experience in all 50 states, and clients in three Canadian provinces and Europe.

PCG offers clients a multidisciplinary approach to meet challenges, pursue opportunities, and serve constituents across the public sector. To learn more, visit .Collaborating with our Technology Consulting team, you will help organizations streamline operations and achieve strategic goals to serve the public better. We provide the full spectrum of technology consulting services to help state and local agencies meet operational and program needs that enhance the lives of their user base.

Services:

Strategy, Architecture, Planning, and Procurement Business Enablement Business Solutions Project Assurance About the Role We are seeking a Data Conversion Specialist who will lead the migration of legacy data into a modern SaaS platform. This role requires a unique blend of technical proficiency and business acumen. You will not only execute data conversion tasks but also engage directly with clients to understand their data structures, business processes, and ensure accurate mapping into the new system.

Key Responsibilities:

Data Analysis & Conversion 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)​ 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

Serve as a trusted advisor, guiding clients through conversion best practices

Collaboration

Work closely with project managers, developers, and QA teams to ensure seamless integration

Document conversion processes and provide training or support as needed

Documentation & Methodology 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

Required Qualifications Bachelor’s degree or 5 years’ related experience required5+ 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…