Commercial Lending Data Modeller – Cloud & Lakehouse

Avance Consulting; England; On-site; GBP 70,000 - 110,000; Full time

Job summary

Avance Consulting in the United Kingdom seeks a Senior Data Modeller to lead data modelling on cloud for Commercial lending data. You will design conceptual, logical, and physical models for lending entities and ensure alignment with business and regulatory needs.

Work with Lending SMEs, Data Engineers, and Governance teams to deliver scalable lakehouse-ready models on AWS, with emphasis on data quality, lineage, and documentation. Strong SQL and experience with lending ecosystems are required.

Qualifications

• Hands-on data modelling across conceptual, logical and physical layers.
• Experience with lending data concepts and risk/regulatory needs.
• Proficiency in SQL and data transformation concepts.

Responsibilities

• Lead data modelling for lending data domains and cloud platforms.
• Develop models for Facilities, Loans, Collateral, Covenants, Parties, Exposure and Repayments.
• Ensure alignment with business, regulatory and data product needs.
• Create data dictionaries and maintain modelling standards.

Skills

Data modelling

Cloud modelling

Stakeholder comms

Lending domain knowledge

SQL proficiency

Regulatory concepts

Tools

ERwin

ER/Studio

PowerDesigner

Snowflake

Job description

Avance Consulting in the United Kingdom seeks a Senior Data Modeller to lead data modelling on cloud for Commercial lending data. You will design conceptual, logical, and physical models for lending entities and ensure alignment with business and regulatory needs.

Work with Lending SMEs, Data Engineers, and Governance teams to deliver scalable lakehouse-ready models on AWS, with emphasis on data quality, lineage, and documentation. Strong SQL and experience with lending ecosystems are required.