Data Conversion Specialist

Public Consulting Group•Boston, MA

4d•Hybrid

About The Position

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.

Requirements

Bachelor’s degree or 5 years’ 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.

Nice To Haves

Master’s degree (MPA or government focused MBA) preferred
Proficient with ETL, SQL/MySQL, XML, Data Bricks, Microsoft Excel, stored procedures, or other data tooling
Basic coding experience in languages such as Python and JavaScript
Experience with relational databases (tables, view, queries, T-SQL and stored procedures)
Experience working with customers and/or team members and leading data requirements sessions
Participation in a minimum of 1 full life cycle software implementation
Understanding of the complete software implementation lifecycle – including data requirements gathering, dataset migration, data reconciliation, and move to production
3+ years of experience coordinating and collaborating with cross-organizational partners to define requirements and resolve data issues
3+ years of experience mapping, transforming, and loading data from source to target software systems
Experience in a Data Conversion work stream on a software implementation

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