Data Engineer

About the job Job title: Data Engineer Location: Birkenhead - Hybrid working Working hours: 35 hours per week About HSB HSB (UK and Ireland) is a leading specialist provider of engineering, technology and structural warranty insurance solutions, plant and equipment inspection services and engineering-based risk management activities in the UK and Ireland. HSB (UK and Ireland) consists of the parent company HSB Engineering Insurance Limited (HSBEIL) together with its two UK subsidiaries, HSB Engineering Inspection Services Limited (HSBEISL); and a regulated MGA, MD Insurance Services Limited (MDIS) , which trades as Premier Guarantee or LABC Warranty. Collectively, HSB is the UK and Ireland’s only group of companies solely focused on providing specialist engineering and technology insurance solutions, alongside risk-focused inspection services and assessments to its customers. This opportunity sits within MD Insurance Services (MDIS) , supporting its Data & Analytics capability. Why Join MD Insurance Services? We don’t just insure—we enable confidence in construction. At MD Insurance Services (MDIS), you’ll be part of a specialist provider of structural warranty solutions, supporting developers, clients, and end users through high-quality risk assessment, inspection, and technical expertise. As part of the wider HSB and Munich Re Group, MDIS combines deep industry knowledge with strong financial backing and a reputation for delivering trusted, customer-focused solutions. You’ll be part of a collaborative and forward-thinking environment where data and technology play an increasingly important role in how we improve decision-making, enhance services, and deliver better outcomes. With a strong focus on professional development, modernisation, and continuous improvement, we support you to grow your skills while contributing to meaningful work. What You’ll Be Doing As a Data Engineer , you will play an important role in strengthening and modernising our data estate within MD Insurance Services. You will contribute to improving our existing SQL Server environment, support the development of a new Azure data platform, and help embed structured, well-governed development practices using Azure DevOps. Working with colleagues across the business, you’ll create simple, modular, and reusable data solutions that reduce complexity, improve reliability, and deliver clear business value. In your day to to you will: Collaborate with stakeholders to design and deliver scalable, high-quality data pipelines and models across SQL Server and Azure platforms. Develop simple, modular, reusable data components following best practices to enhance maintainability, performance, and governance. Own end-to-end delivery of data solutions, including deployment, monitoring, and proactive resolution of issues within Azure DevOps environments. Drive continuous improvement through transparent communication, code reviews, constructive feedback, and adoption of modern data engineering practices. Key Responsibilities: Responsibilities are aligned to our team’s operating principles: We Start With Why Work with stakeholders to understand the underlying problems and desired business outcomes Design data solutions that directly support decision-making and operational improvements Focus delivery on value and impact , not just technical output We Keep Things Simple Design and develop simple, modular and reusable data components Apply consistent patterns to reduce complexity and improve maintainability Avoid over-engineering by delivering practical, fit-for-purpose solutions We Have High Standards Build high-quality, well-performing data pipelines and models using best practices Ensure data solutions are robust, scalable and production-ready Maintain strong standards in coding, documentation and solution design We Own Outcomes Take accountability for delivering data solutions end-to-end, from design through to deployment and support Ensure solutions deliver measurable business value and meet user needs Proactively manage and resolve issues impacting delivery or data quality We Think Ahead Design flexible and adaptable data solutions that support future business needs Contribute to the evolution of the data platform, including adoption of Azure services Anticipate scaling, performance and integration requirements We Communicate Honestly Provide clear, proactive communication on progress, challenges and risks Translate technical concepts into understandable terms for non-technical stakeholders Maintain transparency in delivery and decision-making We Welcome Feedback Actively seek and apply feedback to improve data solutions and ways of working Participate in code reviews and peer discussions to strengthen quality and consistency Create a collaborative, open environment for sharing ideas and improvements We Challenge Constructively Ask questions to clarify requirements and challenge assumptions where needed Propose better approaches to improve outcomes, quality, or efficiency Balance stakeholder needs with sound engineering practices We Reflect and Improve Regularly review delivered solutions and processes to identify improvements Contribute to iterative enhancements of the data platform and engineering practices Support continuous improvement of team standards and delivery approach We Invest in Growth Stay up to date with modern data engineering practices, tools and Azure technologies Contribute to team learning through knowledge sharing and collaboration Continuously develop personal capability and engineering expertise What You Bring A thoughtful and analytical approach to problem solving An interest in creating clear, maintainable, and effective data solutions Strong communication skills, with the ability to share ideas clearly with different audiences A proactive and organised approach to managing work A collaborative mindset, with willingness to learn from others and share knowledge What You’ll Need Essential Skills: Experience working with SQL Server and strong T‑SQL development skills Ability to design and build modular and reusable data components Understanding of data modelling, schema design and performance optimisation Familiarity with ETL/ELT concepts and data pipeline development Experience using Git and version control practices Exposure to Azure data tools such as Azure SQL, Data Factory or Synapse Understanding of structured development practices and SDLC principles Strong attention to detail and problem-solving skills Ability to communicate effectively with both technical and non-technical colleagues Experience: Experience supporting or improving SQL Server environments Exposure to cloud-based data platforms (ideally Azure) Experience working in structured development or delivery environments Involvement in system improvements or modernisation initiatives What We Offer In addition to a competitive salary, excellent work-life balance and a bespoke training package, you will also receive a comprehensive benefits package: 25 days Annual Leave + Bank Holidays + Well-being days 10% Pension contribution from day 1 Eligibility for an Annual Bonus Private Medical Insurance Life Assurance Wellbeing and Development Scheme + EAP Study & continuing Professional Development Support Hybrid Working Diversity, Equity & Inclusion At HSB, Diversity, Equity and Inclusion foster innovation and resilience and enable us to act braver and better. Embracing the power of DEI is at the core of who we are. We recognise diversity can be multi-dimensional, intersectional and complex, so we want to build a workforce that includes a wide range of racial, ethnic, sexual and gender identities; economic and geographic backgrounds; physical abilities; ages; life, school and career experiences; and political, religious and personal beliefs. Additionally, we are committed to building an equitable and inclusive work environment where this diversity is celebrated, valued and everyone has equal opportunity to succeed. All candidates in consideration for any role can request a reasonable adjustment at any point in our recruitment process. You can request an adjustment by speaking to your Talent Acquisition contact.