Data Modeller

We are looking for an experienced Data Modeller with a strong Investment Banking background to support complex data initiatives across trading, risk, settlements, and regulatory reporting.

This is a niche, hands-on modelling role (not architecture) suited to someone who can work closely with business SMEs and technical teams to design robust logical and physical data models.

Key Responsibilities

• Develop logical and physical data models for data warehouses, data lakes, and data marts
• Collaborate with business SMEs to translate requirements into scalable and high-quality data models
• Support capital markets data flows across equities, Fixed Income, derivatives, trade and position data
• Apply performance optimisation and modelling best practices
• Use leading data modelling tools such as ERwin, PowerDesigner, ER/Studio, or similar

Must-Have Skills

• 7+ years of overall data modelling experience
• 4-5+ years dedicated to logical and physical modelling
• Strong Investment Banking domain knowledge (trading, risk, settlements, collateral, reference data, regulatory reporting)
• Hands-on experience with data modelling tools (ERwin, PowerDesigner, ER/Studio or similar)
• Strong understanding of capital markets products and data flows
• Strong SQL skills and performance-driven model design experience
• Ability to work effectively with business and technology stakeholders

Nice to Have

• Exposure to Azure, AWS, or GCP
• Experience with data governance, metadata, and data lineage
• Experience in regulatory or risk data programmes (BCBS 239, FRTB, MiFID)