Data Migration Consultant

Key responsibilities Profile and map the Co-Pilot data model to Navigator field by field agree profiling and cleansing rules with the data owners. Build the ETL once as a reusable, version-controlled pipeline, then execute it in waves. Run three to four incremental trial loads at production scale in pre-production, each bigger and closer to the real thing. Reconcile every load record counts, financial and compliance spot checks and carry a named business sign-off per data set. Scope the pipeline to whichever archive option Whitbread chooses: foundation and seed data only for a read-only archive plus transaction history if history is migrated into Navigator or a one-way transfer to low-cost storage. Execute the final delta load at cutover from the rehearsed runbook. Essential skills and experience Three-Six years or more data-engineering migration, with strong ETL design and SQL, ideally on Azure Data services. Demonstrable production-scale migration experience, including trial loads, reconciliation and business sign-off. Comfort with both relational and document targets and with data cleansing and mapping from a messy source. Discipline around evidence: reconciliation packs, not assurances. Desirable Migration off Nintex K2 or a comparable low-code platform. Experience of compliance records-retention data for example accident and RIDDOR records.