Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and deliver data pipelines, automate processes, and support database systems.
- Company: A leading bank in Central London with a focus on innovation.
- Benefits: Competitive salary, professional development, and a dynamic work environment.
- Other info: Office-based role for 3 days a week with excellent career growth opportunities.
- Why this job: Join a team that values your skills and offers real impact in the banking sector.
- Qualifications: Degree qualified with strong SQL Server, SSIS, and SSRS experience.
The predicted salary is between 60000 - 75000 ÂŁ per year.
Our Client is a bank based in Central London – who are looking to recruit a Database Engineer with at least 5 to 7 years of solid expertise working with SQL Server, SSIS and SSRS.
Responsibilities include:
- Development and delivery of data pipelines (collect, validate and prepare high‑quality data) to automate and streamline processes required by different departments.
- Support existing SSIS ETLs (overnight and intraday), proactively fine‑tune and enhance existing code to increase robustness and error monitoring.
- Support the internal IT department with changes and upgrades to software platforms.
- Convert legacy Hyperion reports to SSRS.
- Analyse issues pertaining to problems or errors raised by in‑house systems, i.e. CORE, SharePoint interface, Equation end‑of‑day cycle.
- Understand business requirements in order to develop and deliver appropriate solutions based on system definition documents.
- Programme in advanced 4GL languages and apply them through the full development life‑cycle.
- Build data pipelines within the SQL environment in SSIS packages, where required, introducing new fields and data types to collate new information in the CORE environment.
- Build tabular models (SSAS) for different business units.
- Build reports based on business requirements using SQL SSRS.
- Integrate with all of the Bank’s sub‑systems using abstraction and connectivity layers, i.e. ODBC, ADO.NET.
- Ensure that the environment runs optimally and meets high‑standard housekeeping procedures.
- Integrate the SharePoint environment and Forms with the Equation system to automate processes, thereby eliminating duplicate entry.
- Utilise web services to integrate cutting‑edge technology into legacy systems such as Equation.
- Provide second and third‑level support for in‑house programmes during the end‑of‑day cycle.
- Analyse and rectify any problems raised in an independent and team scenario.
- Take ownership of a problem and deliver a solution in a timely manner.
- Provide out‑of‑office‑hours support.
- Maintain knowledge of all applicable regulatory requirements, including the Bank’s Risk and Compliance policies and procedures, and adhere to these to avoid exposing the Bank to undue risk.
- Report policy or procedure breaches and areas of potential non‑compliance promptly upon identification in accordance with the Bank's Risk and Compliance policies.
- Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches.
- Identify new risks or control gaps within own area and escalates accordingly to your Line Manager and/or Head of Department.
- Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines.
- Proactively seek to complete recommended technical and behavioural competencies training required for your role.
- Act in accordance with the FCA/PRA Code of Conduct.
- Fulfil all prescribed business continuity requirements as set out in the organisational or departmental specific plans or as instructed by the Line Manager/Head of Department.
Qualifications / Experience:
- Degree level qualified or equivalent.
- MS SQL stack (SSIS, SSAS, SSRS) to a high level of proficiency – Essential.
- C# programming / JavaScript programming – Desirable.
Knowledge and Skills:
- Software analysis and design best practice.
- Dimensional modelling, Entity‑Relationship modelling, Normalised modelling.
- Data warehouse design concepts (Inmon, Kimball).
The position is based in Central London and requires you to be in the office for 3 days a week. Please note the Client does NOT provide sponsorship. The salary for this position is in the range £60K – £75K.
SQL Server Developer with SSIS and SSRS in London employer: Jas Gujral
Contact Detail:
Jas Gujral Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Server Developer with SSIS and SSRS in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work in banking or data roles. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Prepare a portfolio showcasing your SQL Server projects, SSIS packages, and any reports you've built with SSRS. This will give potential employers a clear view of what you can bring to the table.
✨Tip Number 3
Ace the interview by practising common technical questions related to SQL Server and data pipelines. We recommend doing mock interviews with friends or using online platforms to get comfortable with the format.
✨Tip Number 4
Don't forget to apply through our website! It’s super easy and gives you a better chance of being noticed. Plus, we love seeing familiar faces from our community!
We think you need these skills to ace SQL Server Developer with SSIS and SSRS in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to highlight your SQL Server, SSIS, and SSRS experience. We want to see how your skills match the job description, so don’t be shy about showcasing relevant projects or achievements!
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 role. We love seeing enthusiasm and a clear understanding of the responsibilities outlined in the job description.
Showcase Your Problem-Solving Skills: In your application, mention specific examples where you've tackled challenges related to database support or ETL processes. We’re looking for candidates who can take ownership and deliver solutions effectively!
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. Plus, it makes the whole process smoother for everyone involved.
How to prepare for a job interview at Jas Gujral
✨Know Your SQL Inside Out
Make sure you brush up on your SQL Server skills before the interview. Be prepared to discuss your experience with SSIS and SSRS, and have examples ready that showcase how you've developed data pipelines or enhanced existing ETLs. The more specific you can be about your past projects, the better!
✨Understand the Business Context
Since this role is in a banking environment, it’s crucial to understand the business requirements behind the technical tasks. Familiarise yourself with common banking processes and how data management plays a role in them. This will help you demonstrate that you can bridge the gap between technical solutions and business needs.
✨Prepare for Problem-Solving Questions
Expect to face questions that assess your problem-solving abilities, especially regarding issues raised by in-house systems. Think of scenarios where you’ve had to analyse and rectify problems, and be ready to explain your thought process and the steps you took to resolve them.
✨Show Your Commitment to Compliance
Given the regulatory nature of the banking sector, be prepared to discuss how you stay updated on compliance policies and risk management. Highlight any relevant training or experiences that demonstrate your understanding of regulatory requirements and your commitment to adhering to them.