Data Migration Specialist

Whitehall Resources require a Data Migration Specialist to work with a key client on a 3 month initial contract.

*This role will involve on site work in Coventry 2-3 days per week.

*Inside IR35.

Data Migration Specialist

The Role
We are seeking for a highly skilled and experienced Data Migration Lead to manage the end-to-end migration of large-scale datasets (1000TB+) from Legacy systems into a modern cloud platform based on Azure Databricks and Microsoft Fabric. This role is pivotal to transforming our data landscape and ensuring business continuity across asset management, and SCADA systems with prior experience in the utilities or telemetry/SCADA systems domain is a strong plus.

Your responsibilities:
. Design and execute comprehensive data migration strategies, including ETL pipelines, validation frameworks, and data quality controls.
. Oversee the integration of Legacy systems (SCADA, SAP PM, Oracle ODS, etc.) into Azure Databricks, ensuring Real Time data flow for spatial, time-series, and IoT data.
. Partner with cloud engineers, data architects, and governance leads to build scalable, secure, and compliant data solutions.
. Act as a bridge between business and technical stakeholders, translating requirements into actionable migration plans aligned with business goals.
. Facilitate workshops, training sessions, and user onboarding for internal teams on new tools, platforms, and AI/MDM practices.
. Ensure all migration efforts comply with data governance and regulatory requirements, including GDPR and internal quality standards.
. Monitor and resolve data quality issues proactively, ensuring data completeness, consistency, and reliability throughout the migration life cycle.
. Lead and support multidisciplinary data engineering teams, offering guidance, removing roadblocks, and ensuring project success.
. Implement risk mitigation strategies, including rollback plans, data recovery protocols, and contingency testing.
. Apply industry-specific knowledge of water utilities, SCADA systems, and telemetry data to design tailored, future-ready data solutions.

Your Profile

Essential skills/knowledge/experience:
. Data migration plan and strategy including pre-migration, migration and post migration
. Data validations in pre-migration, migration and post migration
. Data migration risk and mitigation
. Data rollback procedures
. Azure Data Factory, Azure Databricks, Fabric
. ADLS, Azure Blob, Azure SQL DB, Cosmos DB, Delta Lake, Oracle DB
. Experience with unstructured data
. Data Mapping, ETL Mapping
. Data Governance (Purview, Databrick Unity Catlog)
. MDM (Profisee, Informatica)

Desirable skills/knowledge/experience:
. MDM (Informatica)
. Data Governance (Collibra)
. Python, Kusto
. Utilities experience
. Experience with SCADA, eSCADA, telemetry, SAP PM, GIS
. Azure Event Hub, Azure Kafka, Azure IoT Hub, ADX

All of our opportunities require that applicants are eligible to work in the specified country/location, unless otherwise stated in the job description.

Whitehall Resources are an equal opportunities employer who value a diverse and inclusive working environment. All qualified applicants will receive consideration for employment without regard to race, religion, gender identity or expression, sexual orientation, national origin, pregnancy, disability, age, veteran status, or other characteristics.