DescriptionThe 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
Whats in it for you
As well as a competitive salary we offer an annual performance related bonus based on individual and company 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 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 thats not enough we also offer season ticket travel loans (if applicable).
Caught your attention If so wed love to talk to you and tell you more about what its 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
Required Experience:
IC
DescriptionThe opportunityWe 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 ...
DescriptionThe 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
Whats in it for you
As well as a competitive salary we offer an annual performance related bonus based on individual and company 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 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 thats not enough we also offer season ticket travel loans (if applicable).
Caught your attention If so wed love to talk to you and tell you more about what its 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
Required Experience:
IC
View more
View less