Cloud Data Architect for Insurance (Snowflake, dbt) – Hybrid

Arthur J. Gallagher & Co. (AJG); Greater London; Hybrid; GBP 90,000 - 130,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive benefits

Career development opportunities

Global reach with local impact

Collaborative culture

Job summary

Gallagher is seeking a Data Architect in London to design and deliver a modern cloud-based data platform powering analytics across underwriting, claims and finance. You will define the future-state architecture and champion governance in a complex insurance environment.

You will lead Snowflake-based platforms and dbt-based transformations, enabling trusted data, scalable models, and self-service analytics for senior stakeholders. Hybrid work is available in London.

Qualifications

• Experience as Data Architect in the Insurance industry.
• Ability to translate insurance concepts into scalable data models.
• Experience designing dbt-based transformation frameworks.
• Knowledge of data governance, lineage and metadata management.

Responsibilities

• Define enterprise data architecture aligned to insurance priorities (underwriting, claims, actuarial, finance).
• Design Snowflake-based data platforms with security, scalability and cost efficiency.
• Lead migration from legacy systems to modern cloud data solutions.
• Develop modular, testable dbt transformations and data models.
• Enable self-service analytics via semantic layers and dashboards.

Skills

Data architecture

Snowflake

dbt

Data modelling

Data governance

Cloud platforms

Stakeholder management

Insurance domain knowledge

ETL/ELT pipelines

CI/CD for data

Tools

Snowflake

dbt

Job description

Gallagher is seeking a Data Architect in London to design and deliver a modern cloud-based data platform powering analytics across underwriting, claims and finance. You will define the future-state architecture and champion governance in a complex insurance environment.

You will lead Snowflake-based platforms and dbt-based transformations, enabling trusted data, scalable models, and self-service analytics for senior stakeholders. Hybrid work is available in London.