Data Migration Specialist I

Catalis Holdco Inc; Edmonton; On-site; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Health & dental benefits

Unlimited Udemy courses

Vacation and office vibe in Edmonton

Job summary

Catalis, an Edmonton-based government SaaS and data migration specialist, seeks a data-centric professional to translate legacy data into Catalis cloud platforms. You will cleanse, transform, validate, and migrate data, write conversion scripts, and support post-go-live remediation throughout the project lifecycle.

Ideal candidates have 1+ years in SaaS/data migration contexts, strong SQL skills, and experience with C#/Python. This role operates from our Edmonton office in Old Strathcona.

Qualifications

• 1+ years of experience in implementation, development, or data-centric roles, ideally SaaS or data migrations.
• Expert or advanced skills in MS-SQL or PostgreSQL.
• Ability to write data conversion scripts and perform complex queries (CTE, dynamic SQL, SPs).
• Experience with C#, Python or similar languages is a strong asset.
• Proficient with Git for version control and PR workflows.
• Experience with APIs for data extraction/ingestion.
• Experience with Municipal ERP, Accounting, Tax, Utilities, Payroll software is an asset.
• Experience with data migrations, ETL, SSIS, AWS/Cloud is an asset.
• Familiarity with Jira, Confluence, Asana or similar project/documentation platforms.

Responsibilities

• Translate data from legacy and third-party systems into the Catalis cloud platform via data cleansing, preparation, and migration.
• Ensure data is transformed and validated, supporting cutover and issue resolution.
• Perform data profiling, cleansing, de-duplication, normalization to improve load success.
• Run mock migrations in lower environments and document results for review.
• Validate migration outcomes with reconciliation checks and escalate variances.
• Provide post go-live support for migration-related data issues and reloads.
• Collaborate with the Project Coordinator and Implementation team for timely data transfer.
• Document and maintain mapping, relationships, transformations, and validation logic.
• Develop scalable migration tooling using PostgreSQL, .NET/C#, and Python.

Skills

PostgreSQL

MS-SQL

C#

Python

ETL

Data migration

Git

APIs

JIRA

Confluence

Asana

Tools

Salesforce

JIRA

Confluence

Asana

Job description

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 escalate 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

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

Requirements

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.