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 six times in the last six years, with plans to achieve this for a seventh time in the near future.  

With increasing volumes of customer and performance data, our client is embarking on a key project to best manage and utilise their information. An agile and robust data management and utilisation plan will be critical to their continued success.

They are therefore seeking a Data Engineer who will play an integral role in building and maintaining the businesses core data infrastructure.

You will work closely with the lenders Chief Mortgage Officer & Senior Data Lead within the role and Market Analysts. 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 looking to pay between £50k - £70k as a basic salary, depending on experience. Higher offers may also be considered for exceptional talent and potential. This is complemented by a favourable bonus scheme, that will significantly enhance annual earnings. 

Due to our clients continued growth and strong and proven promote-from-within policy, this is also a role that offers substantial career and salary progression potential for high performers.

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. We do not expect this role to be on the market for long! 

Therefore, if this role does sound like a match for your skills and ambitions, please apply as soon as possible.

We will review applications promptly and get back to you with an update. 

We look forward to hearing from you. 

The City + Capital Team