Data Engineer: Build Robust Data Pipelines & Dashboards

Hachette UK; Greater London; Hybrid; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Private medical insurance

Dental insurance

Generous pension schemes

Rent deposit loans

Cycle to Work

Eye care vouchers

Training library

Mentoring programs

Job summary

Hachette UK's Bookouture unit in London is seeking a Data Engineer to design new data structures and evolve existing ones, ensuring robust data systems and accurate reporting for a data-driven business. You will design SQL Server schemas, build ingestion workflows from sources to the reporting layer, optimise ETL with SSIS, and create dashboards in Tableau Cloud while collaborating with department heads.

Ideal candidates have a computer science background with extensive relational database

Qualifications

• Computer science background with extensive workplace experience of relational databases.
• Proficient in relational database schema design and structural planning (essential).
• Significant experience working with SQL Server, writing queries, building stored procedures, and developing data flows (essential).
• Experience working with SSIS packages to manage and improve daily import processes.
• Experience of Microsoft Azure integrations.
• Confident and effective user of AI tools for operational projects.
• Experience integrating systems via REST APIs and managing data between platforms.
• Experience building and optimising automations in Python (data syncs, API integrations, scheduled jobs).
• Experience with data visualisation tools (Tableau, Power BI or similar).
• Experience working with browser-based automation (e.g. Playwright).

Responsibilities

• Design and build new SQL Server databases from scratch — schema design, tables, views, stored procedures and indexing.
• Build ingestion workflows for new data sources from scratch — retailer and platform feeds, advertising and marketing data, third-party APIs.
• Analyse and streamline existing on-premise relational databases (SQL Server) and ETL packages (SSIS).
• Build and maintain both API-based and browser-based automations.
• Work closely with department heads across the division to support projects requiring data access.
• Maintain and review existing data visualisation dashboards (Tableau Cloud) and develop new reporting streams.
• Work with the Publishing Innovation Director to develop data structures for ML projects.
• Respond to team requests, troubleshoot issues, generate ad-hoc reports, and build automations for manual tasks.
• Constantly appraise workflows to maximise efficiency and reduce errors.

Skills

Relational databases

SQL Server

SSIS

Python

Azure

REST APIs

Data visualization

Playwright

Tableau/Power BI

Education

Bachelor's degree in Computer Science

Tools

SSIS

Tableau Cloud

Power BI

Playwright

Job description

Hachette UK's Bookouture unit in London is seeking a Data Engineer to design new data structures and evolve existing ones, ensuring robust data systems and accurate reporting for a data-driven business. You will design SQL Server schemas, build ingestion workflows from sources to the reporting layer, optimise ETL with SSIS, and create dashboards in Tableau Cloud while collaborating with department heads.

Ideal candidates have a computer science background with extensive relational database