At a Glance
- Tasks: Design and build data layers for seamless reporting transitions and optimise SQL performance.
- Company: Dynamic tech company in London with a hybrid work model.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on innovation and career advancement.
- Why this job: Join a team transforming data processes and make a real impact on business reporting.
- Qualifications: 5-8 years of experience in database engineering and advanced SQL skills.
The predicted salary is between 50000 - 60000 £ per year.
Location: London, UK (Hybrid / 2-3 days Onsite required)
Contract Type: FTC- 6 months
Experience needed – 5-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
Database Engineer in City of London employer: Neev
Contact Detail:
Neev Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Database Engineer in City of London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with data warehousing or have experience with Postgres and 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! Prepare a portfolio showcasing your SQL scripts, schema designs, and any successful projects you've worked on. When you get the chance to chat with potential employers, having tangible examples of your work can really set you apart.
✨Tip Number 3
Practice makes perfect! Before any interviews, brush up on your technical skills, especially around bulk data ingestion and data validation. You might even want to run through some mock interviews with friends or colleagues to build your confidence.
✨Tip Number 4
Don't forget to apply through our website! We often have exclusive listings that you won't find anywhere else. Plus, it shows you're genuinely interested in joining our team, which is always a bonus!
We think you need these skills to ace Database Engineer in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the 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 Your Projects: Include specific projects where you've designed data warehouse schemas or worked on bulk data ingestion. We love seeing real examples of your work that demonstrate your expertise in data validation and reconciliation.
Keep It Clear and Concise: When writing your application, keep it clear and to the point. Use bullet points for key achievements and avoid jargon unless it's relevant. 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
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss advanced SQL scripting techniques and even solve some SQL problems on the spot. Practising with Postgres and Netezza will give you a solid 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 show that you’re not just a techie but also understand the business side of things.
✨Prepare for Data Validation Questions
Expect questions around data validation and reconciliation. Have examples ready from your past experiences where you successfully troubleshot data quality issues or optimised performance for reporting. This will demonstrate your hands-on expertise.
✨Showcase Your Documentation Skills
Technical documentation is key in this role. Be ready to discuss how you’ve produced clear and concise documentation for data flows, schemas, and load processes in your previous roles. This will highlight your attention to detail and organisational skills.