Data Modeler

About the Company

The postholder will work as part of the CDAO based in Staines or Salford, collaborating with Data Engineers, Developers, and other Data Modellers. The role supports the Snowflake Data Platform and contributes to the delivery of enterprise data products and capabilities under the direction of the Senior Data Warehouse Development Manager (Modelling).

About the Role

The postholder will work mainly in one of our offices and not be required to undertake heavy lifting or manual work. Travel can be required to other office or customer/supplier sites should there be sufficient business justification.

Responsibilities

• Accountabilities and Activities
• 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 ensuring reuse and optimisation.
• 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.

Required Skills

• Tools & Technologies
• Snowflake
• Snowflake Cortex
• VS Code
• Azure DevOps (ADO Git)
• Ellie.ai
• Streamlit
• The postholder will be skilled to the following indicative SFIA competencies and levels:
• Data Modelling and Design (DTAN – Level 4): Investigates data requirements and applies appropriate data modelling techniques, including Data Vault 2.0 and dimensional modelling, to design and maintain scalable and reusable data structures. Provides guidance to others on the use and interpretation of models within the Snowflake platform.
• Database Design (DBDS – Level 4): Applies database design principles to develop and maintain efficient, scalable structures within Snowflake. Evaluates design options and implements physical and logical models to support analytics, reporting, and data product consumption.
• Data Engineering (DENG – Level 4): Designs, builds and maintains reliable and scalable ELT pipelines using modern, cloud-native approaches. Applies metadata-driven and automated techniques to support efficient data processing and platform optimisation.
• Testing (TEST – Level 3): Designs and executes test cases for data pipelines and models. Ensures outputs meet defined requirements and quality standards, identifying and reporting defects and risks.
• Release and Deployment (RELM – Level 4): Supports and executes release and deployment activities using structured processes and ADO Git-based CI/CD pipelines. Ensures repeatable, reliable, and controlled promotion of changes across environments.
• Application Support (ASUP – Level 3): Investigates, diagnoses, and resolves data platform issues. Works within agreed processes to maintain service levels and ensure continuity of data services.
• Security Administration (SCAD – Level 3): Supports implementation and maintenance of data security controls within Snowflake, including access management and adherence to data governance policies.
• Emerging Technology Monitoring (EMRG – Level 3/4): Maintains awareness of emerging capabilities such as Snowflake Cortex, AI-assisted development, and Circular Data Architecture, applying them where appropriate to improve data platform capabilities.

Qualifications

• Qualifications, Training and Experience
• At least 3/4 years experience in enterprise data modelling and data platform development.
• 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.

Preferred Skills

• Freedom of Action
• Autonomy: Works under general direction. Uses discretion in identifying and responding to issues and assignments within the Snowflake data platform. Determines when issues should be escalated.
• Influence: Interacts with and influences colleagues within the CDAO and engages with business stakeholders where required. Contributes ideas and supports the adoption of modern data practices including Data Vault and Circular Data Architecture.
• Complexity: Performs a range of work, sometimes complex and non-routine, including data modelling, pipeline development, Streamlit application development, and performance optimisation. Applies a structured and analytical approach to problem solving.
• Business Skills: Selects appropriately from applicable standards, methods, tools and applications from broader team pre-defined standards. Communicates fluently, orally and in writing, and can present information to both technical and non-technical audiences. Facilitates collaboration between stakeholders (with assistance when necessary) who share common objectives. Plans, schedules and monitors own workload to meet time and quality targets. Rapidly absorbs new information and applies it effectively. Develops awareness of technologies and their application and takes