Automation Engineer Jobs in Calgary, AB (NOW HIRING)

About Modular Solutions

Founded in 2015, Modular Solutions delivers enterprise-grade technology to the insurance industry. Our configurable platform helps insurers, mutuals, MGAs, and brokers manage core operations through a single system designed for flexibility, long-term growth, and complex regulated environments.

Position Summary

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

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

Required Qualifications

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

Preferred Qualifications

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

Our Technology Stack and Architecture:

Our core platform uses C#/.NET, Entity Framework, PostgreSQL, React, TypeScript, and Azure. This role works closely with product engineering teams on system logic, database structures, APIs, and platform requirements related to migration, BI, data quality, and automation workflows.

Why Join Modular Solutions?

We are building a long-term platform in a complex industry where customers depend on accurate data every day. You will help expand our migration system and make migration and BI work cleaner, faster, and more AI-enabled as we grow. We value autonomy, accountability, strong technical judgment, and people who take pride in building production-grade systems the right way.

What We Offer

• Be part of a growing company building a modern, enterprise-grade platform for the insurance industry.
• Work alongside experienced insurance and technology professionals in a collaborative environment.
• Flexible remote work environment, with a preference for Alberta-based team members, and periodic in-person planning sessions and team events.
• Extended health, dental, and vision benefits.
• Access to an Employee and Family Assistance Program.
• Annual professional development allowance.
• Additional paid time off beyond standard statutory holidays and vacation.
• Recognition for meaningful contributions and career milestones.
• Share Appreciation Rights program so you participate in the companys long-term success.

To Apply:

Please submit your resume and a brief cover letter outlining your relevant experience and what excites you about this opportunity. We thank all applicants for their interest; only those selected for an interview will be contacted.