Data Architect

Esure Group PLC; Little London; Hybrid; GBP 125,000 - 150,000; Full time

Job summary

A leading insurance company in the UK is seeking a Data Architect to join their innovative Data department. The role involves designing scalable cloud data platforms, integrating data from multiple sources, and enabling advanced AI and ML capabilities. Candidates should have extensive experience in data modelling, proficiency in SQL, and familiarity with tools like DBT and Databricks. A great opportunity for those looking to advance their career while engaging in impactful projects and flexible working arrangements.

Benefits

Competitive salary

Discretionary bonus scheme

25 days annual leave plus flexible days

Company-funded private medical insurance

Volunteering days

Qualifications

• Hands-on expertise in designing complex dimensional models.
• Extensive experience with fact and dimension tables in insurance domains.
• Familiarity with governance frameworks and pseudonymisation.

Responsibilities

• Design and manage scalable cloud data platforms, ensuring reliable performance.
• Integrate and model data from diverse sources for analytics.
• Build pipelines for AI and ML use cases, enabling vector search.

Skills

Proficiency in data modelling

Advanced SQL skills

Experience in building data pipelines

Knowledge of semantic layer design

Collaboration skills

Tools

DBT

Delta Live Tables

Databricks

Kafka

Airflow

AWS

Job description

Job Description

Engineers, data scientists and AI specialists to design and evolve scalable data platforms and modern data products that enable self‑service analytics, advanced modelling, and AI‑driven decision‑making across our insurance business.

We are currently looking for a Data Architect to join our forward‑thinking Data department. You'll work in a team of data engineers, analytics

Responsibilities

• Design and manage scalable cloud data platforms (Databricks on AWS) across development, staging, and production environments, ensuring reliable performance and cost efficiency.
• Integrate and model data from diverse sources—including warehouses, APIs, marketing platforms, and operational systems—using DBT, Delta Live Tables, and dimensional modelling to deliver consistent, trusted analytics.
• Enable advanced AI and ML use cases by building pipelines for vector search, retrieval‑augmented generation (RAG), feature engineering, and model deployment.
• Ensure security and governance through robust access controls, including RBAC, SSO, token policies, and pseudonymisation frameworks.
• Develop resilient data flows for both batch and streaming workloads using technologies such as Kafka, Airflow, DBT, and Terraform.
• Shape data strategy and standards by contributing to architectural decisions, authoring ADRs, and participating in reviews, data councils, and platform enablement initiatives.

Qualifications

• Proven, hands‑on expertise in data modelling, with a strong track record of designing and implementing complex dimensional models, star and snowflake schemas, and enterprise‑wide canonical data models.
• Proficiency in converting intricate insurance business processes into scalable and user‑friendly data structures that drive analytics, reporting, and scenarios powered by technology.
• Extensive experience designing fact and dimension tables across domains such as policy, quote, claims, pricing and fraud, ensuring consistency and alignment with business metrics.
• Deep practical knowledge of semantic layer design and implementation using DBT, SQL, and Delta Live Tables.
• Strong background in building high‑performance, scalable data models that support self‑service BI and regulatory reporting requirements.
• Direct exposure to cloud‑native data infrastructures (Databricks, Snowflake) especially in AWS environments is a plus.
• Experience in building and maintaining batch and streaming data pipelines using Kafka, Airflow, or Spark.
• Familiarity with governance frameworks, access controls (RBAC), and implementation of pseudonymisation and retention policies.
• Exposure to enabling GenAI and ML workloads by preparing model‑ready and vector‑optimised datasets.
• Demonstrated capability to collaborate successfully with interested parties in data engineering, analytics, architecture, and business teams.
• Advanced SQL skills and a keen focus on performance tuning, data integrity, and reusable compose patterns across data products.

Benefits

• Competitive salary that reflects your skills, experience and potential.
• Discretionary bonus scheme that recognises your hard work and contributions to esure's success.
• 25 days annual leave, plus 8 flexible days and the ability to buy and sell further holiday.
• Our flexible benefits platform is loaded with perks to choose from, so you can build a personal toolkit to support your health, wellbeing, lifestyle, and finances.
• Company‑funded private medical insurance for qualifying colleagues.
• Fantastic discounts on our insurance products!
• We'll elevate your career with hands‑on training, mentoring, access to our exclusive academies, regular career conversations, and expert partner resources.
• Our colleagues can use 2 volunteering days per year to support their local communities.
• Join our internal networks and communities to connect, learn, and share ideas with likeminded colleagues.
• We're a proud supporter of the ABI's 'Make Flexible Work' campaign and welcome you to ask about the flexibility you need.
• Our hybrid working approach also puts you in the driving seat of how and where you do your best work.
• See a full overview of our benefits here Reward and benefits | Esure Group PLC

We believe that diverse perspectives drive innovation, in turn enabling us to better serve our customers, community and build a stronger organisation. Our commitment to inclusion extends to every part of our business, from hiring practices to professional growth opportunities, ensuring equal access and support for all.