Data Modeller
6 Month contract initially
Based: Hybrid/London - 2 days p/w
Rate: £Market rates p/d (via Umbrella company)
We have a great opportunity with a world leading organisation where you will be provided with all of the support and development to succeed. A progressive organisation where you can really make a difference. We have a great opportunity for a Data Modeller to join the team.
Key Responsibilities:
* 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.
* Ensure data quality by design-define integrity rules, reference/master data relationships, and validation checks embedded in pipelines.
* 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.
* Embed privacy and security requirements into models (PII classification, minimisation, masking, role based access, retention, and residency).
Key Skills & Experience:
* Proven experience delivering conceptual, logical, and physical data models for cloud data platforms, ideally GCP
* Strong hands on modelling for BigQuery (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)
* Strong knowledge of data governance: metadata management, lineage, stewardship, data quality rules, and critical data elements
* Proficiency with data modelling tools such as ER/Studio, PowerDesigner, ERWin, SQL Developer Data Modeler, or equivalent cloud native tools.
* Familiarity with GCP ecosystem integration (e.g., Cloud Storage, Dataflow/Dataproc, Pub/Sub) and how ingestion patterns influence modelling
This is an excellent opportunity on a great project of work, If you are looking for your next exciting opportunity, apply now for your CV to reach me directly, we will respond as soon as possible.
LA International is an award-winning partner of choice for many of the world's most influential companies and government organisations. Holding Enhanced Government Security Accreditation, we are recognised as the European market leader in the delivery of Security Cleared talent to organisations that demand the very highest levels of security, compliance and assurance.
A multiple award-winning organisation, having secured the prestigious Queens Award for Enterprise: International Trade over consecutive years. We are committed to fostering an inclusive, equitable and accessible workplace where everyone feels valued and supported. We welcome applications from all individuals, regardless of background or identity, and we encourage candidates who may not meet every listed requirement to still apply. If you require any adjustments or support during the recruitment process, please let us know and we will work with you to ensure a fair and accessible experience.
Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.
