Senior Business Intelligence Developer

at  ERS Administration Services

ABOUT US

IQUW is a speciality (re)insurer at Lloyd’s (Syndicate 1856) underwriting a diverse range of Property, Commercial and Speciality (re)insurance products from Cargo and Marine to Political Violence, Terror and War. We combine data, intelligent automation and human expertise to make smart decisions, fast.
ERS is the UK’s largest specialist motor insurer with an A+ rating. We recognise that for some, motor insurance is more than just a must-have; it’s a way of taking care of what stands at the heart of their passion or livelihood. For those people, standard insurance isn’t enough. That’s why 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.

ESSENTIAL EXPERIENCE:

• Experience with Microsoft Azure (Data Factory, Data Lake, Databricks, ADO)
• T-SQL Development (MS SQL Server 2005 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 reports
• Kimball Dimensional Modelling Methodology

EXPERIENCE OF THE FOLLOWING SYSTEMS WOULD ALSO BE ADVANTAGEOUS:

• Team Foundation Server

ADDITIONAL INFORMATION

• A full job description can be seen here.

THE ROLE

As a Senior Business Intelligence Developer, you will support and deliver high quality BI reporting solutions as part of the Central BI Team via both on prem and cloud-based solutions. You will perform operation support activities, ensuring the Central BI solution meets the business SLA’s, including occasional out of hours activities.
In your capacity as a senior team member, you will play a key role in mentoring and developing fellow team members while actively contributing to the achievement of broader BI Team goals.
This role is offered on a remote basis, with occasional travel to either the London or Swansea office. This is expected to be once per month.