Senior BI Developer

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 BI Developer you will support, improve and deliver high quality BI reporting solutions as part of the Central BI Team, via both on prem and cloud-based solutions. You will actively participate within the Central BI Team to help develop other team members and support the delivery of the team objectives. Performing operation support activities to ensure the Central BI solution meets the business SLA’s, including occasional OOH activities.

We currently operate a hybrid working model. This entails 3 days per week collaborating with colleagues in the office, and 2 days working from home. 

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.
• Share knowledge and expertise with other team members to enable continued team skills development.
• 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

•       Experience with Microsoft Azure (Data Factory, Data Lake, Databricks)

•       T-SQL Development (MS SQL Server 2005 onwards)

•       Python

•       Kimball Dimensional Modelling Methodology

•       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

Experience of the following systems would also be advantageous:

•       Team Foundation Server

•       MDS

•       JIRA

Experience of the following business areas would be advantageous:

•       Insurance sector (Lloyds Syndicate, Underwriting, Broking)

Qualifications:

•       Degree educated in relevant field or long-standing technical experience

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.