Data Migration & Automation Developer

Modular Solutions•Calgary, AB

4d•Remote

About The Position

Modular Solutions is seeking a Data Migration & Automation Developer to support client data migration, conversion, BI, and implementation projects. This developer-oriented role sits within our Data team and focuses on moving data from source platforms, files, spreadsheets, and custom systems into one clean target state in Modular’s platform. The ideal candidate is strong with SQL, ETL/ELT, BI, semantic models, scripting, data quality, and migration patterns. They should know how to clean, transform, validate, reconcile, and document data effectively while helping improve and extend our existing migration system. Strong AI capability is a core requirement. We are looking for someone who understands modern AI-assisted and agentic development workflows and can apply them responsibly to migration and BI work, including source analysis, semantic modeling, report/data-model review, mapping, scripting, validation, documentation, and automation. This role is well suited for someone who enjoys working with data, solving technical problems, identifying inconsistencies, and collaborating with both technical and business teams.

Requirements

A degree, diploma, or certificate in Computer Science, Data Science, Software Development, Information Systems, or a related field, or equivalent professional experience.
3+ years of experience with data migration, data conversion, BI/reporting, semantic models, ETL/ELT, database development, data analysis, implementation projects, or software development.
Strong SQL skills and experience with PostgreSQL and analytical data platforms such as Snowflake.
Strong understanding of data cleansing, transformation, mapping, validation, reconciliation, and migration from many source platforms and data formats into a clean, reusable target state.
Experience using scripting or programming languages such as C#, Python, PowerShell, TypeScript, or similar tools to automate data, reporting, semantic-layer, or migration workflows.
Hands-on experience with BI tooling, semantic models, governed metrics, reusable reporting models, and reporting assets that can be reviewed, versioned, tested, or automated.
Demonstrated experience with modern AI-assisted and agentic development workflows for coding, scripting, analysis, documentation, BI/reporting work, validation, or automation.
Strong analytical, communication, and problem-solving skills, with high attention to detail and the judgment to validate AI-generated code, SQL, mappings, summaries, and analysis before use in client-facing or production migration work.
Ability to read and interpret business rules, technical documentation, data layouts, and mapping specifications while managing competing priorities during migration projects.

Nice To Haves

Insurance data experience, especially policy, billing, claims, broker, customer, coverage, risk, or transaction data.
Experience converting data from insurance systems, policy administration systems, spreadsheets, custom-built tools, or other business data sources.
Experience with ETL/ELT tools, APIs, internal tooling, automation frameworks, BI tooling, semantic-model tooling, migration utilities, cloud-hosted environments, Agile delivery tools, or implementation/onboarding projects.
Snowflake experience is a major asset.
Power BI, Microsoft Fabric, or similar BI platform experience is a strong asset, especially where reports, models, and metrics are structured, reviewable, or source-controlled.
Experience using agents or automation to improve BI workflows, such as reviewing reporting logic, validating models, documenting semantic layers, or creating quality checks.

Responsibilities

Support client data migration, conversion, BI, and implementation projects as a developer-oriented member of the Data team.
Extract, clean, transform, map, reconcile, and load data from multiple source platforms, spreadsheets, files, and custom systems into a single, consistent target model.
Analyze source data to identify gaps, inconsistencies, duplicates, missing relationships, formatting issues, and other data quality concerns.
Write and maintain SQL queries, scripts, migration utilities, data mapping documentation, conversion rules, validation logic, migration notes, and runbooks.
Improve and extend our existing migration system, including ETL/ELT patterns, conversion tools, templates, validation checks, semantic-model patterns, BI workflows, and quality-control processes.
Use AI-assisted and agentic development workflows to accelerate source analysis, semantic-model design, BI/reporting review, SQL/script generation, documentation, validation, and internal automation while maintaining strong human review.
Support test conversions, mock migrations, production migration activities, reporting, reconciliation, and post-migration validation against source systems, business requirements, and expected platform outcomes.
Collaborate with Data, Development, Product, Implementation, and business stakeholders to understand data requirements, clarify business rules, resolve defects or conversion gaps, and communicate progress, risks, and dependencies.