At a Glance
- Tasks: Transform data into insights that drive smart decisions across the bank.
- Company: Join a specialist bank with a focus on innovation and analytics.
- Benefits: Enjoy hybrid working, competitive salary, and generous annual leave.
- Other info: Collaborative environment with opportunities for professional growth.
- Why this job: Make a real impact by championing data-driven decision-making.
- Qualifications: Experience in Business Intelligence and strong SQL skills required.
The predicted salary is between 50000 - 65000 € per year.
Location: London (Head Office)
Hours: Monday to Friday, 9:00am–5:30pm
Working Pattern: Hybrid (50/50)
Reports to: Head of Analytics & Insights
Department: Finance – Business Intelligence
About the Role
We’re looking for a highly skilled Business Intelligence Analyst to join our Business Intelligence team, supporting our Development Finance, Wholesale and Asset Finance businesses. This role sits at the heart of how data informs decision‑making across the bank. You’ll work across the full reporting lifecycle — from requirements gathering and development through to insight generation — helping the business make smarter, data‑led decisions. You’ll also play a key role in evolving our analytics capability, championing best practice and supporting advanced analytics and AI initiatives.
Key Responsibilities
- Analytics & Business Intelligence
- Deliver analytics, BI and reporting support to Development Finance, Wholesale and Asset Finance
- Lead and promote a data‑first approach across the business
- Develop deep expertise in HTB’s data platform and reporting landscape
- Design, build and maintain high‑quality dashboards, reports and visualisations
- Continuously enhance reporting through automation and optimisation
- Data Analysis & Insight
- Write and optimise SQL queries to extract data from core banking systems
- Perform ad‑hoc analysis to support commercial and operational decisions
- Analyse data to identify trends, risks and opportunities to improve performance
- Support KPI design and development to ensure meaningful performance tracking
- Change & Transformation
- Support change and transformation projects from a data and reporting perspective
- Ensure data integrity and reporting quality across new initiatives
- Contribute to advanced analytics and AI projects aligned to the bank’s analytics strategy
- Stakeholder Collaboration
- Work closely with business stakeholders to gather requirements and deliver fit‑for‑purpose reporting
- Partner with IT, Data Platform and Transformation teams to deliver joined‑up solutions
- Engage with external data providers and technology partners where required
Who You’ll Work With
You’ll Collaborate With:
- Business Intelligence & Analytics colleagues
- Development Finance, Wholesale & Asset Finance teams
- Finance, Treasury, Risk and FP&A teams
- Data Platform, IT and Transformation teams
- External data, technology and analytics partners
What We’re Looking For
Qualifications & Experience
- Extensive experience in Business Intelligence, analytics or MI roles
- Background in Banking or Financial Services
- Strong SQL capability, working with large and complex databases
- Advanced Tableau experience (dashboards, analytics and visualisation)
- Expert‑level Excel skills
- Proven ability to deliver insight that drives business value
- Degree in a numerate, scientific or finance‑related discipline
Desirable
- Experience with Power BI
- Experience working in agile environments and using Jira
- Knowledge of data warehousing and ETL principles
- Experience working with external data sources and assessing data quality
Skills & Attributes
- Excellent analytical and problem‑solving skills
- Strong attention to detail with a focus on accuracy and data quality
- Ability to communicate complex ideas simply and clearly
- Highly organised, able to manage multiple priorities and deadlines
- Proactive, self‑motivated and comfortable working at pace
- Strong stakeholder management and relationship‑building skills
Benefits
- Competitive salary
- Discretionary annual bonus
- Hybrid working (50/50)
- 25 days annual leave (increasing with service) + Holiday Buy Scheme
- Private Medical Insurance (Bupa)
- Mental health & wellbeing support via YuLife & Bupa
- Pension scheme – 8% employer contribution (non‑contributory)
- Cycle to Work & Green Car Schemes
- Interest‑free season ticket loan
- Study support & professional memberships
- Annual volunteering day & Net Zero commitment
- YuLife Rewards – retail, lifestyle & experience discounts
If you’re a data‑driven BI professional who enjoys turning insight into impact and working at the heart of a specialist bank, we’d love to hear from you.
Business Intelligence Analyst – Commercial Portfolios in London employer: Hampshire Trust Bank
Join a leading bank in London as a Business Intelligence Analyst, where you'll thrive in a hybrid work environment that promotes a data-first culture. With competitive salaries, generous annual leave, and a commitment to employee wellbeing, this role offers exceptional growth opportunities within a collaborative team dedicated to driving impactful insights. Experience the unique advantage of working at the heart of financial decision-making while enjoying benefits like private medical insurance and study support.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Analyst – Commercial Portfolios in London
✨Tip Number 1
Network like a pro! Reach out to current employees on LinkedIn or attend industry events. It’s all about making connections that can help us get our foot in the door.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your SQL and Tableau skills. We want to demonstrate how we can turn data into actionable insights!
✨Tip Number 3
Show off your analytical prowess! Bring examples of past projects where you’ve used data to drive decisions. This is our chance to shine and prove we’re the right fit for the role.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, it shows we’re serious about joining the team.
We think you need these skills to ace Business Intelligence Analyst – Commercial Portfolios in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Business Intelligence Analyst role. Highlight your experience with SQL, Tableau, and any relevant banking or financial services background. We want to see how your skills align with what we’re looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about data and how you can contribute to our analytics team. Don’t forget to mention specific projects or achievements that showcase your expertise.
Showcase Your Analytical Skills:In your application, be sure to include examples of how you've used data to drive business decisions. We love seeing candidates who can turn complex data into actionable insights, so share those success stories with us!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets to the right people. Plus, it shows us you’re serious about joining our team at StudySmarter!
How to prepare for a job interview at Hampshire Trust Bank
✨Know Your Data Inside Out
Before the interview, dive deep into the data landscape of the company. Familiarise yourself with their reporting tools and analytics capabilities, especially SQL and Tableau. Being able to discuss specific examples of how you've used these tools in past roles will show your expertise and readiness for the position.
✨Showcase Your Problem-Solving Skills
Prepare to discuss real-world scenarios where you've tackled complex data challenges. Think about how you identified trends or risks and the impact your insights had on decision-making. This will demonstrate your analytical prowess and ability to drive business value.
✨Engage with Stakeholders
Highlight your experience in collaborating with various teams. Be ready to share examples of how you've gathered requirements from stakeholders and delivered tailored reporting solutions. This shows that you understand the importance of communication and relationship-building in a BI role.
✨Stay Current with Trends
Research the latest trends in Business Intelligence and analytics, particularly in the banking sector. Being knowledgeable about advanced analytics and AI initiatives can set you apart. Discussing these topics during your interview will show your passion for the field and your commitment to continuous learning.
