Data Modeller

• 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)., Salary, remote work... Define all the criteria that are important to you.

• Get discovered Recruiters come directly to look for their future hires in our CV library.

• Join a community Connect with like-minded tech and IT professionals on a daily basis through our forum.

• 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

6 Month contract initially Based: Hybrid/London - 2 days p/w Rate: £Market rates p/d (via Umbrella company)

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. Discover LA International Computer Consultants Ltd Stoke-on-Trent, United Kingdom 100 - 249 employees Recruitment agency Whether you're aiming for your next contract or permanent role, we connect you to opportunities across the digital and technology landscape in both public and private sectors. With eight specialist Divisions and a single-site team of highly experienced consultants, you get personalised support backed by deep sector expertise. Already security-cleared? Our in-house Security Vetting Department can transfer your clearance quickly and smoothly. New to cleared environments? Our Enhanced Government Security Accreditation allows us to sponsor new clearances, opening doors to career-defining roles. Operating across 90 countries and 5 continents, and supporting candidates for over 40 years, we don't just help you find a job, we help you build a career.