Lead Data Engineer

AI overview

Lead the design and delivery of Castle Trust Bank's next-generation data platform within a modern Azure-Databricks ecosystem, promoting engineering excellence and mentoring junior engineers.

The opportunity

We have an opportunity for a Lead Data Engineer 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 is a unique opportunity where you will lead the delivery of Castle Trust Bank’s next-generation data platform. You’ll take ownership of core architecture and engineering practices across a modern Azure-Databricks ecosystem, enabling advanced analytics, machine learning, and AI use cases.

In this leadership role, you’ll drive the design, development, and governance of data pipelines and infrastructure, ensuring high availability, integrity, and compliance. You’ll collaborate closely with business and technology stakeholders to translate strategic goals into scalable data solutions, while mentoring others and promoting engineering excellence across the organisation.

The role is based at our Basingstoke office with hybrid working available (a minimum of 3 days per week in the office).

What we are looking for in you…

From a technical perspective:

Essential

  • Expertise with SQL, especially Databricks SQL;
  • Demonstrable data model design expertise, e.g. star schema;
  • Knowledge of Azure Modern Data Warehouse Architecture including Azure Synapse, Databricks, Delta Lake, Unity Catalog;
  • Experience of pipeline orchestration management (e.g. Synapse Analytics pipelines);
  • ITIL change management and incident management experience;
  • Experience implementing monitoring and alerting for data pipelines;
  • Expertise implementing data quality controls;
  • Experience with data lineage, data dictionaries and glossaries.

Desirable

  • Familiarity with real-time data processing;
  • Experience using Azure DevOps, or equivalent, for change and code management;
  • Expertise in Power BI, or equivalent, solution technology;
  • Expertise in Python, DAX and other data languages used within Azure, Databricks, Power BI;
  • Expertise in legacy data solutions/systems (e.g. SQL Server, SSIS, SSRS);
  • Ability to train users in data solutions/tooling (e.g. Databricks).

What is also important to us is that you have experience of working in a regulated finance environment in a similar capacity with financial modelling experience and experience of delivery under Agile methodology. You will need to be highly numerate, analytical and business value orientated with experience in documentation and specification writing. You will have strong written and verbal communication skills, with the ability to translate complex technical concepts for non-technical stakeholders and possess strong stakeholder management skills. You will have previous experience in managing a small team and mentoring junior engineers to enable data capability across business teams. You’ll be a natural problem solver with a passion for delivering solutions, and a proactive approach in using your initiative.

A relevant Microsoft or cloud-based certification is important, and it would be advantageous if you have and ITIL foundation qualification and/or degree in Computer Science, Data Engineering, Data Science or similar.

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 private healthcare through Equipsme. In addition, all colleagues have free access to TELUS Health 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.

Please note that visa sponsorship cannot be provided for this role and applicants should have the right to work in the UK.

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]

Check out our careers page: https://www.castletrust.co.uk/careers/who-we-are   

Perks & Benefits Extracted with AI

  • Health Insurance: Wellbeing is also high on our agenda, and we offer private healthcare through Equipsme.
  • Season ticket travel loans: We also offer season ticket travel loans (if applicable).
  • Paid Time Off: 25 days annual leave (plus bank holidays on top) with the option to buy/sell up to 5 additional days.

The journey so farCastle Trust Bank was launched as 'Castle Trust' in October 2012 with backing from leading US private equity firm J.C. Flowers & Co., initially offering investment products and specialist mortgage finance. J.C. Flowers & Co. continue to be Castle Trust Bank's principal shareholder to this day.As the business grew, it expanded its operations with the acquisition of Omni Capital Retail Finance in 2017, adding point of sale finance to its range of services.Recognising an opportunity to develop the business further, Castle Trust began working on its application for a banking licence in 2018. Following a scheme of arrangement, customers voted by an overwhelming majority to convert their investments into savings, giving Castle Trust their support to become a bank.In June 2020, Castle Trust became a fully authorised bank and changed its name to Castle Trust Bank. At the same time, the bank began offering customers approaching maturity the option to reinvest into a new savings account.With offices in the City of London and Basingstoke, Castle Trust Bank serves over 200,000 customers across its savings, specialist finance and retail finance arms. We put customers first We are forward thinking We take professional pride We achieve together We are open and transparent Where you’ll be working Our head office in the City of London is home to our technology, finance, marketing, risk, treasury, and legal teams. We are a short walk from Bank and Liverpool Street tube stations. We have a larger operations centre based in Basingstoke, where our customer services, lending, HR, additional marketing and technology, underwriting, finance and compliance teams reside. Our Basingstoke office is also a short distance from the train and bus stations.What we have to offer: We have ambitious plans and we're always looking for remarkable people to join our talented teams. As well as a competitive base salary we can offer you: Vitality at Work which includes 24-hour GP access, gym discounts, talking therapies and much more Perkbox - an employee engagement platform with perks, discounts and benefits including free mobile phone insurance and gym memberships discounts include ASOS, M&S, EE and free coffee! Life Insurance Contributory Pension Scheme 25 days holiday entitlement Season Ticket Loans, Eye Tests Recognition Schemes Social, Charity and team events Discretionary Bonus You can keep up to date with company news, vacancies and what it's like to work here by following our LinkedIn page.

View all jobs
Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Lead Data Engineer Q&A's
Report this job
Apply for this job