Senior BI Data Engineer

IQUW Group; London; On-site; GBP 40,000 - 80,000; Full time

Job summary

An established industry player is seeking a BI Data Engineer to enhance their data capabilities. In this role, you'll support the Central BI Team, delivering high-quality reporting and transformation solutions using cutting-edge tools like Databricks and Azure Data Factory. Your contributions will directly impact the business by improving data processes and supporting various teams across the organization. If you're a proactive individual with a knack for data and a passion for collaboration, this is the perfect opportunity to make your mark in a dynamic environment focused on innovation and excellence.

Qualifications

• Degree educated or extensive technical experience in data engineering.
• Strong communication and documentation skills are essential.

Responsibilities

• Support and deliver high-quality BI reporting and data transformation solutions.
• Enhance Data Lakehouse with new Databricks pipelines and data transformations.

Skills

Communication Skills

Self-starter

Time Management

Proactive Attitude

Education

Degree in relevant field

Long-standing technical experience

Tools

Databricks

Azure Data Factory

Power BI

Microsoft Azure

T-SQL Development

Microsoft Fabric

Azure DevOps

Job description

Overview

Job Description

BI Data Engineer

Reporting to: Business Intelligence Manager Location: London

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.

The role

• Support, improve and deliver high quality BI reporting and data transformation solutions as part of the Central BI Team using tools such as Azure Data Factory, Microsoft Fabric, Databricks and Power Bi.
• Actively participate within the central Data & BI Team to help develop other team members and support the delivery of the team objectives.
• Perform operation support activities to ensure the Central BI solution meets the business SLA’s, including occasional OOH activities.

Key responsibilities

Data & Business Intelligence Team

• Enhance existing Data Lakehouse with new Databricks pipelines to ingest new data sources.
• Build out data transformations to support new Facts and Dimensions within existing Data Lakehouse.
• 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/data transformation solutions delivered.
• Liaise with business personnel to review, refine, and document business requirements.

Wider BI Business Support

• Work directly with the Actuarial, 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 any other reasonable duties compatible with your experience and competencies. This description may be varied from time to time to reflect changing business requirements.

Preferred Skills and Experience

• Databricks
• Azure Data Factory
• Data Lakehouse Medallion architecture
• Microsoft Azure
• T-SQL Development (MS SQL Server 2005 onwards)
• Python, PySpark

Experience of the following systems would also be advantageous:

• Azure DevOps
• MDS
• Kimball Dimensional Modelling Methodology
• Power Bi
• Unity Catalogue
• Microsoft Fabric

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.

Key Personal Desirables

• Excellent communication skills – written and verbal, being able to liaise with staff at all levels around issues and opportunities.
• Can do attitude – self-starter, makes things happen. Ability and attitude to learn and develop.
• Excellent documentation skills and attention to detail.
• Proactive and self-motivated taking ownership of allocated task through to the delivery.
• A team player who can establish and maintain effective working relationships with colleagues at all levels.
• Strong customer focus with the ability to develop productive working relationships with a range of stakeholders.
• Strong time management skills.

Additional Information