At a Glance
- Tasks: Join our IT team to transform data and build high-performance integration solutions.
- Company: Hotel Chocolat, a brand dedicated to making people and nature happy through chocolate.
- Benefits: Enjoy a competitive salary, 50% product discount, and 70% off stays at our Saint Lucia hideaway.
- Other info: Collaborative culture with opportunities for professional growth and development.
- Why this job: Make a real impact on data transformation while enjoying a hybrid work environment.
- Qualifications: Expert in T-SQL and Azure Integration Services with experience in data modelling.
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. Job Reference J13125. 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.
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.
SKILLS AND EXPERIENCE
- 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.
- Prior experience within WMS, ERP or large‑scale retail replenishment environments.
- Experience operating within structured project frameworks to deliver scalable data solutions.
- Demonstrated ability to translate complex technical architectures into professional presentations for non‑technical leadership.
SQL Data Engineer – Azure Integration | Hotel Chocolat in Royston employer: Women in Data®
At Hotel Chocolat, we pride ourselves on being an exceptional employer that values innovation and collaboration. Our hybrid working model allows for flexibility between our Hertfordshire/Cambridgeshire office and remote work, fostering a healthy work-life balance. With competitive salaries, generous product discounts, and a commitment to employee growth through hands-on experience in data engineering, we offer a rewarding environment where you can thrive while contributing to our mission of making people and nature happy through chocolate.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Data Engineer – Azure Integration | Hotel Chocolat in Royston
✨Tip Number 1
Network like a pro! Reach out to current employees at Hotel Chocolat on LinkedIn or through mutual connections. A friendly chat can give you insider info and might just get your foot in the door.
✨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, and think of examples that showcase your problem-solving abilities.
✨Tip Number 3
Show your passion for chocolate and data! When you apply, let your enthusiasm shine through. Mention how you align with their mission to make people and nature happy through chocolate—it's all about connecting with their values.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're serious about joining the team at Hotel Chocolat.
We think you need these skills to ace SQL Data Engineer – Azure Integration | Hotel Chocolat in Royston
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 with data models and integration solutions.
Showcase Your Technical Skills:In your application, be sure to highlight your hands-on experience with Microsoft SQL Server and Azure services. Mention specific projects where you've successfully managed data pipelines or improved data quality, as this will resonate well with the hiring team.
Apply Through Our Website:We encourage you to apply through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people!
How to prepare for a job interview at Women in Data®
✨Know Your SQL Inside Out
Make sure you brush up on your T-SQL skills before the interview. Be ready to discuss your experience with Microsoft SQL Server, especially how you've extracted and optimised data from complex legacy systems. Prepare to share specific examples of challenges you've faced and how you overcame them.
✨Familiarise Yourself with Azure Integration Services
Since the role involves working with Azure Logic Apps, Functions, and Service Bus, it’s crucial to understand these tools. Try to get hands-on experience or at least read up on how they work. You might be asked to explain how you would design and deploy event-driven integration patterns, so have a few ideas ready.
✨Visualise Data Flows
Be prepared to discuss Logical and Canonical Data Models (LDM/CDM). It’s important to show that you can visualise data flows that meet complex business logic. Consider bringing a diagram or two to illustrate your thought process if the conversation allows for it.
✨Communicate Like a Pro
As a bridge between technical teams and business stakeholders, your ability to translate complex concepts into simple terms is key. Practice explaining your past projects in a way that non-technical people can understand. This will demonstrate your communication skills and your understanding of the business side of data engineering.
