Data Architect

Company Description
Ready to join a team that's leading the way in reshaping the future of insurance? Here at esure Group, we are on a mission to revolutionise insurance for good

We've been providing Home and Motor Insurance since 2000, with over 2 million customers trusting us to keep them covered through our esure and Sheilas' Wheels brands. With a bold dedication for digital innovation, we're transforming the way the industry operates and putting customers at the heart of everything we do.

Having completed our recent multi-year digital transformation, we're now leveraging advanced technology and data-driven insights alongside exceptional service, to deliver personalised experiences that meet our customers ever-changing needs today and in the future.

Job Description
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 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.

What you'll do:

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
What we'd love you to bring:

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

Additional Information

What's in it for you?:

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 50% off for yourself and spouse/partner and 10% off for direct family members.

We'll elevate your career with hands-on training, mentoring, access to our exclusive academies, regular career conversations, and expert partner resources.

Driving good in the world couldn't be more important to us. 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.

And much more; See a full overview of our benefits here