Data Migration Engineer (Contract)

Citation Canada; Wilmslow; On-site; GBP 50,000 - 67,000; Full time

Benefits offered by this job

25 days holiday

Birthday off work

Gym membership discount

Healthcare

Childcare vouchers

Opportunity to purchase extra leave

Pension contributions

Job summary

Citation is seeking a Data Migrations Engineer (3 Month Contract) to join the data team and oversee safe, accurate migrations across CRM, billing and platform systems. You will work with Salesforce, Chargebee and Dynamics, designing data mappings and validation logic before cutover, not during UAT.

The role emphasizes curiosity about how systems work, building end-to-end migration solutions, and handling edge cases like multiple active records and automated overwrites.

Qualifications

• Excellent writing and communication skills with strong attention to detail.
• Experience writing, troubleshooting, and debugging advanced SQL queries.
• Track record of understanding why two systems behave differently—validation logic, automation, calculated fields, relationship structures.
• Outstanding analytical and problem-solving skills, particularly diagnosing data vs. mapping vs. automation issues.
• Experience with ETL/ELT tools and data migration projects.

Responsibilities

• Lead structured data discovery and profiling at the start of every migration — surface quality, completeness and integrity issues and quantify remediation effort.
• Build detailed source-to-target data mappings grounded in system understanding — not just field lists, but underlying logic and constraints.
• Identify where source and target behave differently during discovery and design for it to avoid defects in testing.
• Build and maintain the ETL/ELT pipelines that move data between systems, including transformation logic for edge cases.
• Own reconciliation and validation between source and target post-migration, tracing discrepancies to root cause.
• Document migration logic, mapping decisions, and known system quirks for reuse across migrations.
• Work with data owners to drive cleanup of quality issues ahead of cutover.
• Support cutover planning and execution, including rollback considerations.

Skills

SQL

Python

ETL/ELT tools

Data migrations

Tools

DBT

Databricks

Snowflake

BigQuery

Redshift

Job description

Job Title: Data Migrations Engineer (3 Month Contract)

The Role

The Citation Group is building out its data and AI capabilities to be best in class. As part of this, we're looking for a Data Migration Engineer to join the data team and support in moving data safely and accurately between systems as we consolidate and modernise our platform landscape.

This isn't a generic ETL role. You'll be working on live migrations between operational systems (CRM, billing, and platform migrations) where the real risk isn't moving the data — it's the things that only surface once it lands: automation overwriting values post-import, subscription or contract logic that doesn't map cleanly, validation rules that silently reject or reshape records. You'll work closely with the Head of Data Migrations, data owners, and platform specialists (Salesforce, Chargebee, Dynamics) to make sure those gaps are found and designed for before cutover, not discovered during UAT.

We're looking for someone who's naturally curious about how systems actually work under the hood — not satisfied with a field-to-field mapping sheet until they understand the logic, constraints, and automation behind both ends of the migration.

Responsibilities

• Lead structured data discovery and profiling at the start of every migration — surfacing quality, completeness, and integrity issues while there's still time to remediate them, and quantifying the remediation effort involved
• Build detailed source-to-target data mappings grounded in a genuine working understanding of both systems — not just field lists, but the underlying logic, constraints, and assumptions each platform makes
• Identify where source and target behave differently (validation rules, required fields, relationship structures, calculated vs. stored values, automation-driven overwrites) during discovery, and design for it rather than letting it surface as a defect in testing
• Build and maintain the ETL/ELT pipelines that move data between systems, including transformation logic for edge cases (e.g. multiple active records per customer, hardcoded vs. derived fields)
• Own reconciliation and validation between source and target post-migration, including tracing discrepancies back to root cause (data issue vs. platform automation vs. mapping error)
• Document migration logic, mapping decisions, and known system quirks so they're reusable across future migrations
• Work with data owners to drive cleanup of quality issues ahead of cutover
• Support cutover planning and execution, including rollback considerations

The Person

We're looking for someone who can roll their sleeves up and dig into both the data and the systems around it. In addition, the successful candidate should have:

• Excellent writing and communication skills with strong attention to detail — you'll need to explain system-behaviour gaps clearly to non-technical stakeholders
• Experience writing, troubleshooting, and debugging advanced SQL queries
• A track record of going beyond field-level mapping to understand why two systems behave differently — validation logic, automation, calculated fields, relationship structures
• Outstanding analytical and problem-solving skills, particularly diagnosing whether an issue is a data problem, a mapping problem, or a platform automation problem
• Experience with ETL/ELT tools and data migration projects specifically (not just general pipeline building)
• Programming experience in Python
• Comfort working with ambiguity — migration requirements shift as discovery uncovers new system behaviour, and you'll need to adapt scope calmly rather than treat it as scope creep

Skills and experience we'd love you to have... but if not? We'll help you get there:

• Experience migrating data into or out of CRM/billing platforms such as Salesforce
• Understanding of how declarative platform automation silently alter data post-import
• Experience in relational cloud-based database technologies like Snowflake, BigQuery, Redshift
• Understanding of cloud computing security concepts
• Familiarity with DBT and Databricks
• Experience working in an agile environment
• Experience working with AI tools (Claude Code, Cortex, etc.) to accelerate migration analysis

About Us

We are Citation. We are far from your average service provider. Our colleagues bring their brilliant selves to work every day and we create an environment where they can shine. We are a nice bunch. We don’t do office politics or “that’s not my job”. We listen, support and take ownership.

We have been proudly delivering valuable HR and Health and Safety services to SME’s across the UK for over 20 years. Passionate about service, we’re on a mission to revolutionise our colleague’s and client’s experience by employing brilliant people who are experts at what they do and smile whilst they are doing it.

Working for Citation you will have access to 25 days holiday, plus your birthday off work, gym membership discount, healthcare, childcare vouchers, the opportunity to purchase extra leave, pension contributions and more.

• 25 days holiday
• your birthday off work
• gym membership discount
• healthcare
• childcare vouchers
• the opportunity to purchase extra leave
• pension contributions

It’s a great place to work because of the people we employ. Fun and professional, we want likeminded individuals who love to love their job and want the Company to succeed.