Data Design Lead
Position: Data Design Architect
Location: Hybrid (Southampton – one day a week or once every two weeks)
Duration: 6 months
Engagement mode: Contract Role
Experience Level: 7+ Years
Role Overview
We are seeking an experienced Senior / Lead Data Design Architect to take ownership of complex data modelling and architecture initiatives. The successful candidate will bring deep technical expertise in modelling high-complexity data alongside a strong grasp of data quality, lifecycle management, and modern data platform capabilities. This is a hands-on role for a meticulous, collaborative practitioner who can shape data design standards and deliver robust, scalable solutions across both tabular and non-tabular data domains.
Key Responsibilities
• Lead the design and delivery of conceptual, logical, and physical data models for high-complexity, enterprise-scale data environments.
• Define and maintain data architecture standards, patterns, and best practices across the organisation.
• Work across structured, semi-structured, and non-tabular datasets, including event-based and streaming data sources.
• Establish and embed data quality management frameworks, including profiling, validation, monitoring, and remediation processes.
• Own end-to-end data lifecycle management — from ingestion and curation through to archival, retention, and decommissioning.
• Write, optimise, and review advanced SQL to support modelling, validation, and analytical use cases.
• Partner closely with data engineers, analysts, platform teams, and business stakeholders to translate requirements into resilient data designs.
• Contribute to governance, metadata management, and access control strategies on the data platform.
• Mentor and provide technical guidance to junior data designers, modellers, and engineers.
Required Skills & Experience
• 7+ years of experience as a Data Modeller or Data Architect, with a proven track record of modelling high-complexity data in enterprise environments.
• Demonstrable experience implementing and managing data quality processes and frameworks.
• Strong background in data lifecycle management, covering ingestion, storage, transformation, retention, and archival.
• Hands-on experience working with non-tabular data and event-based data processing.
• Advanced-level SQL querying skills, including performance tuning and complex transformations. • Strong attention to detail with a disciplined approach to documentation, standards, and design quality.
• A collaborative working style with the ability to engage effectively with technical and non-technical stakeholders.
Desirable Experience
• Working knowledge of Databricks Unity Catalog, particularly around metadata and system tables. • Understanding of row-level security (RLS) and attribute-based access control (ABAC) within modern data platforms.
What We're Looking For A pragmatic, detail-driven data design leader who combines deep modelling expertise with a collaborative mindset. You will be equally comfortable shaping high-level architecture and rolling up your sleeves to validate data at the column level — and you will bring the rigour needed to embed quality and lifecycle discipline across complex, evolving data estates.