Build and maintain end-to-end ELT pipelines using scalable, metadata-driven frameworks and patterns.
Develop high-quality Data Vault 2.0 models (Hubs, Links, Satellites), demonstrating strong understanding of modelling principles and standards.
Design and implement dimensional models (star schemas, marts) to support efficient analytics and reporting use cases.
Investigate and resolve SQL performance issues.
Support Circular Data Architecture product feature roadmap.
Build and enhance the Circular Data Architecture product features.
Create data marts and data products for analytics consumption.
Resolve data issues through to source for internal customers.
Maintain documentation and metadata using tools such as Ellie.ai.
Contribute to quality assurance, testing and reviews.
Proactively identify and manage risks and issues.

At least 3/4 years experience in enterprise data modelling and data platform development.
Conceptual data modelling.
Proven hands-on experience with Data Vault 2.0, including: Designing Hubs, Links, and Satellites
Applying business keys and hashing approaches.
Understanding of loading patterns and historisation.
Strong experience in dimensional modelling, including: Star schema design
Fact and dimension modelling.
Performance and usability optimisation for analytics.
Experience applying the right modelling technique for the right use case (e.g., Data Vault vs dimensional vs 3NF).
Experience working with Snowflake or similar cloud data platforms.
Experience building ELT pipelines using SQL and modern data engineering practices.
Familiarity with metadata-driven development and modelling tools (e.g., Ellie.ai).
Experience working with version control and CI/CD tooling (ADO Git).
Strong analytical and problem-solving skills.
Ability to communicate modelling approaches clearly to both technical and non-technical stakeholders.
Experience of full development lifecycle and modern delivery approaches.
Ability to manage workload effectively in a dynamic environment.
Experience in working in a team responsible for both build and run of data products.
Experience in contributing to product roadmap and defining product features and backlog items.

25 days holiday, increasing through length of service, with option to buy or sell
Bupa health insurance as a benefit in kind
An enhanced pension plan and life insurance
Onsite gyms or local discounts where no onsite gym available
Various other benefits and online discounts

Data Modeller / Data Engineer

Key skills