Data Migration Specialist I

CATALIS; Edmonton; On-site; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Health & dental benefits

Paid vacation

Udemy course access

Job summary

Catalis, based in Edmonton, is seeking a data migration engineer to translate data from legacy systems into the Catalis cloud, perform cleansing, mapping, and validation for go-lives. This role sits at Catalis’ Edmonton office and offers opportunities to work with PostgreSQL, .NET/C#, Python, and APIs.

You will profile, cleanse, and validate data, run mock migrations, and support post go-live data issue resolution while collaborating with the Implementation team.

Qualifications

• 1+ years in implementation, development, or data-centric roles, ideally SaaS, ERP, or data migration projects.
• Expert or advanced skills in MS-SQL or PostgreSQL.
• Ability to write data conversion scripts and perform complex queries (CTE, stored procedures, window functions).
• Experience with C#, Python, or other programming languages is a strong asset.
• Proficient with Git for source control and merging pull requests.
• Experience working with APIs for data extraction or ingestion.

Responsibilities

• Translate data from legacy and third-party systems into the Catalis cloud platform by executing data cleansing, preparation, and migration activities aligned with approved mapping specifications.
• Ensure data is accurately transformed, validated, and ready for go-live, while supporting cutover execution and timely issue resolution.
• Perform data profiling and cleansing, including formatting, de-duplication, normalization, and required field completion, to improve load success and reduce defects.
• Execute mock migrations in lower environments, capturing results, exceptions, and reconciliation outputs for review by the Implementation team.
• Validate migration outcomes using defined reconciliation checks, including record counts, key field verification, and exception reporting, and elevate variances as needed.
• Provide post go-live support by resolving migration-related data issues, including reloads, script corrections, and follow-up loads, ensuring final migration artifacts are handed off to support teams.
• Work closely with the Project Coordinator and Implementation team to ensure data is transferred accurately, completely, and within agreed timelines.
• Maintain, and execute data mapping documentation, define source-to-target relationships, transformation rules, validation logic, and assumptions to support high quality and repeatable data migrations.
• Develop and maintain scalable data migration tooling, including optimized PostgreSQL stored procedures, .NET/C# migration workflows, and Python-based automation

Skills

PostgreSQL

MS-SQL

C#

Python

APIs

Git

Tools

Git

SSIS

AWS

Job description

Who We Are

Catalis is a leading government Software as a Service (SaaS) and integrated payments provider, powering a wide range of government operations at the municipal, county, state, and federal levels. Our innovative solutions are designed to streamline processes, enhance efficiency, and improve the delivery of government services to the public. At Catalis, we are committed to leveraging technology to make government interactions simpler, faster, and more accessible.

Description

Who We Are

Catalis is a leading government Software as a Service (SaaS) and integrated payments provider, powering a wide range of government operations at the municipal, county, state, and federal levels. Our innovative solutions are designed to streamline processes, enhance efficiency, and improve the delivery of government services to the public. At Catalis, we are committed to leveraging technology to make government interactions simpler, faster, and more accessible.

What We Offer

Catalis is a fast growing and award-winning technology company that serves small urban and rural municipal governments across Canada. We offer competitive compensation, full paid vacation, and comprehensive health & dental benefits. We focus a lot of energy on professional development, offering free access to unlimited Udemy courses for personal and professional advancement, as we want our employees to ride the wave and grow with our business. We strive to be an example of a successful high-growth technology company in Alberta, and our team members depend on each other to make it happen.

This opportunity is based at Catalis’ office in Old Strathcona (Edmonton, Alberta). Our new office includes an innovative vibe, stand‑up desks for all staff, foosball games, an active workplace enrichment committee, fitness challenges, an office dog, lounge areas, and more!

The Opportunity

We are a software and service company with the goal of being an Alberta-based technology company recognized across North America. We are a small team that has seen year-over-year growth and is well positioned to increase our breadth and depth within the niche rural and small urban markets. We are looking for top‑talent team members who can help take us to the next level.

What You Will Do

• Translate data from legacy and third‑party systems into the Catalis cloud platform by executing data cleansing, preparation, and migration activities aligned with approved mapping specifications
• Ensure data is accurately transformed, validated, and ready for go‑live, while supporting cutover execution and timely issue resolution
• Perform data profiling and cleansing, including formatting, de‑duplication, normalization, and required field completion, to improve load success and reduce defects
• Execute mock migrations in lower environments, capturing results, exceptions, and reconciliation outputs for review by the Implementation team
• Validate migration outcomes using defined reconciliation checks, including record counts, key field verification, and exception reporting, and elevate variances as needed
• Provide post go‑live support by resolving migration‑related data issues, including reloads, script corrections, and follow‑up loads, ensuring final migration artifacts are handed off to support teams
• Work closely with the Project Coordinator and Implementation team to ensure data is transferred accurately, completely, and within agreed timelines
• Maintain, and execute data mapping documentation, define source to‑target relationships, transformation rules, validation logic, and assumptions to support high quality and repeatable data migrations
• Develop and maintain scalable data migration tooling, including optimized PostgreSQL stored procedures, .NET/C# migration workflows, and Python-based automation

Requirements

What you Will Need to Succeed

• 1+ years of experience in implementation, development, or data‑centric roles, ideally supporting SaaS solutions, ERP implementations, or data migration projects
• Expert or advanced skills in MS‑SQL or PostgreSQL
• Ability to write data conversion scripts and perform complex queries (CTE, dynamic queries, stored procedures, window function).
• Experience with C#, Python, or other programming languages is considered a strong asset
• Proficient with Git for source control, including merging and pull requests
• Experience working with APIs for data extraction or ingestion
• Experience working with Municipal ERP, Accounting, Tax, Utilities, Payroll software is an asset
• Experience with data migrations, ETL processes, SSIS packages, and AWS/Cloud is an asset
• Familiarity with Salesforce, JIRA, Confluence, Asana, or similar project and documentation platforms

Catalis is committed to building and promoting a diverse workforce and celebrates the unique qualities that individuals of various backgrounds and experiences offer. As an equal employment opportunity employer, all qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, and other protected status as required by applicable law.