System Integration Migration & Conversion...

Public Consulting Group
Helena, MT, United States
2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$95,000.0 - $125,000.0
Working hours
Regular working hours
Job source

Tech stack

JavaScript (Programming Language) Microsoft Excel Data Analysis BASIC (Programming Language) Software as a Service Databases Data Conversion Data Governance Data Integration Data Integrity Extract Transform Load (ETL) Data Mapping
+21 more
Data Transformation Data Migration Data Mining Data Retrieval Data Structures Relational Databases Python (Programming Language) MySQL Product Software Implementation Methods Software Systems SQL Stored Procedures SQL Databases Systems Integration Transact-SQL Extensible Markup Language (XML) Scripting Data Strategy Integration Frameworks Data Management Legacy Systems Databricks

Job description

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., 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

Requirements

  • 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.

Additional Qualifications:

  • 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

Benefits & conditions

Compensation for roles at Public Consulting Group varies depending on a wide array of factors including, but not limited to, the specific office location, role, skill set, and level of experience. As required by applicable law, PCG provides a reasonable range of compensation for this role. In addition, PCG provides a range of benefits for this role, including medical and dental care benefits, 401k, PTO, parental leave, bereavement leave

Range: $95,000 - $125,000

PCG does not sponsor newly hired foreign national workers for work authorization, including H-1B sponsorship.

About the company

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 www.publicconsultinggroup.com .

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., family or parental status, or any other status protected under federal, state, or local law. PCG will not tolerate discrimination or harassment based on any of these characteristics. PCG believes in health, equality, and prosperity for everyone so we can succeed in changing the ways the public sector, including health, education, technology and human services industries, work.

Public Consulting Group is an equal opportunity employer. All qualified applicants receive consideration for employment without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity, protected veteran status, or status as a qualified individual with a disability. VEVRAA Federal Contractor.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on juju.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:18 min

Scaling MySQL databases for massive user growth

Johannes Nicolai Johannes Nicolai +1 · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

1:04 min

Introduction to Bitcoin script parsing tools

Steve Shadders · LIVE

47 sec

Building modern data pipelines for legacy exports

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

1:48 min

Analyzing network packets with database protocol tools

Daniël van Eeden Daniël van Eeden · WWC Europe 2026

3:46 min

Navigating a career in cloud transformation consulting

Piet Van Dongen · LIVE

Videos

See all

Related articles

See all