More jobs:
Data Modeller Commercial Lending Domain
Job in
Coventry, West Midlands, CV1, England, UK
Listed on 2026-10-26
Listing for:
Avance Consulting
Full Time
position Listed on 2026-10-26
Job specializations:
-
IT/Tech
Data Engineering, Data Warehousing
Job Description & How to Apply Below
The Role
To support and lead the data modelling activities on cloud for Commercial lending data
Your responsibilities:Key Responsibilities
- Develop and maintain conceptual, logical, and physical data models for Lending data domains.
- Model Lending entities such as Facilities, Loans, Drawdowns, Collateral, Covenants, Parties, Exposure, and Repayments.
- Ensure models support business requirements, regulatory needs, and data product consumption patterns.
- Define data structures, relationships, keys, and data transformations required for implementation.
- Analyse and document business requirements from Lending SMEs, Credit Risk, Finance, and Regulatory Reporting.
- Translate requirements into accurate and reusable data models.
- Create and maintain data dictionaries, glossaries, and definitions for Lending data.
- Document modelling decisions and data element definitions.
- Ensure consistent naming conventions and modelling standards.
- Incorporate data quality rules into models (validations, reference data, master data requirements).
- Support lineage documentation from upstream Lending systems to downstream applications.
- Work with Data Quality and Governance teams to ensure traceability and compliance.
- Design models suitable for cloud data platforms and lakehouse environments (Iceberg, Delta, Hudi).
- Work with Data Engineers to ensure models are implemented effectively in S3 based or lakehouse environments.
- Support schema evolution, partitioning definitions, and Medallion modelling (Bronze / Silver / Gold).
- Ensure models support regulatory obligations (IFRS9, PRA/EBA returns, BCBS 239).
- Support lineage and traceability required for audit and compliance reviews.
- Work closely with Lending SMEs, Data Engineers, DBAs, Data Quality, and Reporting teams.
- Provide modelling inputs during solution design and delivery phases.
- Strong hands on experience with conceptual, logical, and physical data modelling.
- Proficiency with data modelling tools (ERwin, ER/Studio, Power Designer).
- Experience maintaining glossaries, dictionaries, and model documentation.
- Must understand key Lending concepts including:
- Loan lifecycle (origination → booking → drawdown → servicing → closure)
- Facilities, bilaterals, syndications, exposure, risk ratings
- Interest accruals, schedules, restructuring
- Security structures, collateral, covenants
- Customer/party hierarchies
- Experience with systems like LoanIQ, is highly advantageous.
- Strong SQL (DDL, DML, performance optimisation).
- Scripting in PL/SQL, T SQL, Python or Shell (desirable).
- Experience with relational and analytical databases (Oracle, SQL Server, PostgreSQL, Redshift, Snowflake).
- Exposure to No
SQL stores (MongoDB, Cassandra) is beneficial.
- Understanding of modern data lake/lakehouse modelling patterns.
- Experience with AWS components: S3, Glue Catalog, Redshift, Athena.
- Knowledge of Iceberg/Delta/Hudi modelling constraints (schema evolution, partitioning etc.).
- Strong understanding of Kimball and/or Inmon methodologies.
- Experience supporting ETL/ELT design with accurate models.
- Knowledge of BCBS 239 principles.
- Understanding of regulatory and risk data needs (IFRS9, PRA/EBA, stress testing).
- Ability to support audit/compliance documentation.
- Excellent analytical and problem solving abilities.
- Strong communication with both technical and business stakeholders.
- Ability to translate complex processes into clear data structures.
- High attention to detail.
- Self-driven with a strong desire to meet deadlines and to work accurately while keeping in mind compliance
- Innovation ideas, ability, courage and desire to suggest and develop novel approaches
- Good written and verbal communication in English
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×