SQL Data Engineer - Azure Integration | Hotel Chocolat

Reporting to the Senior Data Manager, the SQL Data Engineer will play a key role in the organisation's data transformation programme, working across SQL Server, Azure Integration Services, data warehousing and enterprise data architecture. You will be responsible for helping shape Logical and Canonical Data Models (LDM/CDM), supporting the migration of legacy systems into a modern, scalable data environment and building high performance integration solutions across multiple business systems. The role is responsible for ensuring the optimal operation and performance of data pipelines across a range of business applications, whilst supporting the development of a centralised Single Source of Truth strategy. Beyond hands on engineering, you will act as a bridge between technical teams and the wider business, translating complex technical concepts into practical solutions and supporting the ongoing integrity, quality and reliability of enterprise data assets., ·Collaborate with the Data Architect to design and deploy LDMs and CDMs, facilitating the decoupling of legacy core systems from modern SaaS endpoints ·Design, deploy, and monitor event-driven integration patterns using Azure Logic Apps, Functions, and Service Bus to manage transactional data via Change Data Capture (CDC) ·Develop data models and reports to meet business needs, proactively working with the business to ensure they are created to maximise the opportunity and functionality available ·Manage the migration of disparate data flows into a centralised "Single Source of Truth," ensuring consistency across datasets, dashboards, and reporting assets. ·Architect and maintain robust data quality solutions - including mastering, cleansing, and validation protocols, to ensure high-fidelity data across environments ·Act as a technical liaison for business stakeholders, ensuring that data assets remain synchronised with evolving operational requirements ·Support the internal data consumer community by establishing and enforcing data standards and providing technical guidance to promote self-service capabilities.

·Expert-level T-SQL with experience in Microsoft SQL Server, specifically the extraction and optimisation of data from complex legacy environments. ·Hands-on experience with the Azure AIS suite, including Logic Apps, Azure Functions, and Service Bus (Topics and Subscriptions) ·Comprehensive understanding of normalisation, LDM, and CDM concepts, with a proven ability to visualise data flows that satisfy complex business logic. ·Experience with Change Data Capture (CDC) or Change Tracking to manage delta loads effectively.

Desirable ·Prior experience within WMS, ERP or large-scale retail replenishment environments ·Experience operating within structured project frameworks to deliver scalable data solution ·Demonstrated ability to translate complex technical architectures into professional presentations for non-technical leadership

As well as a competitive salary and a range of company benefits, you'll receive 50% discount on all products, and a 70% discount for you and your guests when you stay at our Rabot Estate hideaway on the paradise island of Saint Lucia.

We're one of the UK's favourite premium chocolate brands, with a range of products spanning luxury gifts, alcohol, and our pioneering drinking chocolate system, the Velvetiser. We're market leaders in the industry. What began as an online-only business grew to over 160 stores across the UK, and we're still growing with stores opening in the US. Today, we're multi-category, multi-channel, and multi-territory, and our customers, colleagues, cacao farmers, and suppliers all benefit from the success we make together., Here at Hotel Chocolat, we've adopted hybrid working. This means you'll ideally join us on site for two days a week, and for the other three days - you can work from wherever you like! The on-site location for this role is our support office, Mint House', in Royston, Hertfordshire. Our home from the very beginning, it's just off the A505 and 10 minutes' walk from Royston train station, with direct rail links to London King's Cross.