Data Migration Specialist I

Job summary

Translate data from legacy systems into the Catalis cloud platform by performing cleansing, mapping, and migration activities. Ensure data accuracy through validation, reconciliation, and post-go-live support while maintaining migration documentation and tooling.

Job details

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

What you’ll do

Translate data from legacy systems into the Catalis cloud platform by performing cleansing, mapping, and migration activities. Ensure data accuracy through validation, reconciliation, and post-go-live support while maintaining migration documentation and tooling.

Requirements

Requires at least 1 year of experience in data-centric or implementation roles with advanced skills in MS-SQL or PostgreSQL. Proficiency in programming languages like C# or Python and experience with ETL processes are considered strong assets.

Benefits

• Competitive compensation • Full paid vacation • Health benefits • Dental benefits • Professional development • Unlimited Udemy courses

Listed skills

• ERP systems · Preferred
• PostgreSQL · Preferred
• Data Validation · Preferred
• C++ · Preferred
• Git · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data migration
• MS-SQL
• PostgreSQL
• Data cleansing
• ETL processes
• C#
• Python
• Git
• API integration
• Stored procedures
• Data mapping
• SaaS
• ERP systems
• SQL scripting
• Data validation
• Cloud platforms
• Atlassian Confluence
• Pull/Merge Requests
• Payroll Systems
• Workflow Management
• Go (Programming Language)
• Git (Version Control System)
• Cutover Planning And Management
• Exception Reporting
• Programming Languages
• .NET Framework
• Accounting
• Application Programming Interface (API)
• Amazon Web Services
• Asana
• JIRA
• Automation
• Reconciliation
• C# (Programming Language)
• Software As A Service (SaaS)
• Version Control
• Data Cleansing
• Data Conversion
• Data Duplication Management
• Data Extraction
• Extract Transform Load (ETL)
• Data Mapping
• Data Migration
• Data Profiling
• Scalability
• Innovation
• Python (Programming Language)
• Microsoft SQL Servers
• Operations
• Salesforce

Job areas

• Technology
• Data & Analytics
• Software
• Government & Public Sector
• Data Migration Specialist
• Data Specialist
• Database Designers and Administrators
• Data Warehousing Specialists
• Database Architects