IntroductionWelcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what’s right. We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive. Whether you join us in a client-facing role or as part of our brokerage division, our benefits and HR consulting division, or our corporate team, you’ll have the opportunity to grow your career, make an impact, and be part of something bigger. OverviewWe're looking for an experienced Technical Data Analyst to join our Data Technology team. This is an exciting opportunity to help shape and deliver high-quality data products that support reporting, analytics, regulatory requirements and business decision-making across our organisation.Working at the intersection of business and technology, you'll partner with Data Engineers, Architects, Product Owners and key stakeholders to analyse complex insurance data, develop robust data models and ensure trusted datasets are delivered across our modern cloud data platform.This role is ideal for someone who combines technical expertise with a genuine interest in solving business problems through data. You'll be comfortable working hands-on with SQL, Snowflake and dbt, while translating business requirements into scalable technical solutions. We other hybrid working and the expectations is to be in London 3 days a week.How you'll make an impactData Analysis & ModellingAnalyse complex insurance datasets across policy, claims, underwriting, finance and regulatory domains.Develop logical and physical data models to support reporting, analytics and operational processes.Define, document and maintain business and technical data definitions.Conduct data investigations and root-cause analysis to identify issues and support remediation.Perform source-to-target mapping and validate transformation logic across multiple systems.Data Platform DevelopmentDevelop and maintain data transformation pipelines using dbt.Build, test and optimise scalable data models within Snowflake.Collaborate with Data Engineers to improve data platform performance, reliability and scalability.Data Quality & GovernanceDesign and execute data quality checks, reconciliations and validation controls.Validate source-to-target mappings and transformation requirements.Support data governance activities, standards and metadata management practices.Investigate and resolve data quality issues across multiple source systems.Technical DeliveryTranslate business requirements into effective data solutions.Contribute to the design and delivery of data products and analytical services.Collaborate with technical and business teams to ensure data products are fit for purpose and aligned to organisational objectives.SQL skills with the ability to develop efficient, optimised queries.Proven experience developing data transformations and data models using dbt.An understanding of dimensional modelling and data warehousing principles.Experience working with ETL/ELT processes and modern cloud-based data architectures.Knowledge of data lineage, metadata management and data quality frameworks.Azure Data Factory.Power BI semantic modelling.Data testing and quality assurance frameworks.Experience working within a Data Mesh or Data Product operating model.Compensation and benefitsAt Gallagher, we believe supporting our colleagues goes far beyond the role itself. Competitive compensationComprehensive 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. If your past experience doesn’t align perfectly, we encourage you to join our Talent Community to stay connected to additional career opportunities. 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. Gallagher is an affirmative action/equal opportunity employer (Minorities/Females/Veterans/Disabled)
Data Technical Analyst in London employer: Arthur J. Gallagher & Co.
At Gallagher Benefit Services, we pride ourselves on being an exceptional employer that champions a collaborative and people-first culture. As a Business Development Director in our Change & Transformation practice, you'll enjoy competitive compensation, comprehensive benefits, and ample opportunities for career development while making a meaningful impact on businesses and their employees. Join us in a dynamic environment where your ideas are valued, and you can thrive alongside a community of trusted experts and bold explorers.
