Data Architect

Esure Group PLC; South Chailey; Hybrid; GBP 125,000 - 150,000; Full time

Job summary

A leading insurance technology company in the United Kingdom seeks an experienced data specialist to design and manage scalable cloud data platforms. This role involves integrating data from diverse sources, enabling advanced AI and ML capabilities, and developing resilient data flows. The ideal candidate will have proven expertise in data modelling, particularly within the insurance sector, along with direct experience in AWS environments. This position offers a competitive salary and hybrid working arrangements.

Benefits

Competitive salary

Discretionary bonus scheme

25 days annual leave, plus 8 flexible days

Private medical insurance

Discounts on insurance products

Mentoring and career development

Volunteering days

Access to internal networks and communities

Qualifications

• Proven expertise in data modelling with experience in designing complex dimensional models.
• Proficiency in translating insurance processes into user-friendly data structures.
• Background in building scalable data models for BI and regulatory reporting.
• Hands-on experience with cloud-native data infrastructure, particularly in AWS environments.

Responsibilities

• Design and manage scalable cloud data platforms (Databricks on AWS).
• Integrate data from various sources using DBT and Delta Live Tables.
• Enable AI and ML use cases by building pipelines for data processing.
• Develop data flows for batch and streaming workloads using Kafka and Airflow.

Job description

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 complex insurance business processes into scalable and user‑friendly data structures that drive analytics, reporting and scenario modelling.
• 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.
• Experience 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 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 & Perks

• Competitive salary that reflects your skills, experience and potential.
• Discretionary bonus scheme recognising your hard work and contributions to Esure’s success.
• 25 days annual leave, plus 8 flexible days and the ability to buy and sell additional holiday.
• Company‑funded private medical insurance for qualifying colleagues.
• Fantastic discounts on our insurance products.
• Hands‑on training, mentoring, access to exclusive academies, regular career conversations and expert partner resources.
• 2 volunteering days per year to support local communities.
• Access to internal networks and communities to connect, learn and share ideas with likeminded colleagues.
• Hybrid working approach with flexibility to choose how and where you work best.
• Inclusion commitment: equal access and support for all, with dedicated hiring and professional growth opportunities.

Inclusion & Diversity

We empower diverse perspectives to drive innovation, better serve our customers and strengthen our organisation. Our commitment spans hiring practices, professional growth, and supporting all employees.