Talent.com
The Citation Group
Data EngineerThe Citation Group • Wilmslow, Cheshire, United Kingdom
Data Engineer

Data Engineer

The Citation Group • Wilmslow, Cheshire, United Kingdom
3 days ago
Job type
  • Full-time
Job description

Job Description

Role: Data Engineer



Below covers everything you need to know about what this opportunity entails, as well as what is expected from applicants.

Working Location: Hybrid (1 day per fortnight in Wilmslow office)



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.



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



So, if our culture sounds like a good fit for you and you want to be part of our success story, then send us your details.

Create a job alert for this search

Data Engineer • Wilmslow, Cheshire, United Kingdom

Similar jobs

Data Engineer

Pathfinder - IT RecruitmentManchester, England, GB
Full-time

Get AI-powered advice on this job and more exclusive features.Pathfinder - IT Recruitment provided pay range.This range is provided by Pathfinder - IT Recruitment.Your actual pay will be based on y... Show more

 • Promoted

Data Engineer

One ManchesterManchester, England, GB
Full-time

You’ll design, implement and maintain a centralised data platform and data management system that consolidates data from business applications and other sources to act as the foundation for One Man... Show more

 • Promoted

Lead Data Engineer

Data IdolsManchester, England, GB
Full-time

Data Idols are working with a data‑driven organisation that is expanding its cloud data engineering capability and is looking for a Lead Data Engineer to join the team.This role sits within a moder... Show more

 • Promoted

Senior Data Engineer – Analytics & Data Platform

TrueNorth®Manchester, England, GB
Full-time

A fast-growing technology-driven organization in the United Kingdom seeks a Senior Data Engineer (Analytics) to build and scale a modern, cloud-based data platform.This role focuses on designing ro... Show more

 • Promoted

Senior Data Engineer — Public Sector Data Platforms

Informed SolutionsAltrincham, England, GB
Full-time

A leading digital transformation consultancy in the UK is seeking a Senior Data Engineer to design and deliver data platforms underpinning critical public sector services.You will take ownership of... Show more

 • Promoted

Snowflake Data Engineer - Consultancy

Talenting Career ScienceManchester, England, GB
Permanent

Salary up to £72,000 plus benefits.Are you ready to stop maintaining and start building? We're looking for a Snowflake Data Engineer for a permanent role with a Manchester-based consultancy that sp... Show more

 • Promoted

Data Engineer

PortSwiggerKnutsford, England, GB
Full-time

PortSwigger exists to enable the world to secure the web.We build the tools practitioners trust, the knowledge that trains security professionals, and a community that makes anyone who cares about ... Show more

 • Promoted

Data Engineer

PortSwigger Web SecurityKnutsford, England, GB
Full-time

PortSwigger exists to enable the world to secure the web.We build the tools practitioners trust, the knowledge that trains security professionals, and a community that makes anyone who cares about ... Show more

 • Promoted

Data Engineer

DufrainManchester, England, GB
Full-time

Dufrain is a pure-play data consultancy specialising in helping businesses unlock the true value of their data by providing market-leading data solutions and services which includes developing stra... Show more

 • Promoted

Data Engineer | Hybrid, Data Pipelines & ML

Royal LondonAlderley Edge, England, GB
Full-time

Royal London is seeking a Data Engineer to join its Analytics Engineering Team within the Group Data & AI Office.The role focuses on building data pipelines and data assets to enable analytics, dat... Show more

 • Promoted

Senior Data Engineer - ID44669

Humand TalentPackmoor, England, GB
Full-time

Love getting stuck into code and solving real-world data problems?.Want to work with modern tools in an organisation that values data?.Looking for a hands‑on role where you can build, improve, and ... Show more

 • Promoted

Data Engineer

MRJ RecruitmentManchester, England, GB
Full-time

This range is provided by MRJ Recruitment.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.We’re on the hunt for a skilled Data Engineer to join ... Show more

 • Promoted

Senior Quantexa Data Engineer – Manchester / Hybrid

NoirManchester, England, GB
Full-time

Senior Quantexa Data Engineer - Manchester / Hybrid.Our client is a global innovator and world leader with one of the most recognisable names within technology.They are looking for an experienced Q... Show more

 • Promoted

Data Engineer

Astro Studios, Inc.Manchester, England, GB
Full-time

We believe in the power of ingenuity to build a positive human future.As strategies, technologies, and innovation collide, we create opportunity from complexity.Our teams of interdisciplinary exper... Show more

 • Promoted

Data Engineer

Searchability®Manchester, England, GB
Full-time

Get AI-powered advice on this job and more exclusive features.This range is provided by Searchability.Your actual pay will be based on your skills and experience — talk with your recruiter to learn... Show more

 • Promoted

Data Engineer – Lakehouse Pipelines (Databricks & Fabric)

Leonard Curtis Recovery LimitedManchester, England, GB
Full-time

Leonard Curtis Recovery Limited is seeking a Data Engineer in Manchester to design and optimize data pipelines for enterprise analytics using Microsoft Fabric tools and Databricks.The ideal candida... Show more

 • Promoted

Data Engineer

Cyber Security training coursesManchester, England, GB
Full-time

A fast-growing, family-oriented organisation operating across multiple locations in the UK with a strong focus on people, development and long-term career growth are looking for a Data Engineer to ... Show more

 • Promoted

Data Engineer

The Fragrance ShopStretford, England, GB
Full-time

Established 1994, The Fragrance Shop is the UK’s leading independent fragrance retailer, showcasing over 130 fragrance brands across 220 stores and online at www.We are expanding and looking for a.... Show more

 • Promoted

Data Engineer

SPG ResourcingManchester, England, GB
Full-time

This range is provided by SPG Resourcing.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Direct message the job poster from SPG Resourcing.Recru... Show more

 • Promoted

Data Engineer

Michael PageManchester, England, GB
Full-time +1

This role involves designing, developing, and maintaining robust data pipelines to support analytics within the industrial and manufacturing sector.The successful candidate will be heavily involved... Show more