Data Engineer

Join to apply for the Data Engineer role at P&I Insurance Services.

Get AI-powered advice on this job and more exclusive features.

• We're Hiring: Data Engineer - Insurance Data & Power BI
• Location: London, UK (Hybrid)
• Industry: Insurance / London Market
• Type: Full-time

• 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

• 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

• 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

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

• Entry level

• Full-time

• Information Technology

• Operations Consulting