Lead Data Modeler

Role: Lead Data Modeler

Location: Remote/Work From Home (UK)

Contract: Initial 3 Months

The Opportunity

We are looking for an experienced Lead Data Modeler to join an organisation undertaking a significant data transformation and modernisation programme.

This is a hands-on, technically focused consulting role, working across complex data environments to help bridge the gap between Legacy systems and modern data platforms.

The successful consultant will bring extensive expertise in data modeling, data processes and data integration, with the ability to understand existing data landscapes, identify challenges and design practical solutions that support the evolution of modern data environments.

Key Responsibilities

• Analyse and understand complex Legacy data environments, structures and processes.
• Design and develop robust data models to support modernisation and integration initiatives.
• Define and improve data processes, workflows and transformation methodologies.
• Lead the design and implementation of data integration solutions connecting Legacy technologies with modern data storage platforms.
• Assess existing data structures, dependencies and relationships to identify opportunities for optimisation.
• Support data migration, transformation and modernisation activities, ensuring data integrity and consistency.
• Work closely with technical architects, engineers and business stakeholders to translate complex data requirements into practical solutions.
• Provide specialist technical guidance on data architecture, integration patterns and best practices.

Essential Experience

• Significant experience in specialist Data Consultant or Data Modeling roles.
• Strong expertise in conceptual, logical and physical data modelling.
• Extensive understanding of data structures, data flows, data mapping and data transformation.
• Proven experience integrating Legacy databases and storage technologies with modern data platforms.
• Strong knowledge of relational databases, SQL and modern data storage architectures.
• Ability to work across complex, disparate data environments and understand end-to-end data dependencies.
• Experience supporting data modernisation, migration or transformation programmes.
• Excellent analytical and problem-solving skills, with the ability to operate independently in a consulting capacity.

Desirable Experience

• Exposure to cloud-based data technologies, particularly Azure & AWS
• Experience with modern data platforms such as Databricks, Snowflake or Microsoft Fabric.
• Understanding of data warehousing, data lakes architectures.
• Experience working with Legacy enterprise systems and complex integration environments.
• Knowledge of data governance