At a Glance
- Tasks: Design and deliver a modern cloud-based data platform for analytics and risk management.
- Company: Gallagher, a leader in risk management with a collaborative culture.
- Benefits: Competitive pay, comprehensive benefits, career development, and a people-first environment.
- Other info: Flexible working arrangements and a commitment to inclusivity.
- Why this job: Make a real impact in the insurance industry while shaping data architecture.
- Qualifications: Experience as a Data Architect in insurance and strong data modelling skills.
The predicted salary is between 72000 - 88000 £ per year.
Introduction
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.
Overview
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.
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 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.
- 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, 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
- 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
Compensation and benefits
At Gallagher, we believe supporting our colleagues goes far beyond the role itself. For more information, visit our Benefits page.
- 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
At Gallagher, we are dedicated to building an inclusive and authentic workplace.
Gallagher is an affirmative action/equal opportunity employer (Minorities/Females/Veterans/Disabled)
Although this role is listed as full‑time, if you're in a job‑share partnership, work reduced hours, or have any other flexible arrangement, please still get in touch.
We will also offer reasonable adjustments to the recruitment process if required, so please let us know
#J-18808-Ljbffr
Data Solutions Architect employer: Arthur J. Gallagher & Co. (AJG)
Gallagher Benefit Services is an exceptional employer that fosters a collaborative and innovative work culture in the heart of London. With a strong emphasis on employee growth, we offer comprehensive training and development opportunities, ensuring our team members thrive in their careers while contributing to meaningful financial insights that drive business success. Join us to be part of a dynamic team where your contributions are valued and rewarded.
Contact Details:
Arthur J. Gallagher & Co. (AJG) Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Data Solutions Architect
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Arthur J. Gallagher & Co. (AJG)!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Solutions Architect at Arthur J. Gallagher & Co. (AJG).
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Arthur J. Gallagher & Co. (AJG).
✨Apply Directly through Our Website
When you find a suitable opening like Data Solutions Architect at Arthur J. Gallagher & Co. (AJG), make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Solutions Architect
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Arthur J. Gallagher & Co. (AJG), your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Arthur J. Gallagher & Co. (AJG). Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Arthur J. Gallagher & Co. (AJG)
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Arthur J. Gallagher & Co. (AJG)!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
