Join to apply for the Data Architect role at Women in Data.

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 are 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.
• Flexible benefits platform with perks to support 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.
• Hands-on training, mentoring, access to exclusive academies, regular career conversations, and expert partner resources.
• Two volunteering days per year to support local communities.
• Internal networks and communities to connect, learn, and share ideas with colleagues.
• Flexible work options and hybrid working approach to fit your needs.
• And more; see the full overview of our benefits here

We are committed to creating an inclusive and diverse workplace where everyone feels valued, respected, and empowered. We celebrate individuality and create spaces where unique backgrounds and experiences come together. 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.

We are proud supporters of Women in Data. Connect, engage and belong to the largest free female data community in the UK – visit: www.womenindata.co.uk to join our community.

“Stay connected! Follow us on LinkedIn for updates on career opportunities and more.”

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Analyst
• Industries: Information Services