Business Intelligence Analyst
“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.
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.
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 [email protected]
https://www.castletrust.co.uk/careers/who-we-are
Skills Required
- 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 optimization
- Ability to gather requirements, engage stakeholders, and translate business needs into 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
- Exposure to Microsoft Fabric, including Lakehouses, Warehouses, Dataflows Gen2, and Semantic Models
- Experience designing dimensional models and star schemas
- Experience with Azure data services, Databricks, or cloud-based analytics platforms
- Experience in Agile delivery environments
- Experience with data dictionaries, report catalogues, or data lineage initiatives
- Experience within financial services or another regulated environment
- Microsoft Certified: Power BI Data Analyst Associate, Fabric Analytics Engineer, or similar certification
- Degree or equivalent experience in Data Analytics, Business Intelligence, Information Systems, or a related discipline
What We Do
Traditional financial service providers are often burdened with costly overheads including expensive branch networks, inflexible technology and huge armies of people. At Castle Trust Bank, we keep our overheads to a minimum and we use savings proceeds to fund our lending solutions. In the past, we offered investment products to our customers which proved very popular. As a bank, we now offer savings accounts, giving our customers the added benefit of FSCS protection for their deposits. Our history means that we have a strong understanding of what our customers need and have built our savings range with those customers and their needs front of mind. In a complex world, we strive for openness and clarity. We place the highest importance on treating our customers fairly not just because it's the right thing to do but because we know that the trust of our customers is crucial to our future success. We recognise that for many mortgage customers, traditional solutions don't cut the mustard. These customers can often have high quality assets but unconventional income and so find it difficult to borrow at reasonable rates and on sensible terms. What experienced buy to let investors need is lending with imagination. They need a lender that recognises cash flow and net worth are not the same thing. They need a lender that is flexible in their approach and makes considered, logical decisions. Castle Trust Bank is that lender. We also offer point of sale finance through our Omni Capital Retail Finance arm. Partnering with retailers nationwide, we support their business by offering finance plans to their customers. OmniPort technology gives retailers paperless credit approval which fits seamlessly with their sales processes and customers can use our dedicated customer portal to keep up to date with their loans
