Data Engineer (12 month FTC)

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 12 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; Quercus; Octopus, Bookouture and Dialogue Books. 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 Hodder Education 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

The function of the Business Intelligence and Data Engineering team is to develop and support enterprise-level data insight solutions 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 a team of skilled specialists comprising permanent and contract staff members and managed by the Data Engineering Manager. The team is responsible for maintaining existing solutions, implementing new solutions, and providing technical input into strategic projects.

Working policy for this role would be remote but expect to come to the office 1 to 2 days a month for team meetings or as and when required.

Core responsibilities

• Managing the existing Datawarehouse solution of more than 4 TB in size with 140+ workflows and 700+ scheduled reports
• Play a key role in Data Migration project.
• Creation and maintenance of
• SQL Server Integration Services ETL processes
• T-SQL development
• Azure Data Factory pipelines
• Cognos Framework Manager Data Modelling and Cognos Analytics report development
• Power BI Data Modelling and report development
• Influence design of Datawarehouse/Azure Data Bricks/Synapse solutions using best practice
• Monitoring of Datawarehouse day-end processing and performance
• Translation of business requirements into technical specifications.
• Work alongside Data Engineering Manager to deliver the Hachette IT Data Strategy
• Create and maintain documentation to assist in cross-team training and handover.

Who we are looking for

Skills/Knowledge:

• Experience in developing SQL Server Integration Services (SSIS) solutions
• Experience in developing T-SQL and other programming and scripting languages such as Python/Perl/ Powershell/VB Script/Scala
• Experience in Azure Data tech stack which includes Synapse analytics, Databricks, Data Factory etc..
• Experience in developing CI/CD pipelines using Azure DevOps
• Experience in using either Cognos Analytics or Power BI reporting solutions.
• Experience in either Cognos Framework Manager Data Modelling or Power BI Data Modelling
• Experience working in Data Migration & Data Cleansing workstreams.
• Good problem-solving, analytical, and organisation skills
• Flexibility and adaptability
• Ability to create and maintain strong working relationships with colleagues and customers

Desirable:

• Experience of API development / Maintenance.
• Experience in extracting data from SAP backend tables or good understanding of SAP backend tables.
• Experience in SSAS (SQL Server Analysis Services)
• Database Administrator skillsets.

Qualifications:

• Industry-recognised Data Warehouse Design qualification (such as Ralph Kimball)
• Awareness of Analysis tools/techniques like B.E.A.M (Business Events Analysis Model) or SSADM (Structured Systems Analysis and Design Method)

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
• 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 Gender Balance, Thrive, Pride, All Together, Wellbeing and religious networks
• Season ticket loans
• And much more!

This role can be based at our London, Sheffield or Edinburgh, 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 for 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