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
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
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.