At a Glance
- Tasks: Develop and optimise SQL solutions while investigating data issues in a fast-paced environment.
- Company: Join a specialist financial data organisation in Central London with a hybrid work model.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Other info: Dynamic Agile team with a focus on accuracy and performance.
- Why this job: Make an impact by improving data processing systems for major banking clients.
- Qualifications: 3+ years of SQL Server experience and strong analytical skills required.
The predicted salary is between 45000 - 50000 € per year.
Location: Central London (Hybrid 2-3 days in office)
Salary: £45,000 - £50,000
Overview
We're working with a specialist financial data organisation that processes large-scale, highly structured datasets for regulated reporting across major banking and lending clients. The environment is data-heavy, fast-moving, and focused on accuracy, performance, and data integrity. We're looking for a Database Developer to join a small Agile team working across SQL development, data investigation, and production support.
You'll be responsible for maintaining and improving core data processing systems, resolving data issues, and optimising performance across large datasets.
Split of work:
- 60% SQL development & optimisation
- 30% data investigation & support
- 10% tooling/process improvement
Key Responsibilities
- Develop and optimise SQL Server-based data solutions
- Investigate and resolve data issues and anomalies
- Support production systems and deploy fixes
- Improve performance of queries and data pipelines
- Work with internal stakeholders to resolve data queries
Required Skills
- 3+ years SQL Server experience
- Strong T-SQL (queries, tuning, indexing)
- Azure SQL experience
- Strong analytical / data troubleshooting skills
- Experience with structured data (CSV/XML)
- Git experience
Desirable
- Azure data services exposure
- CI/CD or DevOps awareness
- Scripting (PowerShell)
- Financial or regulated data experience
Day-to-day
- Large-scale financial dataset processing
- Data reconciliation and reporting issues
- SQL performance optimisation
- Supporting internal users with data queries
We're looking for someone that's analytical, hands-on, and comfortable switching between development and support work. You can diagnose data issues independently and communicate clearly with stakeholders.
Database Engineer in City of London employer: IO Associates
Join a dynamic and innovative financial data organisation in Central London, where you'll thrive in a collaborative Agile environment that values accuracy and performance. With a strong focus on employee growth, we offer opportunities for professional development and the chance to work with cutting-edge technologies while enjoying a hybrid work model that promotes work-life balance. Our supportive culture encourages creativity and problem-solving, making it an excellent place for those seeking meaningful and rewarding employment.
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, 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
Show off your skills! Create a portfolio showcasing your SQL projects, data investigations, and any performance optimisations you've done. This will give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common SQL questions and scenarios related to data troubleshooting. Practise explaining your thought process clearly, as communication is key when working with stakeholders.
✨Tip Number 4
Don't forget to apply through our website! We’ve got some fantastic opportunities waiting for you, and applying directly can sometimes give you an edge over other candidates.
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 highlights your SQL Server experience and any relevant projects you've worked on. We want to see how your skills match the job description, so don’t be shy about showcasing your T-SQL expertise and data troubleshooting abilities!
Showcase Your Analytical Skills:Since we're looking for someone analytical, include examples of how you've resolved data issues or optimised performance in past roles. We love seeing real-world applications of your skills, so share those success stories!
Keep It Clear and Concise:When writing your application, clarity is key! Use straightforward language and avoid jargon unless it’s relevant. We appreciate a well-structured application that gets straight to the point—just like our data processing systems!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications better and ensures you’re considered for the role. Plus, it’s super easy—just a few clicks and you’re done!
How to prepare for a job interview at IO Associates
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills, especially T-SQL. Be prepared to discuss your experience with queries, tuning, and indexing. You might even be asked to solve a problem on the spot, so practice writing queries and optimising them beforehand.
✨Show Off Your Analytical Skills
Since the role involves troubleshooting data issues, be ready to share examples of how you've resolved similar problems in the past. Think about specific instances where your analytical skills made a difference and be prepared to explain your thought process.
✨Familiarise Yourself with Azure SQL
As Azure SQL experience is required, make sure you understand its features and benefits. If you have any hands-on experience, be ready to discuss it. If not, do some research and be prepared to talk about how you would approach using Azure SQL in your work.
✨Communicate Clearly with Stakeholders
This role requires clear communication with internal stakeholders. Practice explaining complex technical concepts in simple terms. Think about how you can demonstrate your ability to bridge the gap between technical and non-technical team members during the interview.
