At a Glance
- Tasks: Design and implement data warehouse schemas and develop SQL scripts for data ingestion.
- Company: Join a leading tech firm in London with a focus on innovation.
- Benefits: Competitive pay, flexible onsite work, and a chance to enhance your skills.
- Other info: Contract role with opportunities for professional growth and collaboration.
- Why this job: Make an impact by optimising data processes in a dynamic environment.
- Qualifications: 6-8 years of experience in database engineering and advanced SQL skills required.
The predicted salary is between 50000 - 65000 £ per year.
Role: Data Warehouse / Database Engineer (Netezza)
Location: London, UK (2-3 Days / Week Onsite)
Type: Fixed Term Contract - 6 months
Experience needed: 6-8 years
Required Skills & Experience
- Strong experience as a Database / Data Warehouse Engineer
- Advanced SQL scripting skills
- Proven experience with IBM Netezza
- Experience designing and maintaining enterprise data warehouse schemas
- Experience with batch ingestion and bulk-load processes
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
Database Engineer (Contract) in City of London employer: Neev
Contact Detail:
Neev Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Database Engineer (Contract) in City of London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage with professionals on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Prepare for interviews by practising common questions related to database engineering. Brush up on your SQL skills and be ready to discuss your experience with Netezza and data warehouse design. Confidence is key!
✨Tip Number 3
Showcase your projects! If you've worked on relevant data warehouse schemas or SQL scripts, create a portfolio or GitHub repository. This gives potential employers a tangible look at your skills and experience.
✨Tip Number 4
Don't forget to apply through our website! We make it easy for you to find roles that match your skills. Plus, it shows you're serious about joining our team and helps us keep track of your application.
We think you need these skills to ace Database Engineer (Contract) in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience as a Database Engineer, especially with Netezza and SQL scripting. We want to see how your skills match 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 the perfect fit for this contract role. Share specific examples of your past work with data warehouses and how you’ve tackled similar challenges.
Show Off Your Technical Skills: Since this role requires advanced SQL skills and experience with batch ingestion, make sure to mention any relevant tools or technologies you’ve used. We love seeing concrete examples of how you’ve optimised SQL performance in your previous roles!
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 – just follow the prompts!
How to prepare for a job interview at Neev
✨Know Your SQL Inside Out
Make sure you brush up on your SQL scripting skills before the interview. Be prepared to discuss complex queries you've written and how you've optimised them for performance. Practising some common SQL problems can really help you stand out.
✨Show Off Your Netezza Knowledge
Since experience with IBM Netezza is crucial, be ready to talk about specific projects where you've used it. Highlight any challenges you faced and how you overcame them. This will demonstrate your hands-on experience and problem-solving skills.
✨Understand Data Warehouse Design
Familiarise yourself with data warehouse schemas and be prepared to discuss your design process. Think of examples where you've designed or maintained schemas, and be ready to explain your thought process and the impact of your work.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that test your ability to handle batch ingestion and bulk-load processes. Think through past experiences where you’ve had to validate data files or optimise SQL performance, and be ready to share those stories.