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: Collaborative Agile team with a focus on accuracy and performance.
- Why this job: Make an impact on large-scale datasets and enhance your SQL skills in a dynamic team.
- Qualifications: 3+ years 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.
If this is of interest, please submit an up to date CV or email me directly.
Mid Level Database Developer 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 Mid Level Database Developer 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 their team.
✨Tip Number 3
Prepare for interviews by brushing up on common SQL scenarios and data troubleshooting questions. Practice 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 Mid Level Database Developer 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!
Showcase Your Analytical Skills:Since we're looking for someone with strong analytical abilities, include examples of how you've tackled data issues in the past. We love seeing how you’ve resolved anomalies or optimised performance in your previous roles.
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.
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you don’t miss out on any important updates from us!
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 query tuning and indexing, as these are crucial for the role. Practising common SQL problems can help you feel more confident during technical questions.
✨Showcase Your Analytical Skills
Since the job involves investigating data issues, be ready to share examples of how you've tackled similar challenges 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
Given that 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. Prepare to demonstrate your ability to explain complex data issues in simple terms. Think of examples where you've successfully communicated technical information to non-technical team members.
