Senior Data Engineer

Entrust Resource Solutions

Greater London

On-site

GBP 60,000 - 90,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Salary

Discretionary bonus

Employee assistance programme

Annual holiday buy

Benefits reviews

Study support

Salary sacrifice

Job summary

Entrust Resource Solutions (ERS) is seeking a skilled BI Developer to join the Central BI Team in London. You will design, build and maintain data extraction and reporting solutions, optimise ETL processes, and support data quality across our data warehouse for Lloyds Syndicate 218.

The role requires strong T-SQL, SSIS/SSAS/SSRS skills, experience with Kimball dimensional modelling, and collaboration with underwriting, claims and finance teams.

Qualifications

Degree or long-standing technical experience required.
Strong knowledge of T-SQL and data integration.
Experience with SSIS/SSAS/SSRS and data warehousing.
Familiarity with Kimball dimensional modelling.

Responsibilities

Provide daily BI support and data analysis
Develop and maintain ETL processes for the data warehouse
Design and deliver data extraction from sources for integration
Improve BI environment and data quality
Collaborate with Underwriting, Claims, Finance and Central MI teams

Skills

T-SQL Development

SSIS

SSAS

SSRS

Dimensional Modelling

Education

Degree in relevant field

Tools

Fabric

Microsoft Azure

Team Foundation Server

Azure Dev Ops

Job description

About us

ERS Syndicate 218 at Lloyds is managed by Starr. We are the UK’s largest specialist motor insurer with an A+ rating and have been making motoring passions and livelihoods possible since 1946. We work exclusively with motor insurance brokers to help get under the skin of the most difficult insurance risks, helping build products to meet their customer’s needs.

Overview

Role Purpose

To support, improve and deliver high quality BI reporting solutions as part of the Central BI Team.
Actively participate within the Central BI Team to help develop other team members and support the delivery of the team objectives.
Perform operational support activities to ensure the Central BI solution meets the business SLA’s, including occasional OOH activities.
Support the team lead in developing and managing future strategy decisions.
Take ownership of key initiatives that enhance data quality, reporting capability and analytical maturity across the business.

Key Responsibilities

Business Intelligence Team

Contribute to daily support activities, ensuring scheduled processes are running correctly, consistently and any issues are raised for investigation and resolution in a timely manner.
Conduct data analysis tasks, profiling work requests to scale effort and complexity, to feed into the team backlog for future development.
Design and deliver data extraction processes from new and existing sources, to integrate into an established data warehouse.
Maintain and enhance existing ETL processes, ensuring reliability, accuracy and performance, including fine tuning of stored procs, views, functions and queries as the underlying dataset grows.
Contribute to the management and continuous improvement of BI technical environment to ensure expected service levels are met and known service issues are resolved.
Participate in BI and business meetings and take ownership of relevant action points throughout the escalation process to achieve satisfactory results.

Wider BI Business Support

Work directly with, but not limited to, the Underwriting, Claims, Finance and Central MI business representatives to identify and document business requirements.
Provide technical support and guidance to the business teams to enable them to achieve their own reporting goals.

The above duties and responsibilities are not an exhaustive list, and you may be required to undertake other reasonable duties compatible with your experience and competencies. This description may be varied from time to time to reflect changing business requirements.

Essential Qualifications, Skills And Experience