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 and optimise SQL performance.
  • 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 make 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

As a leading employer in the tech industry, we offer a dynamic work environment in London that fosters innovation and collaboration. Our hybrid work model allows for flexibility while ensuring our Data Warehouse / Database Engineers have access to cutting-edge resources and support for professional growth. With a strong emphasis on employee development and a culture that values teamwork, we provide an excellent platform for those looking to make a meaningful impact in data engineering.
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 data engineering field, especially those who work with Postgres or Netezza. 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 and any data warehouse 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 validation and reconciliation questions. We all know that being well-prepared can make a huge difference, so practice explaining your past experiences with dual dataset architectures.

✨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 and engaged with our platform.

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
Technical Documentation
Performance Optimisation
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 or maintained 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 key achievements and responsibilities. We appreciate straightforward communication that gets right to the heart of your experience.

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 see what you bring to the table!

How to prepare for a job interview at Neev Limited

✨Know Your SQL Inside Out

As a Data Warehouse / Database Engineer, you'll need to showcase your advanced SQL skills. Brush up on your SQL scripting and be ready to discuss specific examples of how you've optimised queries or handled bulk data ingestion in past projects.

✨Familiarise Yourself with the Tech Stack

Make sure you understand Postgres and IBM Netezza thoroughly. Be prepared to talk about your experience with these technologies, especially in relation to schema design and data validation. If you have any experience with ServiceNow or Remedy, highlight that too!

✨Prepare for Scenario-Based Questions

Expect questions that ask you to solve real-world problems related to data quality and performance issues. Think of specific challenges you've faced in previous roles and how you resolved them. This will demonstrate your practical knowledge and problem-solving skills.

✨Showcase Your Documentation Skills

Technical documentation is key in this role. Be ready to discuss how you've produced documentation for data flows, schemas, and load processes in the past. This shows your attention to detail and ability to communicate complex information clearly.

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

>