Senior Business Intelligence Developer

data analyst jobs; London; Remote; GBP 50,000 - 75,000; Full time

Job summary

A leading company in the insurance sector is seeking a Senior Business Intelligence Developer to support and deliver high-quality BI reporting solutions. This role involves collaborative work with various departments, data analysis, and mentoring junior team members while ensuring the management of BI technical environments meets service levels. Candidates should have proven experience with Microsoft Azure and full development life cycle in various BI tools.

Benefits

Competitive Benchmarked Salary

25 days holiday

Discretionary bonus scheme

Employee assistance programme

Annual holiday buy (up to 3 extra days)

Salary sacrifice benefits

Annual benefits reviews

Professional qualifications and study support

Qualifications

• Experience with Microsoft Azure (Data Factory, Data Lake, Databricks, ADO).
• T-SQL Development (MS SQL Server 2005 onwards).
• Experience with MS Integration Services (SSIS) for DW ETL Solutions.

Responsibilities

• Review, develop, and deliver high quality BI reporting solutions (e.g., dashboards).
• Conduct data analysis and design data extraction and database repository.
• Liaise with business personnel to document business requirements.

Skills

Microsoft Azure

T-SQL Development

MS Integration Services

MS Analysis Services

MS Reporting Services

Kimball Dimensional Modelling

Tools

Team Foundation Server

MDS

Job description

Overview

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.

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.

Key responsibilities

Business Intelligence Team

• Review, develop and deliver high quality BI reporting solutions (e.g. BI reports, dashboards, financial reports) to an agreed schedule and following the agreed team standards and processes.
• Conduct data analysis and then design and deliver the subsequent data extraction and database repository.
• Provide the agreed level of documentation and handover to enable the support and continued development of the BI solutions delivered.
• Liaise with business personnel to review, refine and document business requirements.
• 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 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.
• Present innovative technical opportunities to the business.
• Embody and amplify the IQUW values in all aspects of day-to-day activity ensuring that all interactions and engagements are carried out with the highest ethical and professional standards and that all work is accomplished with quality and in accordance with IQUW values.

Qualifications, skills and experience

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
• MDS

Benefits

• Competitive Benchmarked Salary
• 25 days holiday
• Discretionary bonus scheme
• Employee assistance programme
• Annual holiday buy (up to 3 extra days)
• Salary sacrifice benefits
• Annual benefits reviews
• The option for professional qualifications and study support

Additional Information

• A full job description can be seen here.