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.
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 casesby building pipelines for vector search, retrieval-augmented generation (RAG), feature engineering, and model deployment.
* Ensure security and governancethrough robust access controls, including RBAC, SSO, token policies, and pseudonymisation frameworks.
* Develop resilient data flowsfor both batch and streaming workloads using technologies such as Kafka, Airflow, DBT, and Terraform.
* Shape data strategy and standardsby 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
Additional Information
* 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.
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 can come together. 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.
#J-18808-Ljbffr