At a Glance
- Tasks: Lead data migrations, ensuring accuracy and integrity while modernising our platform.
- Company: Join Citation, a forward-thinking company revolutionising HR and Health services.
- Benefits: Enjoy 25 days holiday, your birthday off, gym discounts, and healthcare perks.
- Other info: Collaborative culture where your ideas matter and career growth is supported.
- Why this job: Make a real impact by solving complex data challenges in a dynamic environment.
- Qualifications: Experience with SQL, data migration, and a knack for problem-solving required.
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.
Data Migration Engineer (Contract) in Wilmslow employer: Citation Canada
Citation Canada is an exceptional employer that prioritises work-life balance and fosters a supportive culture, making it an ideal place for HR & Employment Law Consultants to thrive. With generous benefits such as 25 holiday days, a day off for your birthday, and private healthcare, employees are encouraged to grow both personally and professionally in a dynamic environment that values their contributions.
StudySmarter Expert Advice🤫
We think this is how you could land Data Migration Engineer (Contract) in Wilmslow
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Citation Canada before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Citation Canada.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Citation Canada.
We think you need these skills to ace Data Migration Engineer (Contract) in Wilmslow
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Citation Canada, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Citation Canada, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Citation Canada’s attention and show the tangible impact of your work.
How to prepare for a job interview at Citation Canada
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Citation Canada.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Citation Canada.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Citation Canada.
