Data Modeler with Insurance and Snowflake

Overview of role • Support the organisation’s shift to a data-driven operating model by translating business needs into scalable data models • Build enterprise-scale, cloud-hosted analytics capabilities • Enable trusted, secure, and high-quality data for analytics/ BI • Work across insurance data domains (policy, claims, underwriting, finance) • Partner closely with data engineers, analysts, and business teams • Ensure data platforms meet performance, governance, and compliance needs • Operate within an Agile, collaborative delivery environment Craft & Skills • Design and maintain conceptual, logical, and physical data models • Apply star and snowflake schemas for analytical workloads • Analyse business requirements and translate them into data models • Contribute to enterprise data architecture and platform design • Work with data engineers to implement models using dbt • Optimise data models and tables for query performance • Collaborate across teams using Agile tools and ways of working • Ensure data models comply with governance and GDPR standards • Maintain data documentation, dictionaries, and lineage • Strong experience in the insurance data domain • Advanced data modelling expertise across multiple schemas • Hands-on experience with data warehousing and data lakes • Proficiency in SQL, including performance tuning • Experience with AWS data services (Athena, Redshift) • Understanding of analytical and transactional databases • Experience aligning data architecture with GDPR requirements • Strong communication skills with technical and non-technical stakeholders • Knowledge of dbt and Airflow for data pipelines is a bonus