Data Migration Specialist

ClearRisk; San Juan de Terranova; Remote; CAD 70,000 - 110,000; Full time

Job summary

ClearRisk is seeking a Data Migration Specialist to own the accuracy of migrating customer data into our platform. You will map source data to the data model and verify transformations, ensuring the migrated data reflects the customer's business needs.

The role collaborates with Business Analysts and Implementation teammates, uses internal ETL tooling, and focuses on data quality, not just process execution. This is a full-time permanent position with competitive salary and benefits.

Qualifications

• Strong Excel and data mapping skills.
• Experience validating data mappings and transformations.
• Ability to read data models and ask questions.
• Experience with Python/SQL coding is a plus.
• Experience with AI-assisted tooling is a plus.
• Experience handling PII/PHI or regulated data preferred.
• Familiarity with insurance and risk management a plus.

Responsibilities

• Define source-to-target data mappings for migrations.
• Verify data mappings and transformations pre-load and post-load.
• Execute migrations using internal ETL tooling.
• Collaborate with developers on complex integrations.
• Document mapping decisions and rationale clearly.
• Flag data quality issues and edge cases for resolution.

Skills

Excel

Data quality

Data modeling

Python

SQL

ETL tooling

AI-assisted tooling

Regulated data handling

Insurance/risk knowledge

Tools

ETL tooling

Job description

Data Migration Specialist

Location

ST. JOHN'S, Newfoundland and Labrador or Remote

ClearRisk empowers our customers by optimizing risk and improving safety for their employees and the general public. We keep people from harm and help our customers be more successful. Our cloud-based claims and risk management solutions provide customers with a suite of tools and insights built for industries such as municipalities, utilities, real estate/property groups, manufacturers, retailers and more. Our solutions lower insurance and risk management costs while giving meaningful data insights that drive business growth.

About the Role

ClearRisk's implementation work involves moving customer data – often complex, agency- or municipality-specific data – into our platform's data model. This role exists to own the accuracy and integrity of that process: defining how source data maps to our data model, verifying that mappings and transformations are correct, and executing migrations directly using our ETL tooling.

This is not strictly a software development role, nor is it a traditional test/QA role. It is a role for someone who is obsessed with getting data right, and who wants to understand why a field maps where it does, why a transformation is needed, and what value it provides for the customer – not just confirm that a process ran without error.

What You'll Do

• Participate in requirements gathering and define source-to-target data mapping specifications for customer integration and migration projects, in partnership with the Business Analyst and other Implementation team members
• Own quality verification of data mappings and transformations – both pre-load and post-load – ensuring data lands correctly, cleanly, and in a way that reflects the customer's actual business need
• Execute standard migrations/integrations directly using ClearRisk's internal ETL tooling (Excel-competency level of complexity)
• Partner with developers on complex, custom-coded integration builds, validating that implemented mappings match the intended specification and that output data is correct (a QA/validation role on these projects, not a build role)
• Document mapping decisions and transformation logic clearly enough that intent ("why this maps here") is understood by others, not just the mechanics
• Flag data quality issues, mapping ambiguities, or edge cases for resolution

What You'll Bring

• Strong Excel/spreadsheet fluency; comfort with ETL-style tooling
• Demonstrated obsession with data accuracy/quality, ideally with examples of catching subtle data issues and not just obvious ones
• Ability to understand and question business context – why a piece of data matters, not just where it goes
• Comfortable working closely with developers without being one. Can read a data model, ask good questions, and evaluate output without writing code
• Data-focused coding experience (Python, SQL, etc.) would be an advantage
• Experience with AI-assisted tooling (e.g. using LLMs to safely assist with mapping suggestions, data review, or documentation) would be beneficial
• Experience with handling sensitive data in regulated environments (e.g. PII/PHI, healthcare, financial services, government) would be a bonus, as the data this role touches can be sensitive in nature
• Familiarity with insurance and risk management would be a plus

We are looking for a driven individual who is motivated to build their career. This is a full-time permanent position with a competitive salary, benefits package and more.

ClearRisk may use AI-enabled tools to support parts of the recruitment process, including reviewing and assessing applications. Human team members are involved throughout the hiring process, and all decisions about candidate progression and selection are made by people. If you have any questions or require accommodation, please contact the hiring contact at [e-mail]