Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Collaborate on data solutions and build insightful Power BI dashboards.
- Company: P&I Insurance Services, a leader in the insurance industry.
- Benefits: Hybrid work model, competitive salary, and professional development opportunities.
- Why this job: Join a dynamic team and make an impact in the insurance sector.
- Qualifications: Strong SQL skills and a passion for data engineering.
- Other info: Entry-level position with great growth potential in a supportive environment.
The predicted salary is between 36000 - 60000 £ per year.
Overview
Join to apply for the Data Engineer role at P&I Insurance Services.
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
Data Engineer in City of London employer: P&I Insurance Services
Contact Detail:
P&I Insurance Services Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer in City of London
✨Tip Number 1
Network like a pro! Reach out to folks in the insurance and data engineering space on LinkedIn. A friendly message can go a long way, and you never know who might have the inside scoop on job openings.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and any data solutions you've worked on. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for those interviews! Brush up on your SQL Server and T-SQL knowledge, and be ready to discuss your experience with Azure Data Factory. We want you to feel confident and ready to impress!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who take that extra step to connect with us directly.
We think you need these skills to ace Data Engineer in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the Data Engineer role. Highlight your SQL Server and T-SQL skills, as well as any experience with Azure Data Factory and Power BI. We want to see how your background fits with what we’re looking for!
Showcase Your Projects: If you've worked on any relevant projects, especially those involving data warehousing or dashboard development, make them stand out! We love seeing practical examples of your work that demonstrate your problem-solving skills.
Be Clear and Concise: When writing your application, keep it straightforward. Use clear language and avoid jargon unless it's relevant. We appreciate a well-organised application that makes it easy for us to see your qualifications.
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. We can’t wait to hear from you!
How to prepare for a job interview at P&I Insurance Services
✨Know Your Data Inside Out
Make sure you brush up on your SQL Server and T-SQL skills before the interview. Be ready to discuss how you've used these tools in past projects, especially in relation to data warehousing and star schema design.
✨Showcase Your Power BI Skills
Prepare to talk about your experience with Power BI dashboard development. Bring examples of dashboards you've created and be ready to explain the thought process behind your designs and how they provided actionable insights.
✨Communicate Clearly
Since strong communication is key for this role, practice explaining complex technical concepts in simple terms. This will help demonstrate your interpersonal skills and ability to collaborate with non-technical stakeholders.
✨Demonstrate Problem-Solving Abilities
Think of specific challenges you've faced in previous roles and how you overcame them. Be prepared to discuss your problem-solving approach, particularly in relation to data integration and reconciliation processes.
