Data Warehouse Engineer | Inside IR35 - TBC

Data Warehouse/Database Engineer (Postgres/Netezza)

6-month contract Inside IR35/Rate TBC

Must hold current SC or NPVV3 clearance

Remote with occasional travel to site

Role Overview

The Data Warehouse/Database Engineer will design, build, and support the data layer required to transition reporting from Remedy to ServiceNow, enabling Business Objects to consume clean, performant, and reconciled datasets.

The role focuses on bulk data ingestion, SQL development, schema design, and data validation, supporting a temporary dual dataset architecture across Remedy and ServiceNow.

Key Responsibilities

Design and implement data warehouse schema changes to support ServiceNow data

Develop bulk load SQL scripts to ingest ServiceNow data via the SNOW Mid Server

Support and validate mapped ServiceNow data files provided by CSMO teams

Optimise SQL performance for reporting and contractual data volumes

Maintain and enhance dual run data models for Remedy and ServiceNow

Support Business Objects reporting requirements through stable, well structured schemas

Perform data reconciliation and validation between Remedy and ServiceNow datasets

Troubleshoot data quality, performance, and ingestion issues

Produce technical documentation for data flows, schemas, and load processes

Required Skills Experience

Strong experience as a Database/Data Warehouse Engineer

Advanced SQL Scripting skills

Proven experience with Postgres and/or IBM Netezza

Experience designing and maintaining enterprise data warehouse schemas

Experience with batch ingestion and bulk load processes

Strong data validation and reconciliation skills

Experience supporting BI tools (eg Business Objects)

Desirable Experience

Experience working with ServiceNow data extracts or APIs

Exposure to Remedy ITSM datasets

Public sector or defence programme delivery

Experience supporting contractual or regulatory reporting

SmartSourcing are a Disability Confident Employer and we promote, celebrate and value diversity, we are committed to promoting equality and inclusion for all.