London
Opportunity for Data Modeller / Data Designer • This role empowers you to shape end-to-end data ecosystems—accelerating delivery, enhancing data clarity, strengthening operational resilience, and driving organisations toward a more insight-rich, data-enabled future., • You will define the data blueprints and foundational models that underpin how customers in dynamic, data-intensive industries operate, scale, and innovate., • You will design robust, future-ready data models that enable seamless integration, advanced analytics, and AI-driven decision making across complex digital transformation programmes. Essential Skills & Experience - Data Modeller / Data Designer • Experienced Data Modeller, Data Designer, Data Specialist or similar, • Proven experience delivering conceptual, logical, and physical data models for cloud data platforms, ideally GCP, • Strong hands-on modelling for Big Query (analytical/columnar patterns, denormalization strategy, partitioning & clustering considerations), • Expertise in data modelling approaches: 3NF, dimensional (Kimball), Data Vault, and hybrid patterns for Lakehouse designs, • Maintain versioned model artefacts (ERDs, schema scripts, JSON/YAML specs) and change logs; manage controlled evolution of models., • Ability to translate banking domain requirements (Customer, Accounts, Payments, Credit, Risk, Finance) into scalable canonical models, • Strong understanding of BigQuery performance and cost optimisation impacts driven by modelling choices (query patterns, storage, scan costs), • Experience designing data products for analytics and reporting with trusted definitions (facts, dimensions, SCD, conformed dimensions), • Proficiency with data modelling tools such as ER/Studio, PowerDesigner, ERWin, SQL Developer Data Modeler, or equivalent cloud-native tools. Key Responsibilities - Data Modeller / Data Designer • Define and maintain conceptual, logical, and physical data models that accurately reflect business processes and support analytics, AI/ML, and operational needs., • Translate business requirements into robust data entities, attributes, relationships, and constraints; ensure traceability from requirements to models., • Establish and enforce GDM modelling standards and naming conventions (e.g., normalization, dimensional/star/snowflake patterns, data vault where appropriate)., • Design dimensional models (facts, dimensions, hierarchies, slowly changing dimensions) for BI/analytics and performance at scale., • Create and manage canonical data models and semantic layers to enable consistent metrics and self-service analytics across domains., • Optimise models for performance and cost (partitioning, clustering, indexing, compression, surrogate keys, distribution strategies)., • Drive data integration design across sources (CDC, event streaming, APIs), mapping source-to-target, resolving conflicts, and handling historical changes., • Support AI/ML readiness by modelling features, aggregations, and histories; collaborate on feature stores and model input/output schemas.