Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Provide hands-on support for critical financial systems and troubleshoot complex data issues.
- Company: Join a leading banking institution with a focus on innovation and technology.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Why this job: Make a real impact by solving challenging problems in a dynamic financial environment.
- Qualifications: Strong SQL and scripting skills, with experience in production support.
- Other info: Collaborative team culture with excellent career advancement opportunities.
The predicted salary is between 36000 - 60000 £ per year.
We are seeking a technically strong Application Support Analyst to join a production support team responsible for business-critical financial systems. This is a hands-on L2/L3 role focused on data investigation, SQL troubleshooting, scripting and automation, and resolving complex production issues at root-cause level. This is not a monitoring or ticket-routing role. You will be expected to analyse problems, write scripts, fix data and processes, and improve system reliability.
Key Responsibilities
- Provide L2/L3 production support for core applications and data flows
- Investigate data and processing issues using advanced SQL (T-SQL / PL-SQL)
- Perform data fixes, validation, reconciliations and performance analysis
- Debug batch and real-time processes across Linux and Windows environments
- Develop and maintain automation and tooling using PowerShell, Bash and/or Python
- Investigate failed or delayed batch jobs and end-to-end processing chains
- Work with developers and infrastructure teams on root cause and permanent fixes
- Support releases, deployments and controlled changes into production
- Participate in incident, problem and DR processes, including RCA
Essential Skills and Experience
- Strong, hands-on SQL experience (complex queries, joins, stored procedures, data investigation)
- Strong scripting skills in PowerShell, Bash, Python or similar
- Experience supporting production financial systems in an L2/L3 capacity
- Comfortable working directly on servers (Linux/Windows) to diagnose issues
- Experience with batch processing and scheduled workloads (Control-M, Tidal, Autosys or similar is a plus)
- Experience troubleshooting data pipelines, interfaces and downstream impacts
- Proven ability to work independently and own issues through to resolution
- Experience in asset management, custody, banking or trading environments
- Exposure to data warehouses, regulatory reporting or valuation processing
- Experience with monitoring tools (Splunk, Geneos, Dynatrace, etc.)
- Understanding of MQ or message-based integrations
Application Support Analyst (L2/L3) – SQL & Powershell - Banking in London employer: Rothstein Recruitment
Contact Detail:
Rothstein Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Application Support Analyst (L2/L3) – SQL & Powershell - Banking in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the banking and tech sectors. Attend meetups or webinars related to application support and SQL. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL scripts, PowerShell automation, and any troubleshooting case studies. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common L2/L3 scenarios. Be ready to discuss how you've tackled complex production issues in the past. We want to hear about your problem-solving process and how you ensure system reliability!
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to get noticed by our hiring team. Plus, we love seeing candidates who are proactive and engaged with our platform.
We think you need these skills to ace Application Support Analyst (L2/L3) – SQL & Powershell - Banking in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your SQL and PowerShell skills right from the get-go. We want to see how your experience aligns with the role, so don’t be shy about showcasing your hands-on experience with complex queries and scripting.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re passionate about application support and how your background in financial systems makes you a perfect fit for us. Keep it concise but impactful!
Showcase Problem-Solving Skills: In your application, give examples of how you've tackled complex production issues in the past. We love candidates who can analyse problems and come up with effective solutions, so share those success stories!
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 a few clicks and you’re done!
How to prepare for a job interview at Rothstein Recruitment
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries, joins, and stored procedures. Practising real-world scenarios where you've used SQL to troubleshoot data issues will really impress them.
✨Show Off Your Scripting Skills
Since this role requires strong scripting abilities in PowerShell, Bash, or Python, be ready to demonstrate your knowledge. Bring examples of scripts you've written for automation or troubleshooting, and be prepared to explain your thought process behind them.
✨Understand the Production Environment
Familiarise yourself with the production support landscape, especially in financial systems. Be ready to discuss how you've handled incidents, performed root cause analysis, and worked with developers to implement permanent fixes in past roles.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that test your problem-solving skills. Think about specific instances where you've resolved complex issues, improved system reliability, or dealt with batch processing challenges. Use the STAR method (Situation, Task, Action, Result) to structure your answers.