Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and implement data warehouse schemas and optimise SQL performance for reporting.
- Company: Join a forward-thinking company focused on data-driven solutions.
- Benefits: Attractive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic work environment with a focus on innovation and collaboration.
- Why this job: Be part of a team that shapes data strategies and drives impactful decisions.
- Qualifications: Strong SQL skills and experience with data warehousing and BI tools.
The predicted salary is between 50000 - 65000 £ per year.
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)
Data Warehouse Engineer employer: Neev
Contact Detail:
Neev Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Engineer
✨Tip Number 1
Network like a pro! Reach out to your connections in the data engineering field and let them know you're on the hunt for a Data Warehouse Engineer role. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL scripts, data models, and any projects you've worked on. This will give potential employers a taste of what you can do and set you apart from the competition.
✨Tip Number 3
Prepare for interviews by brushing up on common data warehouse scenarios and SQL performance optimisation techniques. Practise explaining your past experiences with data validation and reconciliation, as these are key skills for the role.
✨Tip Number 4
Don't forget to apply through our website! We regularly update our job listings, and applying directly can sometimes give you an edge. Plus, it shows you're genuinely interested in joining our team!
We think you need these skills to ace Data Warehouse Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience as a Database/Data Warehouse Engineer. We want to see your advanced SQL skills and any relevant projects you've worked on, especially those involving Postgres or IBM Netezza.
Showcase Your Skills: In your cover letter, emphasise your experience with data warehouse schema design and batch ingestion processes. We love seeing how you’ve optimised SQL performance in past roles, so don’t hold back!
Be Clear and Concise: When writing your application, keep it straightforward. Use bullet points for your key achievements and make sure we can easily see how your skills match the job description. Clarity is key!
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’re considered for the role. Plus, it’s super easy!
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. This will show that you’re not just familiar with SQL, but that you can use it effectively in real-world scenarios.
✨Understand Data Warehouse Concepts
Familiarise yourself with data warehouse schema design and the specific requirements for ServiceNow data. Be ready to explain how you would approach designing and implementing schema changes, as well as optimising SQL performance for reporting. This knowledge will demonstrate your expertise and readiness for the role.
✨Prepare for Technical Questions
Expect technical questions related to Postgres, IBM Netezza, and batch ingestion processes. Review your past experiences and be ready to discuss specific projects where you’ve successfully implemented these technologies. Sharing concrete examples will help you stand out.
✨Showcase Your Problem-Solving Skills
Be prepared to talk about how you've troubleshot data quality and performance issues in the past. Think of specific instances where you identified a problem, the steps you took to resolve it, and the outcome. This will highlight your analytical skills and ability to handle challenges effectively.