Data Engineering Specialist

Data Engineering Specialist 

Salary: National £70,000 - £75,000

Locations: Glasgow/ Norwich

A bit about the job:

We are seeking a highly experienced Data Warehouse Engineer to support our Lloyd’s syndicate operations. This role is critical in delivering a robust, high‑quality data platform that underpins underwriting, claims, actuarial, exposure management, and regulatory reporting across the syndicate.

The SQL Data Warehouse (DW) Data Engineer will be responsible for designing, developing, and maintaining data warehouse solutions that support London Market insurance operations. The role focuses on optimising data pipelines, ensuring data quality, and enabling advanced analytics across underwriting, claims, pricing, actuarial, and regulatory reporting functions.

The ideal candidate will have strong SQL, ETL, and data modelling experience within the London Market environment, with an understanding of key insurance datasets (e.g., bordereaux, premiums, claims, policy admin, exposure, Lloyd’s returns).

Skills and experience we’re looking for:

• Data Engineering & Development
  Designs and optimises SQL-based data warehouses while building reliable ETL/ELT pipelines using tools like SSIS, ADF, and Databricks. Implements dimensional modelling such as star schemas to support analytical workloads.
• London Market Data Expertise
  Works with complex London Market datasets including bordereaux, regulatory submissions (CMR, QMA/QMB, PMDR, LPM), and integrations across underwriting, claims, finance, and external market sources.
• Data Quality & Governance
  Builds automated data quality, lineage, and reconciliation frameworks to ensure trusted, controlled data flows. Applies best‑practice cleansing and exception‑handling processes while supporting wider governance initiatives.
• Stakeholder Collaboration
  Partners with Product Owners, Underwriters, Actuaries, BI teams, and IT to translate business needs into technical specifications. Provides guidance on data definitions, lineage, and appropriate data usage.
• Cloud & Modernisation
  Migrates legacy SQL platforms into Azure using Synapse, Data Lake, and Delta technologies while enabling self‑service analytics for Power BI and actuarial teams. Leverages cloud-native tools to modernise data pipelines and architectures.

What you’ll get for this role:

Our purpose - with you today, for a better tomorrow – is a promise we make to our colleagues too.  And one of the ways we live up to that promise is by investing in you.  We have so much to offer when it comes to being an Aviva colleague.

• Salary £70,000 - £75,000 for National based (depending on location, skills, experience, and qualifications)
• Bonus opportunity 10% of annual salary - Actual amount depends on your performance and Aviva’s
• Generous pension scheme - Aviva will contribute up to 14%, depending on what you put in
• 29 days holiday plus bank holidays, and you can choose to buy or sell up to 5 days
• Make your money go further - Up to 40% discount on Aviva products, and other retailer discounts
• Up to £1,200 of free Aviva shares per year through our Matching Share Plan and share in the success of Aviva with our Save As You Earn scheme
• Brilliantly supportive policies including parental and carer’s leave
• Flexible benefits to suit you, including sustainability options such as cycle to work
• Make a difference, be part of our Aviva Communities and use your 3 paid volunteering days to help others
• We take your wellbeing seriously with lots of support and tools

Take a look to learn more.  Put a salary into this calculator to see what your total Aviva Reward could be

Aviva is for everyone:

We’re inclusive and welcome everyone – we want applications from all backgrounds and experiences. Excited but not sure you tick every box? Even if you don’t, we would still encourage you to apply. We also consider all forms of flexible working, including part time and job shares.

We flex locations, hours and working patterns to suit our customers, business, and you. Most of our people are smart working – spending around 50% of their time in our offices every week - combining the benefits of flexibility, with time together with colleagues.

To find out more about working at Aviva take a look here

We interview every disabled applicant who meets the minimum criteria for the job. Once you’ve applied, please send us an email stating that you have a disclosed disability, and we’ll interview you.

We’d love it if you could submit your application online. If you require an alternative method of applying, please give Harjot Kaur a call on 07353138456 or send an email to harjot.kaur@aviva.com