* On-job learning of new technology & tools to deliver work
The Role
To support and lead the data modelling activities on cloud for Commercial lending data
Your responsibilities:
Key Responsibilities
1. Data Modelling
* 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.
* 2. Requirement Analysis
* Analyse and document business requirements from Lending SMEs, Credit Risk, Finance, and Regulatory Reporting.
* Translate requirements into accurate and reusable data models.
3. Metadata & Documentation
* 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.
4. Data Quality & Lineage
* 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.
5. Cloud, Data Lake & Lakehouse (Modelling Only)
* 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).
6. Regulatory & Reporting Support
* Ensure models support regulatory obligations (IFRS9, PRA/EBA returns, BCBS 239).
* Support lineage and traceability required for audit and compliance reviews.
7. Collaboration
* Work closely with Lending SMEs, Data Engineers, DBAs, Data Quality, and Reporting teams.
* Provide modelling inputs during solution design and delivery phases.
Your Profile
Essential skills/knowledge/experience:
A. Data Modelling Expertise
* Strong hands on experience with conceptual, logical, and physical data modelling.
* Proficiency with data modelling tools (ERwin, ER/Studio, PowerDesigner).
* Experience maintaining glossaries, dictionaries, and model documentation.
B. Lending Domain Knowledge
* 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.
C. Technical Skills
* 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 NoSQL stores (MongoDB, Cassandra) is beneficial.
* D. Cloud & Lakehouse (Modelling focused)
* 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.).
E. Data Warehousing Concepts
* Strong understanding of Kimball and/or Inmon methodologies.
* Experience supporting ETL/ELT design with accurate models.
F. Governance, Controls & Regulations
* Knowledge of BCBS 239 principles.
* Understanding of regulatory and risk data needs (IFRS9, PRA/EBA, stress testing).
* Ability to support audit/compliance documentation.
G. Professional & Analytical Skills
* 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.
Desirable skills/knowledge/experience:
* 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
LA International is a HMG approved ICT Recruitment and Project Solutions Consultancy, operating globally from the largest single site in the UK as an IT Consultancy or as an Employment Business & Agency depending upon the precise nature of the work, for security cleared jobs or non-clearance vacancies, LA International welcome applications from all sections of the community and from people with diverse experience and backgrounds.
Award Winning LA International, winner of the Recruiter Awards for Excellence, Best IT Recruitment Company, Best Public Sector Recruitment Company and overall Gold Award winner, has now secured the most prestigious business award that any business can receive, The Queens Award for Enterprise: International Trade, for the second consecutive period.
