BI Data Engineer

Hybrid working - Flexible - Office in Hertfordshire/Cambridgeshire borders & Home/Remote

Negotiable to c£50,000 plus range of company benefits

Job Reference J12900

No sponsorship available for this opportunity

As we continue our mission to make people and nature happy through chocolate, we're looking for a Data Engineer to join our IT Team on a permanent basis.

ROLE OVERVIEW
Reporting to the Senior Data Manager, the role of the Data Engineer is to provide support to the business as part of the go-to team for datasets, dashboards, and reports as well as creating bespoke datasets and data translation between systems.
You'll be part of a data-driven transformation and play a crucial role in shaping the future of how Hotel Chocolat uses data.
The Data Engineer is responsible for ensuring the optimal operation of data pipelines across Production, Test, and UAT to support numerous business applications.
In addition to supporting the business, the Data Engineers support the IT Operations team in fixing data related issues and provide support training on new solutions. The team also provide support with GDPR requests.

JOB ROLE AND RESPONSIBILITIES
·Maintaining single source of truth so there is one set of data that can be used by varying reporting audiences to achieve their business request/need
·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
·Migration of existing data flows to the single source of the truth in either dataset, dashboard, or reporting form
·Perform data quality tests and reviews against the Production, Test, and UAT data sources to ensure data integrity and optimal performance
·Proactively engage with key business stakeholders on a regular basis to ensure the data assets managed by the Data team are maintained in-line with business needs
·Engage with 3rd parties in the provision or consumption of business data
·Support data consumers in the business by ensuring their use of data tools meet our defined standards and support on how to use these tools so they can consume data with minimal on-going support
·Maintain documentation related to the datasets to ensure auditing and data dictionaries are accurate

SKILLS AND EXPERIENCE

Essential
·Demonstratable experience with Microsoft SQL Server i.e. SQL, SSAS, SSRS and SSIS
·Demonstratable experience of Data Warehousing and ETL
·Experience of taking business requirements and translating these into user consumable data sets, dashboards and reports
·Exposure of merging data sets from different solutions to form one unique data set
Desirable
·Experience of database management tasks and housekeeping
·Experience of working in a project environment delivering data solutions
·Experience for Retail business needs is an advantage but not essential

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 125 stores across the UK, and we're still growing… 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 which role you are applying for