Opens an external site
- Employment type
- Full-time
- Experience level
- Mid-level · 2+ years
- Posting language
- English
- Working hours
- 40 hours per week
Job summary
The Data Migration Specialist will own the accuracy and integrity of moving complex customer data into the company's platform. They will define source-to-target data mapping specifications and execute migrations using internal ETL tooling.
Job details
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 ddunne@clearrisk.com
What you’ll do
The Data Migration Specialist will own the accuracy and integrity of moving complex customer data into the company's platform. They will define source-to-target data mapping specifications and execute migrations using internal ETL tooling.
Requirements
The role requires strong Excel fluency, a demonstrated obsession with data quality, and the ability to work closely with developers. Experience with data-focused coding and handling sensitive data in regulated environments is considered an advantage.
Benefits
- Competitive salary
- Benefits package
Listed skills
- Microsoft Excel · Preferred
- SQL · Preferred
- Python · Preferred
- Requirements gathering · Preferred
- Business analysis · Preferred
- Risk Management · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Data migration
- ETL
- Excel
- Data mapping
- Data quality
- Data integrity
- SQL
- Python
- Requirements gathering
- Data modeling
- Business analysis
- Risk management
- Insurance
- PII/PHI handling
- AI-assisted tooling
- Artificial Intelligence
- Data Analysis
- Software Development
- Customer Data Management
- Extract Transform Load (ETL)
- Data Mapping
- Data Migration
- Data Modeling
- Data Quality
- Financial Services
- Python (Programming Language)
- Risk Management
- Mechanics
- Real Estate
- Requirements Elicitation
- Safety Assurance
- SQL (Programming Language)
- Tooling
Job areas
- Data & Analytics
- Technology
- Software
- Finance & Accounting
- Consulting
- Data Migration Specialist
- Data Quality Analyst
- Management and Organization Analysts
- Business Intelligence Analysts
- Data Scientists