Data Migration Specialist I

Socket.dev; Edmonton; On-site; CAD 75,000 - 115,000; Full time

Benefits offered by this job

Competitive remuneration

Full paid vacation

Health & dental benefits

Udemy courses

Job summary

Catalis is a Canada-based software and services company seeking top-talent for data migration, transformation, and cloud readiness. You will translate legacy data into the Catalis cloud, ensuring accuracy and timely go-lives across municipal and government workflows.

The role emphasizes SQL proficiency, scripting in C# and Python, API usage, and cloud ETL workflows, with a strong culture of professional development and inclusive growth.

Qualifications

• 1+ years in implementation or data-centric roles in SaaS or ERP projects.
• Expert or advanced SQL (MS-SQL or PostgreSQL) skills.
• Ability to write data conversion scripts and complex queries (CTE, stored procedures).
• Experience with C#, Python or similar languages.
• Proficient with Git for source control and PRs.
• Experience with APIs for data extraction/ingestion.
• Familiarity with Salesforce, JIRA, Confluence, Asana or similar tools.
• Experience with ETL processes, SSIS, and AWS/Cloud is a plus.

Responsibilities

• Translate data from legacy and third-party systems into Catalis cloud platform per mapping specs.
• Prepare data for go-live with validation, cutover support, and issue resolution.
• Profile, cleanse, de-duplicate, normalize data to improve load success.
• Execute mock migrations in lower environments and document results for review.
• Validate migration outcomes via reconciliation checks and escalate variances.
• Provide post go-live data issue resolution and hand off artifacts to support teams.
• Collaborate with Project Coordinator and Implementation to ensure timely, accurate transfers.
• Maintain data mapping docs and define source-to-target relationships and rules.
• Develop scalable migration tooling: PostgreSQL stored procedures, .NET/C# workflows, Python automation.

Tools

MS-SQL

PostgreSQL

Git

APIs

C#

Python

SSIS

AWS

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.

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.