Data Engineer

Mypandi; City of London; Hybrid; GBP 30,000 - 40,000; Full time

Job summary

A leading insurance data firm in London is seeking a Data Engineer to develop data solutions and build insights through Power BI reports. The ideal candidate is proficient in SQL, understands data warehouse design, and has a commitment to delivering high-quality results. This role is entry-level with hybrid work options.

Qualifications

• Strong communication and interpersonal abilities.
• Excellent documentation and organisation skills.
• Self-motivated with the ability to manage tasks independently.
• Detail-oriented with commitment to high-quality deliverables.
• Proven problem-solving and solution-design capabilities.
• Comfortable analysing data to inform requirements.

Responsibilities

• Collaborate with the Lead Data Engineer on data solutions.
• Design and support star schema-based data warehouse.
• Build insightful Power BI dashboards and reports.

Skills

Strong SQL Server and T-SQL expertise

Deep understanding of data warehouse modelling

Hands-on experience with Azure Data Factory

Proficient with Power BI dashboard/report development

Familiar with DevOps and Git

Solid understanding of insurance data

Job description

Overview

We're hiring: Data Engineer - Insurance Data & Power BI

Location: London, UK (Hybrid)

Industry: Insurance / London Market

Type: Full-time

What You'll Be Doing

• Collaborate with the Lead Data Engineer and Business Analysts to define and deliver data solutions
• Design and support a star schema-based data warehouse
• Perform application data modelling and develop internal/external data integrations
• Build insightful and actionable Power BI dashboards and reports
• Provide proactive data support services to business users
• Support the integration of business systems and data
• Develop robust reconciliation and unit testing processes
• Document solutions, processes, and technical decisions clearly

Technical Skills

• Strong SQL Server and T-SQL expertise
• Deep understanding of data warehouse (DWH) modelling and star schema design
• Hands-on experience with Azure Data Factory, Pipelines, and Fabric
• Proficient with Power BI dashboard/report development
• Familiar with DevOps, Git, and modern CI/CD practices
• Solid understanding of insurance data - including both syndicate and company markets

Professional Skills

• Strong communication and interpersonal abilities
• Excellent documentation and organisation skills
• Self-motivated with the ability to independently manage tasks and deadlines
• Detail-oriented with a commitment to high-quality deliverables
• Proven problem-solving and solution-design capabilities
• Comfortable analysing data to inform requirements and decision-making

Domain Knowledge

• London Market / insurance experience (required)
• Understanding of application databases, testing, and reconciliation procedures
• Experience working with international teams/projects is a plus

Seniority level

• Entry level

Employment type

• Full-time

Job function

• Information Technology

Industries

• Operations Consulting