Castle Trust Bank
Business Intelligence Analyst
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
"Turn Data Into Insight. Help Shape the Future of Banking"
At Castle Trust Bank, we believe data is one of our most valuable assets. We're investing heavily in our data capabilities, building a modern data platform that enables better decision-making, stronger governance, greater self-service analytics and the exciting potential of AI-powered insight.
This role is based in Basingstoke on a Hybrid basis working 3 days office and 2 days at home.
The role and what you'll deliver:
We're looking for a Business Intelligence Analyst to join our growing Data Team. This is an exciting opportunity for someone who enjoys working with stakeholders, solving business problems with data and creating impactful reporting solutions that drive real business outcomes.
Using technologies such as Power BI, Microsoft Fabric and Power Automate, alongside languages including DAX and SQL, you'll help transform complex data into trusted, meaningful insight across our Savings, Mortgage and Point-of-Sale Lending businesses.
Whether you're developing dashboards, supporting self-service analytics, improving data quality or contributing to our data governance framework, you'll play an important role in helping colleagues across the Bank unlock greater value from data.
You will:
Reporting and Analytics
- Develop engaging dashboards, reports and analytical solutions that support strategic and operational decision-making
- Work closely with stakeholders to understand reporting requirements and translate them into effective, user-friendly data solutions
- Build and maintain Power BI reporting solutions, presentation-layer datasets and semantic models in line with best practice
- Support business change initiatives by delivering insightful and accurate reporting outputs
Data Quality & Governance
- Validate, test and reconcile data to ensure reporting outputs are trusted and reliable
- Investigate data quality issues and work with Data Engineering and business teams to improve data integrity
- Contribute to data dictionaries, report catalogues, business definitions and lineage documentation
- Support business data owners and report owners in maintaining good governance and reporting standards
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Self-Service Analytics & Adoption
- Support colleagues in making effective use of reporting and analytical tools
- Promote the adoption of self-service analytics and governed data products
- Provide guidance and training to super users, report owners and data stewards
- Help improve data literacy and reduce reliance on manual reporting processes
Continuous Improvement & Innovation
- Contribute to the ongoing evolution of the Bank's modern data platform
- Support emerging AI-enabled analytics and natural language reporting capabilities
- Identify opportunities to improve reporting usability, performance and stakeholder experience
- Become a trusted source of expertise on data, reporting solutions and business processes
What you'll bring:
We're looking for someone who combines strong technical skills with a genuine curiosity about how businesses use data.
We're seeking a highly analytical and detail-oriented individual who can turn data into actionable insights, build strong stakeholder relationships, champion data quality and governance, and support the adoption of data-driven decision-making through modern analytics and AI-enabled technologies.
You will also have the following:
Essential
- Experience designing and delivering Business Intelligence solutions using Power BI
- Strong SQL querying, data analysis and data validation skills
- Strong understanding of DAX, including measures, calculated columns, time intelligence and performance optimisation
- Proven ability to gather requirements, engage stakeholders and translate business needs into effective reporting and analytical solutions
- Experience supporting data testing, validation and quality assurance activities
- Understanding of data governance principles including business definitions, ownership, lineage and reporting standards
- Awareness of AI-enabled analytics, Copilot and natural language reporting capabilities
Desirable
- Exposure to Microsoft Fabric including Lakehouses, Warehouses, Dataflows Gen2 and Semantic Models.
- Experience designing dimensional models and star schemas to support reporting and analytics solutions
- Azure data services, Databricks or cloud-based analytics platforms
- Agile delivery environments
- Data dictionaries, report catalogues or data lineage initiatives
- Experience within Financial Services or other regulated environments
- Microsoft Certified: Power BI Data Analyst Associate, Fabric Analytics Engineer or similar
- Degree (or equivalent experience) in Data Analytics, Business Intelligence, Information Systems or a related discipline
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Why join Castle Trust Bank?
- Competitive salary
- Performance bonus (based on individual and company performance)
- Generous contributory pension through Hargreaves Lansdown
- Life Assurance
- 25 days' holiday + option to buy/sell 5 days
- Additional paid volunteering day
- Private healthcare through Equipsme (includes cash back for Dental and Optical treatment)
- Free access to BHSF Rise EAP to support colleague health and wellbeing
- Gym discounts
- Season ticket travel loans (if applicable)
- A supportive, inclusive culture where your work has real impact
Caught your attention? If so, we'd love to talk to you and tell you more about what it's like to work at Castle Trust Bank - The Place To Work!
Castle Trust Bank is an equal opportunity employer where we celebrate diversity and are committed to creating an inclusive environment for all our colleagues to thrive. We welcome applications from all and will not discriminate against any status/characteristic protected by law and will always base our decisions on merit.
We are proud to support people with disabilities and are committed to be a Disability Confident employer. If you are a person with a disability and meet the minimum criteria for the role you will be offered an interview. Should you require any reasonable adjustment to support you in your application for one of our opportunities, please contact talent@castletrust.co.uk
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills