What are the responsibilities and job description for the Data Engineer position at HSB - Hartford Steam Boiler?
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:
Responsibilities are aligned to our team’s operating principles:
We Start With Why
Essential Skills:
In addition to a competitive salary, excellent work-life balance and a bespoke training package, you will also receive a comprehensive benefits package:
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.
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.
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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
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 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
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.