Senior Data & AI Architect: Snowflake, dbt & Governance

LGC Limited

Greater London

On-site

GBP 110,000 - 150,000

Full time

11 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

LGC Limited is seeking an experienced Senior Data & AI Architect to lead the day-to-day enterprise data architecture, reporting to the Head of Enterprise Data & AI Architecture. The role blends traditional data architecture with hands-on Snowflake-driven design and semantic modeling.

You will shape the enterprise ontology, govern data products for AI, and guide multiple domains across ERP, CRM, Finance, Supply Chain and Laboratory Systems. Strong SQL, dbt and Snowflake experience are essential.

Qualifications

  • Proven experience in Enterprise Data Architecture in a large, multi-system environment.
  • Direct engagement with source systems (ERP, CRM, Finance, Lab Systems) to translate business data requirements into design.
  • Strong conceptual, logical, relational and dimensional data modelling skills.
  • Hands-on experience with Snowflake or similar cloud data platform.
  • Hands-on experience with dbt for transformation design, testing and lineage.
  • Advanced SQL across Snowflake, SQL Server or Oracle; experience building analytical data models.
  • Knowledge of ETL/ELT, data integration and medallion or lakehouse architectures.
  • Experience designing semantic models and enterprise ontologies; ability to support analytics and AI within governed frameworks.
  • Experience producing architecture documentation, data models, integration blueprints and technical designs.
  • Ability to explain complex concepts clearly to technical and non-technical stakeholders.

Responsibilities

  • Act as data architecture representative in ERP, CRM, Finance, Supply Chain and Lab Systems programmes, profiling source data before integration.
  • Create and maintain conceptual, canonical and semantic data models for key domains (Product, Customer, Supplier, Finance, Employee, Quality).
  • Produce reference architectures, integration blueprints, data contracts and modelling standards for ingestion and ELT patterns.
  • Design and guide Snowflake data models, semantic views and consumption models; test dbt transformations for grain, joins and metrics.
  • Review data engineering designs for conformance with architectural standards and contribute to guardrails and best practices.
  • Help develop the enterprise ontology by linking source metadata to governed business concepts and defining consistent semantics.
  • Design governed data products and models to enable AI applications including RAG and GraphRAG.
  • Drive data quality and governance through metadata management, MDM designs and quality controls.
  • Translate business requirements into practical architectural designs and documentation; liaise with stakeholders.

Skills

Enterprise data architecture
Snowflake
dbt
SQL
ETL/ELT
Data modelling
Data governance
Communication
Architecture documentation
Ontology/semantic models

Tools

Snowflake Studio
dbt
MuleSoft

Job description

LGC Limited is seeking an experienced Senior Data & AI Architect to lead the day-to-day enterprise data architecture, reporting to the Head of Enterprise Data & AI Architecture. The role blends traditional data architecture with hands-on Snowflake-driven design and semantic modeling.

You will shape the enterprise ontology, govern data products for AI, and guide multiple domains across ERP, CRM, Finance, Supply Chain and Laboratory Systems. Strong SQL, dbt and Snowflake experience are essential.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data & AI Architect — Snowflake & dbt Lead
Senior Data & AI Architect — Snowflake & dbt Lead

LGC • Greater London

On-site
GBP 90,000 - 135,000
Data Architect (Snowflake) for AI & Analytics
Data Architect (Snowflake) for AI & Analytics

AND Digital Limited • England

On-site
GBP 90,000 - 130,000
25 days holiday
Pension 6% + 2% employer contribution
Healthcare cover by Aviva
+5
Senior Snowflake Data Architect - Cloud Data Platform & AI
Senior Snowflake Data Architect - Cloud Data Platform & AI

And Digital • Greater London

On-site
GBP 90,000 - 130,000
25 days holiday
Pension: 6% matched by AND Digital
Aviva healthcare cover
+5
Senior Data Architect — Snowflake, Cloud & AI Solutions
Senior Data Architect — Snowflake, Cloud & AI Solutions

Capgemini • England

Hybrid
GBP 70,000 - 110,000
Disability Confident Employer
Great Place to Work for Wellbeing
Senior Snowflake Data Architect | Governance & Data Quality
Senior Snowflake Data Architect | Governance & Data Quality

UST • Greater London

Hybrid
GBP 120,000 - 180,000
Senior Information Architect — AI‑Driven Data & Ontology
Senior Information Architect — AI‑Driven Data & Ontology

Northern Trust Corp • Greater London

On-site
GBP 90,000 - 130,000
Snowflake Data Architect: Cloud Data Strategy & Governance
Snowflake Data Architect: Cloud Data Strategy & Governance

And Digital • West of England

On-site
GBP 80,000 - 120,000
Snowflake Data Architect - Enterprise Cloud Platform Leader
Snowflake Data Architect - Enterprise Cloud Platform Leader

And Digital • West of England

Hybrid
GBP 95,000 - 135,000
25 days holiday + flexible bank
Pension: 6% of salary paid by AND with
Aviva healthcare coverage
+5
Senior Data & AI Architect: Scalable Cloud Platforms
Senior Data & AI Architect: Scalable Cloud Platforms

LGC Group • England

On-site
GBP 110,000 - 170,000
Senior Snowflake Architect - Enterprise Data & AI Cloud
Senior Snowflake Architect - Enterprise Data & AI Cloud

Falcon Smart IT (FalconSmartIT) • City of Edinburgh

Hybrid
GBP 120,000 - 180,000