Data Migration Specialist

p strong The Role /strong /p p The Citation Group is building out its data and AI capabilities to be best in class. As part of this, were 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. /p p This isnt a generic ETL role. Youll be working on live migrations between operational systems (CRM, billing, and platform migrations) where the real risk isnt moving the data — its the things that only surface once it lands: automation overwriting values post-import, subscription or contract logic that doesnt map cleanly, validation rules that silently reject or reshape records. Youll 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 em before /em cutover, not discovered during UAT. /p p br /p p Were looking for someone whos 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. /p p br /p p strong Responsibilities /strong /p ul li Lead structured data discovery and profiling at the start of every migration — surfacing quality, completeness, and integrity issues while theres still time to remediate them, and quantifying the remediation effort involved /li li 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 /li li 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 /li li 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) /li li 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) /li li Document migration logic, mapping decisions, and known system quirks so theyre reusable across future migrations /li li Work with data owners to drive cleanup of quality issues ahead of cutover /li li Support cutover planning and execution, including rollback considerations /li /ul p br /p p strong The Person /strong /p p Were 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: /p ul li Excellent writing and communication skills with strong attention to detail — youll need to explain system-behaviour gaps clearly to non-technical stakeholders /li li Experience writing, troubleshooting, and debugging advanced SQL queries /li li A track record of going beyond field-level mapping to understand em why /em two systems behave differently — validation logic, automation, calculated fields, relationship structures /li li Outstanding analytical and problem-solving skills, particularly diagnosing whether an issue is a data problem, a mapping problem, or a platform automation problem /li li Experience with ETL/ELT tools and data migration projects specifically (not just general pipeline building) /li li Programming experience in Python /li li Comfort working with ambiguity — migration requirements shift as discovery uncovers new system behaviour, and youll need to adapt scope calmly rather than treat it as scope creep /li /ul p Skills and experience wed love you to have... but if not? Well help you get there: /p ul li Experience migrating data into or out of CRM/billing platforms such as Salesforce /li li Understanding of how declarative platform automation silently alter data post-import /li li Experience in relational cloud-based database technologies like Snowflake, BigQuery, Redshift /li li Understanding of cloud computing security concepts /li li Familiarity with DBT and Databricks /li li Experience working in an agile environment /li li Experience working with AI tools (Claude Code, Cortex, etc.) to accelerate migration analysis /li /ul p br /p p strong Here’s a taste of the perks we roll out for our extraordinary team members: /strong /p p br /p p strong 25 Days of Holiday, plus 8 Bank Holidays: /strong We’re talking sun-soaked beaches, snow-capped mountains, or simply your favourite cosy spot at home. Take your well-deserved break with 25 days of holiday, plus those cherished bank holidays. /p p br /p p strong Birthday Bliss: /strong Your birthday isn’t just another day on the calendar; it’s YOUR day! Enjoy it in style with a day off, because at Citation, we believe in celebrating YOU. /p p br /p p strong Post-Wedding Bliss: /strong Newlyweds, we’ve got something special for you too! Extra weeks of holiday to bask in the glow of post-wedding happiness. /p p br /p p strong Growing Families: /strong We’re all about supporting our Citation family, and that includes expectant parents. Vouchers and special perks await to celebrate the newest addition to your family. /p p br /p p strong Healthcare cash plan: /strong Your well-being is our priority. That’s why we offer private healthcare to ensure your peace of mind and keep you feeling your best. /p p br /p