teamtailor
Data Analytics Engineer
Citation Group
Wilmslow, GBR
Full-time
Mid
Hybrid
Discovered Today
SQLPythonETLELTSalesforceChargebee
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
SQLPythonETL
Key Skills for This Role
SQLPythonETLELTSalesforceChargebee
Full Job Posting
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)
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Citation Group
3rd Line Engineer
Wilmslow, GBR
Discovered TodayFull-time
1st Line Support Analyst
Wilmslow, GBR
Discovered 3 days agoFull-time
AI Architect
Wilmslow, GBR
Discovered 1 weeks agoFull-time
Health & Safety Advisor - Reading
Reading, GBR
Discovered 2 weeks agoFull-time
Product Owner
Wilmslow, GBR
Discovered 2 weeks agoFull-time
Sales Trainer
Glasgow, GBR
Discovered 2 weeks agoFull-time
Sales Executive
Wilmslow, GBR
Discovered 2 weeks agoFull-time
Sales Executive
Glasgow, GBR
Discovered 2 weeks agoFull-time