“Be the Architect of Our BI Future”
At Castle Trust Bank we pride ourselves in being a fintech challenger bank, providing specialist property mortgages, retail finance lending and savings accounts to a variety of customers.
We’re modernising our data landscape — and we’re looking for a Lead Business Intelligence Developer who wants to shape the future of reporting, modelling, and data governance in a growing fintech environment.
What you’ll lead and deliver:
In this role, you will own the data model design and delivery of high-quality reporting solutions, shaping the strategic direction of business intelligence across the Bank. You'll take pride in delivering high-quality reporting solutions using your core toolkits: Power BI, DAX for models and visualisation and SQL for data extracts. Experience with Microsoft Fabric is desirable as this is on our short-term roadmap. Improving data governance and reporting standards will be central to your impact.
Data model design will be one of your core competencies, and you’ll enjoy working with business analysts and stakeholders to translate source data and reporting needs into elegant models and insights. You’ll be skilled at stakeholder management and prioritisation, ensuring clear plans and timely delivery.
You'll lead a team of two Business Intelligence Analysts, driving a culture of technical excellence and personal development within the team.
You will have a passion for innovation, fascination with new technologies, and you'll be excited to champion them to generate business benefits.
You will play a pivotal role in helping Castle Trust become a more data‑empowered organisation — and you’ll shape the tools, processes, and habits that get us there.
This is a hybrid role based in Basingstoke, with flexibility to work 2 days from home per week.
What you’ll bring:
We are looking for a strong analytical and business-focused individual, with a commitment to delivering high-quality, reliable insight. A product-oriented mindset with a focus on delivering reusable, governed data assets that support self-service analytics. In addition, we would like you to have the following:
Essential
- Experience delivering BI solutions using Power BI, with strong DAX and SQL skills.
- Expertise in data modelling and design (e.g., Kimball).
- Strong understanding of quality assurance practices.
- Familiarity with CI/CD practices for data pipelines (e.g., Azure DevOps)
- Experience producing clear documentation and specifications.
- Confident delivering training and enabling users to adopt analytics tools effectively.
- Experience collaborating with technology, and business teams to deliver solutions.
- Awareness of modern data technologies and trends in the BI and analytics space.
Desirable
- Relevant industry certifications such as Microsoft Certified: Data Analyst Associate.
- Degree or equivalent experience in computer science or data analytics.
- Experience with implementing Microsoft Fabric to support Power BI.
- Exposure to Azure Databricks (transformation) and Azure Synapse (SQL pool)
- Understanding of financial products and platforms (e.g., savings, lending, or credit).
- Interest in machine learning or generative AI tools and techniques.
- Experience with financial modelling or performance analytics.
- A background in regulated or financial services environments.
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)
- Hybrid working (3 days in Basingstoke)
- 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 delivering BI solutions using Power BI
- Strong DAX and SQL skills
- Expertise in data modelling and design (e.g., Kimball)
- Strong understanding of quality assurance practices
- Familiarity with CI/CD practices for data pipelines (e.g., Azure DevOps)
- Experience producing clear documentation and specifications
- Confident delivering training and enabling users to adopt analytics tools effectively
- Experience collaborating with technology and business teams to deliver solutions
- Awareness of modern data technologies and trends in the BI and analytics space
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
