Текст заказа
Senior Data Integration & Migration Analyst
Contract | 6 months | £600/day Inside IR35 | \[Location / hybrid pattern\]
This isn’t about moving data into a warehouse for reporting. You’ll take several messy source systems, including legacy databases, an existing CRM and live API feeds, and bring them together into one clean target CRM. The data has to arrive accurate, consistent and ready for the business to use from day one.
If you’ve done this kind of migration before, with inconsistent schemas, duplicate customers and fields that mean different things in different systems, you’ll know why we’re being specific.
The role
Our client is running a large-scale CRM migration alongside live API integrations, with a System Integrator partner delivering the build. You’ll be the data expert in the middle of it. You’ll know the source data better than anyone, find problems before they cause a failed load, and give the SI team clear answers when they’re stuck on mapping or logic.
What you’ll be doing
* Profiling source data: auditing legacy schemas and raw data to find structural problems, mismatches and gaps early
* Cleansing at scale: designing automated rules and pipelines to remove duplicates, standardise formats and enrich weak records
* Bringing multiple sources together: consolidating data from CRM, legacy databases and API streams into clean target feeds
* Supporting the SI partner: acting as the main technical expert on schema, mapping and data logic questions
* Fixing integration issues: working with integration engineers on load failures, pipeline problems and API transformation errors
What you’ll bring
* Proven experience migrating data from multiple source systems into a single target system (essential)
* Strong source data profiling and automated cleansing experience
* Advanced SQL and Python
* Hands-on experience with CRM systems and their data models
* A track record of working with System Integrator partners on delivery programmes
Nice to have
* Insurance domain experience
* Databricks
* Creatio CRM
Why this one
It’s a high-visibility role where you’ll own the data side of the migration, not just carry out tickets. If you enjoy turning messy legacy data into something clean, you’ll have plenty to work with.
Jono Paisley | Recruitment Consultant @ TRIA