> Markdown version of [/jobs/ext/3019950-data-solutions-architect](https://www.wearedevelopers.com/jobs/ext/3019950-data-solutions-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Solutions Architect

- **Company:** Gallagher
- **Location:** London, UK
- **Contract:** Permanent contract
- **Skills:** Business Analytics Applications, Data Analysis, Architectural Patterns, Data Architecture, Data Dictionary, Data Governance, Data Normalization, Data Systems, Logical Data Models, Metadata, Data Streaming, Snowflake, Data Lineage, Data Analytics, Data Management
- **Published:** September 21, 2026
- **Apply:** https://www.apply4u.co.uk/jobs/data-solutions-architect/47840043

## About the Role

cloud data solutions Establish architectural patterns supporting data domains, data products, and reusable assets Data Modelling Skills & Experience Excellent understanding of conceptual, logical, and physical data modelling principles. Experience designing enterprise data models, reporting marts and business specific data products. Ability to model complex business relationships, hierarchies, and many-to-many relationships. Proficiency in dimensional modelling techniques including star schemas, snowflake schemas, facts, dimensions, and slowly changing dimensions (SCDs). Experience producing ERDs, logical data models, business data models, and data dictionaries. Strong knowledge of data normalization and denormalization techniques. Experience defining and documenting business rules, data lineage, data ownership, and metadata. Experience working with Master Data Management (MDM) solutions, including integrating mastered data into enterprise data models and analytical platforms.

## Description

cloud-based data platform that underpins the organisation's data and analytics capabilities. Working within a complex insurance environment, you will define the future-state data architecture, champion best practices in data modelling and governance, and help create a scalable, data-driven foundation for the business. Leveraging your expertise in Snowflake and dbt, you will enable the delivery of trusted, well-governed data that supports critical functions including analytics, pricing, risk, and strategic decision-making across the organisation. This role is based in London and you are expected to be in two days a week. How you'll make an impact Architecture & Strategy Define and implement the enterprise data architecture aligned to insurance business priorities (underwriting, claims, actuarial, finance) Design and optimise Snowflake-based data platforms, ensuring scalability, security, and cost efficiency Lead the transition from legacy policy, claims, and finance systems to modern, Understanding of data quality, reconciliation, and data governance considerations within data model design About You Previous experience as a Data Architect working in the the Insurance Industry is essential for this position. An understanding of insurance and brokerage data domains and their interdependencies is required. Experience modelling data across key business subject areas including: Client and customer Policy lifecycle Risk and coverage Claims management Finance, premium, commission, and brokerage transactions Insurer Regulatory, compliance, and conduct reporting Ability to develop enterprise data models that support operational processes, management information (MI), regulatory reporting, and analytics. Understanding of how data flows across policy administration, claims, finance, CRM, and external market systems. Ability to translate complex insurance business concepts into scalable and reusable data models. Design and govern dbt-based transformation frameworks