Data Migration Specialist I — SaaS for Government

Catalis, LLC; Edmonton; Hybrid; CAD 65,000 - 95,000; Full time

Benefits offered by this job

Competitive compensation

Health & dental benefits

Full paid vacation

Udemy courses access

Job summary

Catalis is a leading government SaaS and data migration partner helping municipal, county, state, and federal entities across Canada. We seek top-talent to cleanse, transform, and migrate data into the Catalis cloud platform while maintaining go-live readiness and quality.

You will collaborate with the Implementation team to ensure accurate, timely data transfers and durable migration artifacts. Join a growth‑minded team committed to professional development, including Udemy courses, competitive

Qualifications

• 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

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

SaaS data migration

ERP implementations exposure

Analytical skills

Tools

PostgreSQL

MS-SQL

C#

Python

Git

APIs

AWS

Salesforce

Jira/Confluence/Asana

Job description

Catalis is a leading government SaaS and data migration partner helping municipal, county, state, and federal entities across Canada. We seek top-talent to cleanse, transform, and migrate data into the Catalis cloud platform while maintaining go-live readiness and quality.

You will collaborate with the Implementation team to ensure accurate, timely data transfers and durable migration artifacts. Join a growth‑minded team committed to professional development, including Udemy courses, competitive