Lead Business Intelligence Developer

Castle Trust Bank; Basingstoke; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A fintech challenger bank in Basingstoke is seeking a Lead Business Intelligence Developer. In this role, you'll design and deliver high-quality data solutions, including Power BI reporting, while managing a team. Essential skills include DAX and SQL, and you'll need strong data modelling capabilities. The position supports hybrid working, offering a competitive salary, annual performance bonus, generous pension scheme, and excellent wellbeing benefits including healthcare and gym discounts.

Benefits

Annual performance related bonus

Generous contributory pension scheme

25 days annual leave plus bank holidays

Healthcare benefits

Discounted gym membership

Free eye test vouchers

Qualifications

• Adept at converting business requirements into Power BI dashboards and data extracts.
• Strong skills in data modelling to translate requirements into specifications.
• Experienced in testing reports and model changes before delivery.
• Proven ability to manage or mentor small teams effectively.

Responsibilities

• Own the data model design and deliver high-quality data solutions.
• Manage and lead a team of Business Intelligence Analysts.
• Ensure data integrity and implement improvements in data governance.
• Engage with stakeholders to understand reporting requirements.

Skills

DAX

SQL

Data modelling

Team management

Power BI

Job description

The opportunity

We have an opportunity for a Lead Business Intelligence Developer to join us on the exciting and rewarding path we are taking here 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.

This role plays a leading role within the Data team. You will own the data model design and deliver high quality data solutions from this platform, including Power BI reporting and data extracts. You will engage with stakeholders across the business to understand all aspects of the source systems and reporting requirements and then convert these into models and logic to enable suitable reporting to be built.

This will enable high-quality data solutions to be delivered, either as interactive and engaging Power BI reports, training/documentation for others to use their data models, or as data extracts. You will ensure reports are tested to a high standard before sharing with stakeholders, as well as put in place controls and checks to ensure data integrity is maintained. Delivering improved data governance and controls is another key responsibility for this role.

In addition, you will also have responsibility for managing and leading a team of Business Intelligence Analysts, setting clear objectives and managing them against these, ensuring collaboration and teamwork, and driving a culture of technical and personal development within the team.

This role will benefit a hybrid working arrangement, to be based between our Basingstoke office (3 days) and working the rest of the week from home.

What we are looking for in you…

Essential/minimum

• Adept at converting business requirements into the required reporting, be those Power BI dashboards, paginated reports, or data extracts, where strong DAX and SQL skills will be beneficial
• Strong conceptual data modelling skills, enabling translation of business requirements into clear specifications for the data engineering team
• Adept at testing model changes, extracts and new reports, to ensure that these are delivered smoothly to stakeholders
• Experience in managing or mentoring small teams to deliver to high standards and best practice. Initially there will be two direct reports to this role

Desirable

• Inquisitive, wanting to understand source systems, data models, control processes, and business change demands, to help them deliver quality solutions
• Expert in data security within Power BI, with experience in implementing security controls
• Keep up to date with technology developments, demonstrating a keen interest in the evolution of the data solutions landscape for reporting and analytics
• Experience with governance and change management, including CI/CD processes
• Demonstrate a passion for ensuring timely availability and high quality of your reporting and extracts

What’s in it for you…

As well as a competitive salary, we offer an annual performance related bonus based on individual and company performance. In addition, a generous contributory pension scheme through Hargreaves Lansdown, life assurance, 25 days annual leave (plus bank holidays on top) with the option to buy/sell up to 5 additional days (terms apply). In addition, you will receive an extra day paid annual leave for Volunteering.

Wellbeing is also high on our agenda, and we offer healthcare benefits through Equipsme. In addition, all colleagues have free access to BHFS Rise EAP to support their health and wellbeing. We also offer free eye test vouchers and discounted gym membership, and if that’s not enough, we also offer season ticket travel loans (if applicable).

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].