Data Warehouse / Database Engineer
Data Warehouse / Database Engineer

Data Warehouse / Database Engineer

Full-Time 60000 - 75000 £ / year (est.) No home office possible
N

At a Glance

  • Tasks: Design and build data layers for seamless reporting transitions between systems.
  • Company: Dynamic tech firm in London with a hybrid work culture.
  • Benefits: Competitive contract pay, flexible working, and opportunities for skill enhancement.
  • Other info: Collaborative environment with potential for career advancement.
  • Why this job: Join a pivotal role in transforming data processes and making a real impact.
  • Qualifications: 6-8 years of experience in database engineering and advanced SQL skills.

The predicted salary is between 60000 - 75000 £ per year.

Location: London, UK (Hybrid / 2-3 Days Onsite required)

Contract Type: FTC- 6 months

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 (e.g. Business Objects)

Desirable Experience

  • Experience working with ServiceNow data extracts or APIs
  • Exposure to Remedy ITSM datasets

Data Warehouse / Database Engineer employer: NEEV LIMITED

Join a forward-thinking company in London that values innovation and collaboration, offering a hybrid work model that promotes work-life balance. As a Data Warehouse / Database Engineer, you'll benefit from a supportive work culture that prioritises employee growth through continuous learning opportunities and exposure to cutting-edge technologies. With a focus on meaningful projects and a commitment to data excellence, this role provides a unique chance to make a significant impact while working alongside talented professionals in a dynamic environment.
N

Contact Detail:

NEEV LIMITED Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Warehouse / Database Engineer

✨Tip Number 1

Network like a pro! Reach out to your connections in the industry, especially those who work with data warehousing or database engineering. A friendly chat can lead to insider info about job openings that aren't even advertised yet.

✨Tip Number 2

Show off your skills! Create a portfolio showcasing your SQL scripts, schema designs, and any projects you've worked on. This gives potential employers a taste of what you can do and sets you apart from the crowd.

✨Tip Number 3

Prepare for interviews by brushing up on common data warehouse scenarios. Be ready to discuss how you've tackled bulk data ingestion or optimised SQL performance in past roles. We want to see your problem-solving skills in action!

✨Tip Number 4

Don't forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search.

We think you need these skills to ace Data Warehouse / Database Engineer

SQL Development
Postgres
IBM Netezza
Data Warehouse Schema Design
Bulk Data Ingestion
Data Validation
Data Reconciliation
Business Intelligence Tools Support
Performance Optimisation
Technical Documentation
Troubleshooting Data Quality Issues
ServiceNow Data Extracts
Remedy ITSM Datasets

Some tips for your application 🫡

Tailor Your CV: Make sure your CV is tailored to the Data Warehouse / Database Engineer role. Highlight your experience with Postgres, Netezza, and SQL scripting. We want to see how your skills match what we're looking for!

Showcase Relevant Projects: Include specific projects where you've designed data warehouse schemas or worked on bulk data ingestion. This helps us understand your hands-on experience and how you can contribute to our team.

Be Clear and Concise: When writing your application, keep it clear and to the point. Use bullet points for your skills and experiences to make it easy for us to read. We appreciate straightforward communication!

Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can’t wait to hear from you!

How to prepare for a job interview at NEEV LIMITED

✨Know Your SQL Inside Out

Make sure you brush up on your SQL skills, especially with advanced scripting. Be prepared to discuss your experience with Postgres and Netezza, and maybe even solve a few SQL problems on the spot. Practising common SQL queries and performance optimisation techniques will definitely give you an edge.

✨Understand the Data Transition Process

Familiarise yourself with the transition from Remedy to ServiceNow. Knowing how to design and implement data warehouse schema changes will be crucial. Be ready to explain how you've handled similar transitions in the past and what challenges you faced.

✨Showcase Your Data Validation Skills

Data validation is key in this role, so come prepared with examples of how you've performed data reconciliation and validation in previous projects. Discuss any tools or methods you used to ensure data quality, as this will demonstrate your attention to detail.

✨Prepare for Technical Documentation Questions

Since producing technical documentation is part of the job, think about how you've documented data flows, schemas, and load processes in the past. Be ready to share your approach to creating clear and concise documentation that others can easily follow.

Data Warehouse / Database Engineer
NEEV LIMITED

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>