Join to apply for the Senior Data Engineer role at Gallagher UK
Introduction
Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a legacy of trust and triumph in the dynamic world of risk management.
Overview
We are seeking a highly skilled Senior Data Engineer to drive the design and delivery of high-quality, reliable data solutions. This role requires a deep understanding of modern data engineering best practices, strong problem-solving skills, and the ability to work collaboratively with cross-functional teams.
This role will be based from our Bournemouth office with a hybrid working model; you will be required to work in the office two days a week and be within a commutable distance to Bournemouth.
Key Responsibilities
1. Architecture & Design: Develop detailed technical designs and recommend high-availability data warehouse architectures.
2. Data Management: Oversee data integrity, validation, and transformation to ensure accuracy and optimize data retrieval and storage efficiency.
3. Automation & Scalability: Develop automated data processing workflows and scale environments to accommodate growing data volumes.
4. Data Security and Compliance: Implement data governance and access controls, ensuring compliance with security policies and regulations like GDPR.
5. Performance Optimization: Improve data ingestion pipelines and query performance, identifying and resolving bottlenecks.
6. Collaboration: Work closely with data scientists, analysts, and business intelligence teams on data integration and reporting projects.
7. Development: Write efficient, scalable code and conduct code reviews to ensure quality and adherence to best practices.
8. Technical Leadership: Supervise small project teams, provide technical guidance, and coach team members in data engineering best practices.
9. Training: Provide training and foster knowledge sharing across the team and user base.
About You
1. Proficiency in Microsoft SQL Server and SQL.
2. Experience with data warehousing and data modeling concepts.
3. Expertise in ETL processes.
4. Excellent problem-solving skills and attention to detail.
5. Effective communication skills for collaboration.
6. Understanding of data security principles and compliance.
7. Ability to diagnose and resolve complex technical issues.
8. Basic knowledge of insurance concepts is beneficial.
Technologies We Use
1. Snowflake Data Cloud, FiveTran, Collibra, dbt, Dataiku.
2. Microsoft Azure, including Synapse and DevOps.
3. Microsoft SQL Server, SSIS, SSAS, SSRS.
4. Python and C# programming languages.
5. Microsoft Power BI and Office 365.
Benefits
We offer a competitive salary, great teams, and exciting career opportunities, along with a wide range of benefits including:
* Minimum of 25 days holiday plus bank holidays, with options to buy extra days.
* Defined contribution pension scheme with employer contributions.
* Life insurance (4x salary, up to 10x).
* Income protection (up to 50% of salary).
* Health cash plan or private medical insurance.
Additional Benefits
* Volunteering days, employee stock purchase plan, share incentive plan.
* Critical illness cover, gym discounts, season ticket loans.
* Access to discount vouchers, family care support, and more.
Inclusion & Diversity
Gallagher values inclusion and diversity, embedding it into our culture. We are committed to supporting applicants with disabilities and ensuring an accessible recruitment process. We are a Disability Confident employer and pledge to make reasonable accommodations for all applicants. For adjustments, contact TAGlobalSupport@ajg.com.
Gallagher is an equal opportunity employer, committed to diversity and inclusion in all aspects of employment.
#J-18808-Ljbffr