Data Engineer

City & Capital are currently working with one of the UK's most dynamic and fast-growing specialist property finance lenders who are renowned for their innovation and tailored products to suit the needs of a broad range of professional borrowers, such as property developers and investors.

Our client currently offers a range of property-backed loans to cover bridging finance, development exits, commercial mortgages and buy to let. Due to success to date, the lender has now doubled the size of their UK loan book and team 6 times in the last 6 years, with plans to achieve this for a 7th time across the coming period.

Due to these increasing levels of high activity, they are generating more and more customer and performance data than ever before and are embarking on a key project to best manage & utilise this. An agile and robust data management and utilisation plan will be key to the attainment of this.

Our client is therefore seeking an individual who will play an integral role in building & maintaining the businesses core data infrastructure & to deliver on the demands as outlined below.

You will work closely with the lenders Chief Mortgage Officer & Senior Data Lead within the role. This is also a role that comes with plenty of progression potential for those that are successful in the role.

About the Role

As a Data Engineer, you will play a key role in building and maintaining the business’s core data infrastructure. Working closely with the Chief Mortgage Officer, Senior Data Lead and Market Analysts you will enable scalable reporting, clean data flows, and analytics-ready datasets that underpin everything from product development and underwriting to compliance and performance tracking.

You’ll take ownership of automated data pipelines, cloud infrastructure within Microsoft Fabric, and integrations with platforms like Salesforce and core lending systems. Your work will be vital to ensuring data is accurate, structured, and available powering both real-time business intelligence and future advanced analytics.

Key Responsibilities

• Design and develop automated ETL/ELT pipelines using SQL and Python
• Integrate internal/external data sources via APIs and platform connectors
• Model and structure data for scalable analytics (e.g., star/snowflake schemas)
• Administer Microsoft Fabric Lakehouse and Azure services
• Optimise performance across queries, datasets, and pipelines
• Apply data validation, cleansing, and standardisation rules
• Document pipeline logic and contribute to business-wide metadata catalogues
• Collaborate with BI, Change, and Product teams to align data outputs to needs
• Support groundwork for future data science and machine learning initiatives

The successful applicant will be proficient in SQL and Python, with a proven track record of building and maintaining ETL/ELT pipelines. Experience working with Microsoft Fabric, Azure Data Factory, and modern Lakehouse or data warehouse architecture is essential.

You’ll demonstrate a strong focus on data quality and governance and be adept at integrating third-party APIs and transforming raw data into analytics-ready assets.

Prior experience in financial services or lending is preferred, and the ability to communicate data requirements clearly across business teams will be key to success in this role. You’ll be a technically strong data professional with hands-on experience in pipeline development, cloud-based data infrastructure, and performance optimisation.

You will be at your best when working collaboratively in fast-paced environments and when translating complex business needs into structured, reliable data systems.

On?Offer

Our client is ideally looking to pay between £50k - £705as a basic salary for the ideal individual, relevant to experience. Higher offers may also be considered for exceptional talent and potential. Salary will be complemented by a favourable bonus scheme too, that will significantly enhance annual earnings.

Most notably, due to our clients continued growth & strong and proven promote from within policy, this is also a role that comes with plenty of progression potential, where excellent performance is delivered. In turn, this could see you propel both career standing & salary within, as you make a real impact on the role and business.

The?role?will?be?based?in?our?clients?Mayfair?offices,?offering?a?collaborative?and?fast paced working environment.

There is a reasonable amount of urgency to fill this position as you might expect, for the reasons outlined. We do not expect this role to be on the market for long!

Therefore, if this role does sound like one that you are both qualified for and interested in then we look forward to your application as soon as possible. We do not expect this role to be on the market for long!

We will aim to review your application as soon as possible and get back to you with an update following.

We look forward to hearing from you.

Kind Regards,

The City and Capital Team