Business Intelligence Analyst

Castle Trust Bank; England; Hybrid; GBP 38,000 - 45,000; Full time

Job summary

A fintech challenger bank is looking for a Business Intelligence Analyst to join their Data & Analytics team. This role involves delivering data insights, educating users, and improving model designs to support business change. The ideal candidate has experience with Power BI and data analytics. This position offers a competitive salary and a hybrid working arrangement between the office and home.

Benefits

Performance related bonus

Contributory pension scheme

Healthcare benefits

Discounted gym membership

Free eye test vouchers

Qualifications

• Minimum 2 years of experience in a relevant role.
• Experience in designing MI/BI solutions using Power BI is essential.
• Knowledge of MS Azure Modern Data Warehouse Architecture is advantageous.

Responsibilities

• Collaborate with the Head of Data to deliver insights.
• Educate super users on data solutions and best practices.
• Document and enhance model designs for company data.

Skills

Business Intelligence

SQL

Power BI

Data Visualization

Data Analysis Skills

Tools

Cognos

QlikView

SSRS

Tableau

SSIS

Data Warehouse

Data Modeling

Job description

The opportunity

We have an opportunity for a Business Intelligence Analyst 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.

Our Data & Analytics team is part of the Technology function of Castle Trust Bank and aims to provide data and insights to internal and external customers using the latest Microsoft tools. The team is in a key phase and has a strategic vision of becoming a centre of excellence within the organisation.

The team has replaced all the legacy data solutions, upgraded the technology and put the core data foundations in place. However there is still much more to do and some exciting projects to work on such as developing new reporting, optimising data solutions and ensuring data quality and standards.

The role involves working with the Head of Data, the rest of the data team and broader Technology team to deliver data and insights to support business change initiatives as well as to educate super users on the use of data solutions. The role also offers the opportunity to become an acknowledged expert in the company’s data and to document and improve the model designs.

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

The role would suit a talented Business Intelligence Analyst who has some experience but most importantly has talent and potential. Experience in Financial Services or a modern data platform is desirable but not essential. Experience in designing MI/BI solutions using Power BI is key in order to be successful in this role. You should have expertise in best practices for Power BI model development, reporting design and stakeholder collaboration to deliver data solutions.

You will be proficient in partnering with business teams to support data-driven insights for business performance or regulatory reporting/requirements. It would be advantageous if you have some knowledge of MS Azure Modern Data Warehouse Architecture and Agile methodology in addition to possessing knowledge and experience of writing SQL queries.

What is equally important is that you are highly numerate and analytical with an ability to deliver high standards of work and pay meticulous attention to detail. Your problem‑solving skills will be strong in addition to possessing excellent communication skills.

Responsibilities

In this role you will:

• Collaborate with the Head of Data and the data team to deliver data and insights to support business change initiatives.
• Educate super users on the use of data solutions and best practices.
• Document and improve model designs and become an acknowledged expert in the company’s data.

Whats in it for you

As well as a competitive salary (guide salary to £45,000 depending on skills and experience) we offer an annual performance related bonus, 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), and an extra day paid annual leave for volunteering.

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

Employment Type

Full‑Time

Experience

Years: minimum 2 years (desired)

Vacancy

1

Key skills

• Business Intelligence
• Cognos
• SQL
• Power BI
• QlikView
• Data Visualization
• SSRS
• Tableau
• SSIS
• Data Modeling
• Data Warehouse
• Data Analysis Skills

Equal Opportunity & Disability Confidence

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.