Senior Data Engineer-Snowflake/DBT

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 is a Senior Data Engineering position and we are therefore looking for someone with extensive experience in this area with hands of experience using Snowflake and DBT. This role will be based from our London City office and we be looking for someone to be on site two days a week with the rest being hybrid working from home. How you'll make an impact SQL Server Proficiency: A strong understanding of Microsoft SQL Server and Structured Query Language (SQL) is crucial. The role requires working with databases, querying data, and optimizing performance. Data Warehouses & Data Modelling: Strong experience with data warehouse and modelling concepts is essential for designing efficient and effective database structures. Understanding relationships, normalization, and denormalization is expected. ETL (Extract, Transform, Load) Pipelines: Experience with ETL (and ELT) processes is vital. The role is responsible for extracting data from various sources, transforming it, and loading it into data warehouses, etc. Problem-Solving Skills: As a data engineer, the role will encounter data discrepancies, performance issues, and user queries. Strong problem-solving abilities are essential. Security Awareness: Understanding data security principles and compliance (such as GDPR) is crucial. This role handles corporate sensitive data and information. Insurance Industry Knowledge: Required to understand the nuances and specific needs of the insurance industry. About You Previous experience gained working as a Senior Data Engineer in the insurance industry. Knowledge of technologies such as Snowflake Data Cloud, with supporting technologies and tools, including DBT, FiveTran, Dataiku and Collibra (Collibra experince is preferable for not essential). Experience with Microsoft Azure technologies, including Synapse and DevOps. Experience with Microsoft SQL Server technologies, including Master Data Services, SSIS, SSAS & SSRS. Knowledge of supporting tools/languages including Python & C# would be preferrable Compensation and benefits On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits. Below are the minimum core benefits you’ll get, depending on your job level these benefits may improve: Minimum of 25 days holiday, plus bank holidays, and the option to ‘buy’ extra days Defined contribution pension scheme, which Gallagher will also contribute to Life insurance, which will pay 4x your basic annual salary, which you can top-up to 10x Income protection, we’ll cover up to 50% of your annual income, with options to top up Health cash plan or Private medical insurance Other benefits include: Three fully paid volunteering days per year Employee Stock Purchase plan, offering company shares at a discount Share incentive plan, HMRC approved, tax effective, stock purchase plan Critical illness cover Discounted gym membership, with over 3,000 gyms nationally Season ticket loan Access to a discounted voucher portal to save money on your weekly shop or next big purchase Emergency back-up family care And many more…