At a Glance
- Tasks: Join our IT team to transform data and build high-performance integration solutions.
- Company: Hotel Chocolat, a leading premium chocolate brand with a collaborative culture.
- Benefits: Competitive salary, 50% product discount, and hybrid working options.
- Other info: Exciting career growth opportunities in a thriving company.
- Why this job: Make an impact in a dynamic environment while enjoying delicious chocolate perks.
- Qualifications: Expert-level T-SQL and experience with Azure Integration Services required.
The predicted salary is between 50000 - 65000 £ per year.
Hybrid working - 2 Days per week in office Hertfordshire/Cambridgeshire borders & Home/Remote
Negotiable DoE £50,000 to £65,000 plus benefits
No sponsorship available for this opportunity
As we continue our mission to make people and nature happy through chocolate, we're looking for a SQL Data Engineer to join our IT Team on a permanent basis.
ROLE OVERVIEW
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.
JOB ROLE AND RESPONSIBILITIES
- 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.
SKILLS AND EXPERIENCE
Essential
- 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
Who are we? 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.
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. 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.
If you are interested in this exciting new opportunity, please make an application via our recruitment partner, Datatech Analytics at (url removed) stating the role you are applying for.
SQL Data Engineer - Azure Integration | Hotel Chocolat employer: Datatech
At Hotel Chocolat, we pride ourselves on being an exceptional employer, offering a vibrant work culture that fosters creativity and collaboration. With hybrid working arrangements, competitive salaries, and unique benefits such as generous product discounts and the opportunity to work from our picturesque Rabot Estate in Saint Lucia, we are committed to supporting employee growth and well-being. Join us in our mission to make people and nature happy through chocolate, while enjoying a fulfilling career at one of the UK's favourite premium chocolate brands.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Data Engineer - Azure Integration | Hotel Chocolat
✨Tip Number 1
Network like a pro! Reach out to current or former employees at Hotel Chocolat on LinkedIn. A friendly chat can give you insider info and maybe even a referral, which can really boost your chances.
✨Tip Number 2
Prepare for the interview by brushing up on your SQL and Azure skills. Be ready to discuss how you've tackled data challenges in the past. Show them you're not just a techie but someone who can translate complex ideas into simple solutions.
✨Tip Number 3
Don’t forget to showcase your passion for chocolate! Mention how you resonate with their mission to make people and nature happy through chocolate. It’s all about connecting your personal values with the company’s ethos.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you’re genuinely interested in being part of the Hotel Chocolat family.
We think you need these skills to ace SQL Data Engineer - Azure Integration | Hotel Chocolat
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the SQL Data Engineer role. Highlight your experience with T-SQL, Azure Integration Services, and any relevant projects that showcase your skills in data transformation and integration.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about the role and how your background aligns with Hotel Chocolat's mission. Don’t forget to mention your experience in translating technical concepts for non-technical stakeholders.
Showcase Your Problem-Solving Skills:In your application, include examples of how you've tackled complex data challenges in the past. This could be anything from optimising data pipelines to managing Change Data Capture effectively. We love seeing how you think!
Apply Through Our Website:We encourage you to apply through our recruitment partner’s website. It’s the best way to ensure your application gets noticed. Plus, it shows you’re serious about joining our team at Hotel Chocolat!
How to prepare for a job interview at Datatech
✨Know Your SQL Inside Out
Make sure you brush up on your T-SQL skills before the interview. Be prepared to discuss your experience with Microsoft SQL Server, especially how you've extracted and optimised data from complex legacy systems. They’ll likely want to hear about specific challenges you've faced and how you overcame them.
✨Familiarise Yourself with Azure Integration Services
Since this role involves working with Azure Logic Apps, Functions, and Service Bus, it’s crucial to understand these tools. Try to have examples ready of how you've used these services in past projects, particularly in designing event-driven integration patterns.
✨Understand Data Models and Business Needs
Get a good grasp of Logical and Canonical Data Models (LDM/CDM) concepts. Be ready to explain how you’ve collaborated with teams to design data models that meet business needs, and think of ways to demonstrate your ability to visualise data flows that satisfy complex business logic.
✨Communicate Like a Pro
This role requires acting as a bridge between technical teams and non-technical stakeholders. Practice explaining complex technical concepts in simple terms. You might be asked to present a past project, so think about how you can make it relatable and understandable for someone without a technical background.
