Data Conversion Specialist - Public Pension Administration

We are seeking a Data Conversion Specialist with hands-on experience in large-scale public pension administration system modernization programs, specializing in ETL development, data reconciliation, and legacy system data migration. The position is 100% Remote.

Can work with C2Cs

This technical role is the primary data conversion resource, responsible for building and maintaining the ETL pipelines, conversion scripts, and reconciliation tooling that drive the Retirement Insurance System Enhancement (RISE) data migration workstream.

Must demonstrate direct experience developing data conversion programs for pension or benefits system modernization projects, including executing source-to-target mapping, SSIS/BIML development, SQL Server and T-SQL optimization, and participation in mock runs and UAT cycles through production cutover. The Worker will follow all organizational Standard Operating Procedures related to deliverable approvals, reviews, and associated workflows.

Must have technical experience to collaboratively develop and maintain conversion assets, troubleshoot ETL exceptions, and work closely with the Technical Architect, ML/AI Engineer, and ERS data stewards to resolve data issues and ensure converted data aligns with functional requirements and business rules. Strong attention to detail, structured debugging discipline, and cross-functional communication skills are expected.

Functional Responsibilities:

We are seeking a Data Conversion Specialist with direct hands-on experience in large-scale pension or benefits system data migration programs. The worker will execute the technical data conversion workstream for the client''s program, developing and maintaining ETL pipelines, reconciliation scripts, and conversion monitoring tools across all Central Data Repository (CDR) cycles.

The worker will be responsible for:

•     Develop and maintain packages and scripts for automated, repeatable data extraction, transformation, and load processes across legacy source data and target schema

•     Implement and optimize stored procedures, views, indexes, and SQL queries to support high-volume ETL operations and data reconciliation workflows

•     Develop automation scripts for conversion process orchestration, custom components, and backend data processing logic across multiple CDR cycles

•     Execute source-to-target mapping in alignment with CDR specifications, applying authorization and exclusion logic to filter ineligible, duplicate, or obsolete member and employer records

•     Participate in data reconciliation activities including record count validation, key field comparison, exception reporting, screen validation within the target TELUS Health Ariel platform

•     Support multiple extract and load processes across development, test, and production environments, ensuring converted data aligns with functional requirements and ERS business rules

•     Collaborate with QA teams, functional testers, and the ML/AI Engineer to verify data migration results, resolve defects, and implement fixes during mock runs and UAT cycles

•     Generate and maintain conversion monitoring reports tracking ETL job completion, exception handling, and data validation statistics for program leadership visibility

The Worker should have strong hands-on experience in pension or benefits system data conversion development within a structured, governance-driven program environment.

Minimum Qualifications

Please do not submit a candidate that does not meet the following minimum requirements.

The Worker should have strong hands-on experience in pension or benefits system data conversion development within a structured, governance-driven program environment.

Preferred Qualifications