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 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
✨Tip Number 1
Get your hands dirty with SQL and PowerShell before the interview. We all know that practice makes perfect, so dive into some real-world scenarios or projects. This will not only boost your confidence but also give you solid examples to discuss when they ask about your experience.
✨Tip Number 2
Network like a pro! Reach out to current or former employees in similar roles on LinkedIn. We can learn a lot from their experiences, and who knows, they might even put in a good word for us when we apply through our website!
✨Tip Number 3
Prepare for those tricky technical questions by brushing up on your troubleshooting skills. Think of common issues in production support and how you'd tackle them. We want to show that we can think on our feet and solve problems efficiently.
✨Tip Number 4
Don’t forget to showcase your soft skills! Communication is key in an L2/L3 role, especially when working with developers and infrastructure teams. We should be ready to demonstrate how we can collaborate effectively and keep everyone in the loop during incidents.
We think you need these skills to ace Application Support Analyst (L2/L3) – SQL & Powershell - Banking
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your SQL and PowerShell skills, as well as any experience in L2/L3 support. We want to see how your background aligns with the role, 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 passionate about application support and how your technical skills can help us tackle complex production issues. Keep it concise but impactful!
Showcase Problem-Solving Skills: In your application, give examples of how you've resolved tricky issues in the past. We love candidates who can analyse problems and come up with effective solutions, so share those success stories with us!
Apply Through Our Website: We encourage you to apply directly through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates from us!
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 show your hands-on experience.
✨Show Off Your Scripting Skills
Since this role requires strong scripting abilities, be ready to talk about your experience with PowerShell, Bash, or Python. Consider preparing a small script or two that you've written in the past, and be ready to explain how it solved a specific problem.
✨Understand the Production Environment
Familiarise yourself with the production support landscape, especially in financial systems. Be prepared to discuss how you've handled incidents, performed root cause analysis, and worked with developers to implement permanent fixes.
✨Demonstrate Problem-Solving Skills
This isn't just about technical skills; it's also about how you approach problems. Prepare examples of complex issues you've resolved, focusing on your analytical process and the steps you took to ensure system reliability.
