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 pay, flexible working, and opportunities for skill enhancement.
- Other info: Exciting role with potential for career growth in a fast-paced environment.
- Why this job: Join a team 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
Experience needed – 6-8 years
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
Contact Detail:
Neev 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, schema designs, and any data validation projects you've worked on. This will give potential employers a taste of what you can do and set 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 and engaged with our platform.
We think you need these skills to ace Data Warehouse / Database Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Postgres and Netezza, as well as your SQL skills. We want to see how your background aligns with the role, so don’t be shy about showcasing relevant projects!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re excited about the Data Warehouse / Database Engineer position and how your skills can help us transition reporting from Remedy to ServiceNow.
Showcase Your Problem-Solving Skills: In your application, mention specific examples where you've tackled data quality or performance issues. We love seeing how you approach challenges, especially in bulk data ingestion and validation!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates during the process!
How to prepare for a job interview at Neev
✨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 that you not only understand the technical side but can also communicate it effectively to others.