Data Warehouse/Database Engineer
Role details
Job location
Tech stack
Job description
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
Requirements
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. ", "industry": "IT", "baseSalary": {"@type": "MonetaryAmount", "currency": "GBP", "value": {"@type": "QuantitativeValue", "value": "Inside IR35 - TBC"}}, "identifier": {"@type": "PropertyValue", "name": "[[BRANDNAME]]", "value": "[[IDENTIFIER]]"}, "datePosted": "2026-07-06T12:19+00:00", "validThrough": "2026-07-20T12:19+00:00", "hiringOrganization": {"@type": "Organization", "name": "SmartSourcing Ltd", "logo": "https://cjassets-fabkerfbaaayfhdm.z02.azurefd.net/images/jobbranding/d60e6f11aaeb/images/d60e6f11aaeb_detail.png"}, "jobLocation": {"@type": "Place", "address": {"@type": "PostalAddress", "addressRegion": "Remote ", "addressLocality": null, "addressCountry": "United Kingdom"}, "geo": {"@type": "GeoCoordinates", "latitude": "0.000", "longitude": "0.000"}}, "url"