Data Analytics Engineer

Who we are and what we do

About Hachette UK

Hachette UK is a creative powerhouse and the UK's second largest book publishing group. Our mission is to make it easy for everyone to discover new worlds of ideas, learning, entertainment and opportunity.

We're made up of 10 autonomous publishing divisions and over 60 imprints with a rich and diverse history and an incredible range of authors. We're also the market leader in e-books and publish a range of bestsellers in audio format, the fastest growing part of our business.

Our award-winning adult publishing divisions are Orion, which won Publisher of the Year at the 2021 British Book Awards; Little, Brown; John Murray Press; Hodder & Stoughton; Headline; Octopus, and Bookouture. They publish fiction and non-fiction in digital, audio and print format, from the world's best and most diverse authors, including Brit Bennett, Candice Carty-Williams, Martina Cole, Michael Connelly, John Grisham, Stephen King, Stieg Larsson, Nelson Mandela, Stephenie Meyer, Maggie O'Farrell, Delia Owens, Ian Rankin, J.K. Rowling, Colson Whitehead, and Malala Yousafzai. Hachette Children's Group publishes a wide and vibrant range of books for children across all age ranges, while Hachette Learning is a market leader in resources for both primary and secondary schools.

Hachette UK is part of Hachette Livre, the world's third largest trade and educational publisher. As well as our headquarters in Carmelite House, London, and our state-of-the-art book distribution centre in Didcot, Oxfordshire, we have recently opened five new offices in Manchester, Bristol, Sheffield, Newcastle, and Edinburgh. The UK region also includes offices in Australia, New Zealand, India, Singapore, the Caribbean, and Ireland.

It's an exciting time to join our business because the publishing market continues to grow and thrive. The UK remains the largest exporter of physical books in the world and book adaptations for film and TV are the foundation of the UK's creative industries.

What you'll be doing

Through your Owner mentality, problem solving, creativity and proactivity, you ensure the analytics engineering to deliver solutions, making the best use of our data that supports our mission.

Core objectives of this role are to assist with the development and rollout out of the Business Intelligence and analytics product(s). And to provide on-going maintenance, support and triage of queries, delivering user training and analysis of change requests. The role holder will act as a conduit between Group IT and its customers both internal and external.

The function of the Business Intelligence and Data Engineering team is to develop and support enterprise-level data insight and reporting solutions in response to business-driven requests for change. The solutions must always strive to be accurate and available, making them a trusted source of business information, and ensuring best practices are followed and comply with IT and industry standards.

The role encompasses working as a key member of the BI&D team. A team of skilled specialists comprising permanent and contract staff members and managed by the Head of IT: Business Intelligence. The team is responsible for maintaining existing solutions, implementing new solutions, and providing technical, front end and analytical input into strategic projects.

The business is currently operating Cognos Analytics as its primary BI tool and is embarking on a transformation towards cloud-based analytics through Power BI and Microsoft Fabric. This role will play an important part in supporting and shaping that transition.

The role will work closely with teams across the organisation — including Commercial Analysis, Sales, Marketing, Finance, Distribution and Inventory — to understand diverse business processes and data needs, promote knowledge sharing, and encourage the use of common best practices in analytics and reporting.

The role will support approved change requests throughout the full development lifecycle, ensuring that solutions meet agreed specifications and deliver clear business value.

The role will play a key part in the design and delivery of the HUK Data Strategy, actively supporting the transition from Cognos to Power BI and from on-premise solutions to a cloud-based analytics platform. This includes building and maintaining data models, reports and dashboards, and supporting user training and adoption.

The role will contribute to the organisation’s data and analytics transformation by supporting the migration to Microsoft Fabric and Power BI, helping define future-state standards, patterns and best practices, and supporting the rationalisation, prioritisation and redesign of existing Cognos reports and datasets to ensure they are fit for purpose in the new cloud-based analytics environment.

This exciting role will work closely with Business Stakeholders, Data Engineering and IT to ensure migrated solutions are accurate, trusted and aligned with enterprise data architecture.

Who we are looking for

We are looking for someone with the following skillset:

• Experience working in the publishing, distribution, retail or supply-chain sectors.
• Experience supporting BI platform migrations or reporting transformations.
• Experience with Microsoft Fabric or other cloud-based data platforms.
• Experience using Cognos Analytics and/or Power BI reporting solutions in a business environment.
• Experience designing and maintaining BI data models, using Power BI, including joining multiple tables, defining relationships and creating measures and calculations (DAX).
• Working knowledge of SAP data structures or equivalent ERP systems.
• Experience analysing large and complex datasets.
• Understanding of modern cloud-based analytics architectures, including separation of storage, compute and semantic layers.
• Ability to analyse, interpret and clearly explain data to non-technical audiences.
• Strong communication skills with the ability to work effectively with a wide range of stakeholders across the business.
• Excellent problem-solving, analytical and organisational skills.
• Flexibility and adaptability, with the ability to work effectively in a changing environment.
• Ability to build and maintain strong working relationships with colleagues, customers and third-party partners.

What we offer

Our staff are our greatest asset, and our benefits reflect this:

• 28 annual leave days per year, increases to 29 days after 2 years' service and goes up to 30 days after 5 years' (+ bank holidays)
• Private medical insurance
• Dental insurance
• Generous pension schemes
• Rent deposit loans
• 2 community days per year
• Summer hours (finishing at 1pm on Fridays during the summer months)
• Retail discounts through Hachette rewards
• Cycle to Work scheme
• Eye care vouchers
• Wide-ranging training library
• Development programmes (including mentoring)
• Up to 70% off book purchases
• A charity bookshelf
• 12 Staff-led employee networks that are voluntary, including AgeWise, Gender Balance, Thrive, Pride, All Together, Wellbeing and religious networks
• Season ticket loans
• And much more!

This role can be based at our London office, or at any of our regional offices in Sheffield, Edinburgh, or Bristol, with a blend of in-office (3 days) and homeworking (2 days) per week.

Our commitment

Hachette employs people on the basis of their abilities. We aim to attract and develop talent from a base as broad as the world of readers we want to reach, with a wide and representative range of age, faith, disability, race, gender, sexuality and socio-economic, regional and cultural backgrounds.

If you are shortlisted and need us to make any adjustments to help you attend your interview, please let us know.

The Book Trade Charity offers financial support to people looking to enter the book trade but who may struggle to afford the costs of attending interviews and undertaking junior roles. For more information visit www.booktradeentrysupport.org