Data Engineer

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

• 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

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

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.