Jobs

Data engineer (12 month FTC)


Job details
  • Hachette UK
  • Edinburgh
  • 4 days ago

Closing date:25th December 2024

Salary:£50,000 - £60,000 dependent on experience and location (+bonus +benefits)

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

 

Be the architect of Hachette UK’s data solutions, driving performance, accuracy, and innovation.

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.

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.

 

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.

 

Knowledge, skills and experience

  • 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)
  • 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

 

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!

 

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.

Please state in your application that you found this role through Creative Access.

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

Sign up for our newsletter

The latest news, articles, and resources, sent to your inbox weekly.

Similar Jobs

Data Engineer (eDV Clearance)

Data Engineer (eDV Clearance)London - Remote£100,000 - £120,000 + Training + Progression + Company BenefitsAre you a Data Engineer with enhanced developed vetting looking to join on of the worlds most renowned multinational technology businesses where you will be working on some of the world's most TOP SECRET software and...

City of London

Data Engineer / Warehouse Developer - £70,000 - Hybrid - London

Data Engineer / Data Warehouse Developer - £55,000 - £70,000 - Hybrid - LondonCompany Overview:My client, an established wealth management company is currently hiring for a Data Engineer / Data Warehouse Developer. They are a multinational cooperation who have been experts in their field for over 60 years, with the...

City of London

Data Engineer (Snowflake)

A well-known financial services company are looking for a Data Engineer with Snowflake experience to join their growing Data Engineering team in London - this is a permanent role with hybrid working arrangements, split roughly 50/50 between home and the office.In this role you will be working within a new,...

City of London

Data Engineer

Data Engineer** (Contract)Duration: 6 Months (Possibility for extension)Location: Chester or Bromley (3 days per week on site)Rate: A highly competitive Umbrella day rate is available for suitable candidatesRole ProfileWe are currently seeking a talented Data Engineer to join our client's team in the investment banking industry. As a Data Engineer,...

Chester

Data Engineer (FSDF/OFSAA/GCP)

End DateThursday 26 December 2024Salary Range£45,954 - £51,060Flexible Working OptionsHybrid Working, Job ShareJob Description Summary.Job DescriptionJOB TITLE: Data Engineer (FSDF/OFSAA/GCP)SALARY: £45,954 - £68,931LOCATION(S): BristolHOURS: [Full-time]WORKING PATTERN: Our work style is hybrid, which involves spending at least two days per week currently, or 40% of our time, at our Bristol office.About...

Bristol

Data Engineer

As a Data Engineer, you'll be actively involved in development of mission critical technical solutions that focus on data services for our National Security customers.Roke are a leading technology & engineering company with clients spanning National Security, Defence and Industry . You will work alongside our customers to solve their...

Innsworth