Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Data Solutions Architect role.
Rezi rewrites your resume against Gallagher's job description. Free.
Tailor your resume to this Data Solutions Architect role.
Rezi rewrites your resume against Gallagher's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Data Solutions Architect posting at Gallagher — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Data Solutions Architect posting at Gallagher — free, in seconds.
About the Role
As our Data Architect, you will play a key role in designing and delivering a modern 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.
Responsibilities
- 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 cloud data solutions
- Establish architectural patterns supporting data domains, data products, and reusable assets
- Design and govern dbt-based transformation frameworks, including modular, testable, and well-documented models
- Establish best practices for ELT pipelines, lineage, and dependency management
- Enable self-service analytics through curated semantic and presentation layers
- Drive automation, CI/CD, and testing across the data lifecycle
Requirements
- Previous experience as a Data Architect working in the Insurance Industry is essential
- Understanding of insurance and brokerage data domains and their interdependencies is required
- 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
- Commercial awareness of insurance value chains and drivers
- Strategic but pragmatic—able to balance architecture vision with delivery reality
- High attention to data accuracy, auditability, and compliance
- Excellent stakeholder management at senior and executive level
- Comfortable operating across hands-on delivery and architectural oversight
Skills
- Snowflake
- dbt
- Conceptual, logical, and physical data modelling principles
- Enterprise data models, reporting marts and business specific data products
- Complex business relationships, hierarchies, and many-to-many relationships
- Dimensional modelling techniques including star schemas, snowflake schemas, facts, dimensions, and slowly changing dimensions (SCDs)
- ERDs, logical data models, business data models, and data dictionaries
- Data normalization and denormalization techniques
- Business rules, data lineage, data ownership, and metadata
- Master Data Management (MDM) solutions
- Data quality, reconciliation, and data governance
- Client and customer data modelling
- Policy lifecycle data modelling
- Risk and coverage data modelling
- Claims management data modelling
- Finance, premium, commission, and brokerage transactions data modelling
- Insurer data modelling
- Regulatory, compliance, and conduct reporting data modelling
Location
- London
Work Type
- Hybrid
- Full-time
Experience Level
- Senior
Benefits
- Competitive compensation
- Comprehensive benefits programs designed to support your well-being
- Career development opportunities and ongoing learning
- A collaborative, people-first culture with accessible leadership
- The opportunity to do meaningful work with global reach and local impact
About the Company
- At Gallagher, we help clients face risk with confidence because we believe that when businesses are protected, they’re free to grow, lead, and innovate.
- You’ll be backed by our digital ecosystem: a client-centric suite of consulting tools making it easier for you to meet your clients where they want to be met.
- Advanced data and analytics providing a comprehensive overview of the risk landscape is at your fingertips.
- Here, you’re not just improving clients' risk profiles, you’re building trust.
- You’ll find a culture grounded in teamwork, guided by integrity, and fueled by a shared commitment to do the right thing.
- We value curiosity, celebrate new ideas, and empower you to take ownership of your career while making a meaningful impact for the businesses we serve.
- If you’re ready to bring your unique perspective to a place where your work truly matters; think of Gallagher.
Equal Opportunity
- Gallagher is an affirmative action/equal opportunity employer (Minorities/Females/Veterans/Disabled)