BI Data Engineer

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

stating which role you are applying for.

#J-18808-Ljbffr