Job Specifications
Data Modeller – Commercial Lending
London, UK (2 days pw onsite) | £500/day (Inside IR35) | 6-month contract
Our client, a top global organization, is looking for a Data Modeller with strong Commercial / Corporate Lending domain expertise to join a large-scale cloud data transformation programme within Financial Services. This is a hands-on role where you will shape the data foundations supporting lending, risk, and regulatory reporting across a modern cloud and lakehouse architecture. You will lead data modelling activities across Commercial Lending domains, ensuring that business processes, regulatory obligations, and downstream analytics requirements are accurately reflected in scalable, high-quality data models. You’ll work closely with Lending SMEs, Credit Risk, Finance, Data Engineering, and Governance teams to deliver enterprise-grade data assets in a cloud environment.
Key Responsibilities
Develop and maintain conceptual, logical, and physical data models
Model core Lending entities including:
Loans, Facilities, Drawdowns
Collateral, Covenants, Security structures
Exposure, Repayments, Party hierarchies
Translate complex business requirements into reusable and scalable data structures
Embed data quality rules, lineage, and governance standards
Support regulatory reporting requirements including:
IFRS9
PRA / EBA returns
BCBS 239
Design models suited for cloud and lakehouse environments (S3, Iceberg, Delta, Hudi)
Collaborate with Data Engineers to ensure effective implementation in Bronze/Silver/Gold (Medallion) layers
Maintain documentation, glossaries, and modelling standards
Essential:
Strong hands-on experience in conceptual, logical, and physical data modelling
Deep understanding of Commercial Lending domain concepts
Loan lifecycle (origination → servicing → closure)
Syndications, bilaterals, exposure, accruals
Collateral and covenant structures
Experience with regulatory data frameworks (IFRS9, BCBS 239)
Strong SQL
Experience modelling for cloud data platforms
Highly Desirable:
Experience with LoanIQ
AWS / Snowflake / Redshift / Lakehouse exposure
Knowledge of Kimball or Inmon methodologies
If this is relevant to your experience, please apply with your CV and we’ll be in touch.
About the Company
We are an independent recruitment consultancy driven to provide an excellent service to our clients and candidates. We take pride in our service and delivery and have built strong, transparent relationships with all our customers.
How we can help you:
If you're looking to resource an entire project or to fill one strategic position, please get in touch on 020 3887 8700 / 0117 403 8888 or email your requirements to hello@macleanmoore.com - we pride ourselves on our speed of response and are looking forward to hearing from...
Know more