Data Engineer

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.

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.

Business Intelligence Team

Wider BI Business Support

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.

• T-SQL Development (MS SQL Server 2019 onwards)
• MS Integration Services (SSIS) including development of full DW ETL Solutions
• MS Analysis Services (SSAS) for complex cube reporting solutions
• MS Reporting Services (SSRS) including development of complex report
• Kimball Dimensional Modelling Methodology
• Fabric
• Microsoft Azure
• Team Foundation Server
• Azure Dev Ops
• Insurance sector (Lloyds Syndicate, Underwriting, Broking)
• Degree educated in relevant field or long-standing technical experience

Additional Information

#ERSLI