Business Intelligence Analyst – Basingstoke

Castle Trust Group; Basingstoke; Hybrid; GBP 40,000 - 65,000; Full time

Benefits offered by this job

Competitive salary

Performance bonus

Private healthcare

Pension

25 days holiday

Volunteer day

Gym discounts

Season ticket loans

Inclusive culture

Job summary

Castle Trust Bank is seeking a highly analytical BI Analyst to design and deliver Power BI dashboards and reporting solutions across Savings, Mortgage and Lending lines. You will collaborate with stakeholders to capture requirements, ensure data quality and promote self-service analytics while contributing to governance and platform evolution.

The role blends data analysis, governance and user enablement, backed by modern BI tooling, SQL and DAX expertise.

Qualifications

• Experience designing and delivering BI solutions with Power BI.
• Strong SQL querying, data analysis and data validation skills.
• Knowledge of DAX measures, time intelligence and performance optimization.
• Ability to gather requirements and translate business needs into reporting solutions.
• Experience supporting data testing and quality assurance activities.
• Understanding of data governance principles including lineage and reporting standards.

Responsibilities

• Develop engaging dashboards, reports and analytic solutions to support decision-making.
• Collaborate with stakeholders to translate reporting needs into data solutions.
• Build and maintain Power BI reporting solutions and semantic models.
• Support business change initiatives with insightful, accurate reporting outputs.
• Validate, test and reconcile data to ensure trusted outputs.
• Investigate data quality issues and improve data integrity with teams.
• Promote self-service analytics and governed data products.
• Contribute to the evolution of the data platform and AI-enabled analytics.

Skills

Power BI

SQL

DAX

Stakeholder engagement

Data quality & governance

Self-service analytics

Education

Degree in Data Analytics or related

Tools

Microsoft Fabric

Power Automate

Databricks

Azure

Job description

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 [e-mail]

https://www.castletrust.co.uk/careers/who-we-are