Data Migration Specialist |12- Month Contract

Catalis Holdco Inc

Edmonton

On-site

CAD 70,000 - 110,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Catalis Holdco Inc. is seeking a data engineering professional to join the Edmonton-based data team on a 12-month, onsite contract.

You will automate and connect migration steps, manage end-to-end workflows, and own automation components from early weeks. You will work with senior engineers to optimize cutover times, implement robust restart logic, and contribute to triage, documentation, and CI/CD processes using Claude and other AI tools.

Qualifications

  • 1–3 years of experience in data engineering, database development, ETL, or a similar technical role.
  • Working knowledge of MS-SQL and PostgreSQL, including stored procedures and troubleshooting queries.
  • Python or PowerShell/Bash scripting for automation.
  • Familiarity with AWS (S3, EC2, or RDS level).
  • Experience with Git for source control, including branching, merging, and pull requests.
  • Working use of JIRA and Confluence for tickets and documentation.
  • Strong troubleshooting skills and clear written escalation notes.
  • A self-starter who learns independently and delivers working solutions.
  • Comfort working with AI tools such as Claude as a daily partner.
  • Bachelor’s degree in computer science, IT, or engineering, or equivalent practical experience.

Responsibilities

  • Connect migration steps into an end-to-end workflow with backup/restore, cleaning scripts, SSIS data movement, and cloud schema integration.
  • Create and schedule jobs so migrations run overnight with ready results.
  • Build restart logic to resume failed runs and reload only failed modules.
  • Produce a clear failure report after each run.
  • Help reduce migration cutover time from 5 days to 2 days with senior-led go-lives.
  • Triage failures by reading logs, diagnosing root causes, and logging tickets for the rest.
  • Manage database changes through Git and CI/CD.
  • Evaluate and introduce new tools with senior approval.
  • Document runbooks for team-wide operations.
  • Use Claude and other AI tools daily to write, debug, and review code.

Skills

Data engineering
ETL
Python
PowerShell
Bash
AWS
Git
JIRA
Confluence
Claude
Self-starter

Education

Bachelor’s degree in computer science/IT/engineering

Tools

MS-SQL
PostgreSQL
SSIS
Flyway
Liquibase
GitHub Actions
Azure DevOps
Airflow
PyTest
Playwright
SQL Server Agent

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.

Join a dynamic team, focused on helping Municipal Governments “Connect and Simplify Municipal Information to help make data informed decisions.” We are a data and service company with the goal of being an Alberta based technology company recognized across Canada. 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 market, and we are looking for top-talent team members who can help take us to the next level.

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

This is a 12-month contract on the Catalis data team. Our QA automation is already in place; this role automates the migration process itself, connecting today’s separate tools, scripts, and manual handoffs into one repeatable pipeline. You will work alongside a senior team and own pieces of the automation from your first weeks.

This is an onsite 12-month contract position working out of our Edmonton office Monday through Friday.

What you Will Do
Migration Automation
  • Connect our existing migration steps into one triggered, end-to-end workflow: database backup and restore, cleaning scripts, SSIS data movement, stored procedures into the cloud schema, post-migration scripts, and automated QA runs
  • Create and schedule jobs so migrations run overnight, with results ready the next morning
  • Build restart logic so a run can resume from the step that failed, or reload only the modules that failed, without a full rerun.
  • Produce a clear failure report after each run
  • Help reduce migration cutover time from 5 days to 2 days, supporting guided go-lives led by the senior team
Triage, Quality & Documentation
  • Triage failures: read logs, find the root cause, fix what is in your lane, and log clear tickets for the rest
  • Manage database changes (scripts, stored procedures, schema updates) through Git and CI/CD
  • Evaluate and introduce new tools, such as a job scheduler or orchestrator and a database change management tool, with senior approval
  • Document runbooks so the wider team can operate the automation
  • Use Claude and other AI tools daily to write, debug, and review code
Requirements
What you Will Need to Succeed
Required
  • 1–3 years of experience in data engineering, database development, ETL, or a similar technical role
  • Working knowledge of MS-SQL and PostgreSQL, including stored procedures and troubleshooting queries
  • Python or PowerShell/Bash scripting for automation
  • Familiarity with AWS (S3, EC2, or RDS level)
  • Experience with Git for source control, including branching, merging, and pull requests
  • Working use of JIRA and Confluence for tickets and documentation
  • Strong troubleshooting skills and clear written escalation notes
  • A self-starter who learns independently, is coachable, and delivers working solutions
  • Comfort working with AI tools such as Claude as a daily partner
  • Bachelor’s degree in computer science, IT, or engineering, or equivalent practical experience
Nice to have:
  • Experience with Flyway or Liquibase for database change management, and GitHub Actions or Azure DevOps for CI/CD
  • Experience with ETL processes or SSIS packages
  • Exposure to PyTest or Playwright test automation
  • Experience with scheduling or orchestration tools (SQL Server Agent, cron, Airflow)
  • Experience with Municipal ERP, Accounting, Tax, Utilities, or Payroll software

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Migration Specialist |12- Month Contract
Data Migration Specialist |12- Month Contract

Catalis • Edmonton

On-site
CAD 90,000 - 120,000
Data Migration Specialist
Data Migration Specialist

Catalis • Edmonton

On-site
CAD 42,000 - 56,000
Full paid vacation
Health & dental benefits
Udemy courses for development
+1
Data Migration Specialist
Data Migration Specialist

Catalis Holdco Inc • Edmonton

On-site
CAD 48,000 - 72,000
Software Implementation Specialist
Software Implementation Specialist

Catalis Holdco Inc • Edmonton

On-site
CAD 65,000 - 90,000
Paid vacation
Health & dental benefits
Udemy courses access
+1
Software Implementation Specialist
Software Implementation Specialist

CATALIS • Edmonton

On-site
CAD 55,000 - 85,000
Full health & dental benefits
Paid vacation
Udemy course access
+1
Software Validation Specialist
Software Validation Specialist

Catalis, LLC • Edmonton

On-site
CAD 65,000 - 90,000
Competitive compensation
Paid vacation
Health & dental benefits
+1
Software Validation Specialist
Software Validation Specialist

Catalis • Edmonton

On-site
CAD 60,000 - 80,000
Software Validation Specialist
Software Validation Specialist

Catalis Holdco Inc • Edmonton

On-site
CAD 60,000 - 90,000
Health & dental benefits
Udemy courses
Office in Old Strathcona
Manager, Software Support
Manager, Software Support

Catalis Holdco Inc • Edmonton

On-site
CAD 90,000 - 120,000
Health insurance
Paid vacation
Udemy courses
Manager, Software Support
Manager, Software Support

Catalis, LLC • Edmonton

On-site
CAD 90,000 - 130,000
Health & dental benefits
Paid vacation
Udemy courses