Job Title: Lead Data Modeler
Duration: 12+ months contract
Location: Toronto ON (Hybrid schedule per week)
Job Description:
Position Overview
We are seeking an experienced Senior Data Modeler with strong hands-on data modelling capabilities and direct domain experience in Capital Measurement and Capital Management within the banking industry.
The successful candidate will be responsible for designing, developing, and enhancing data models that support capital management, risk measurement, regulatory reporting, and financial data initiatives.
This role requires a combination of strong technical data modelling expertise and a deep understanding of banking capital processes, financial products, and the relationships between capital, risk, and regulatory data.
Key Responsibilities
- Design and develop conceptual, logical, and physical data models supporting capital measurement and capital management initiatives.
- Model complex financial and risk data structures, ensuring accurate representation of entities, relationships, attributes, grain, and cardinality.
- Work with business and technology stakeholders to understand capital measurement requirements and translate them into robust data models.
- Support the integration and modelling of data used in capital calculations, risk measurement, and regulatory reporting.
- Establish and maintain data lineage, metadata, and documentation across capital-related data domains.
- Understand upstream financial product data and downstream capital reporting requirements to ensure accuracy and consistency.
- Collaborate with Data Architects, Business Analysts, Risk, Finance, and Capital Management teams to deliver scalable data solutions.
- Identify gaps and inconsistencies in existing data structures and recommend improvements.
Required Qualifications
Capital Measurement & Management Domain Experience - Mandatory
- Direct professional experience supporting capital measurement or capital management initiatives within a banking environment.
- Strong understanding of capital-related data, financial products, and banking risk or regulatory requirements.
- Experience modelling data used in capital calculations, capital adequacy, capital management, or capital reporting.
- Ability to clearly explain previous capital-related initiatives and the data models personally designed or developed.
Hands-On Data Modelling Experience - Mandatory
- Extensive experience developing conceptual, logical, and physical data models.
- Strong understanding of entity relationship modelling, data grain, cardinality, normalization, and data lineage.
- Experience working with complex financial datasets and integrating data across multiple systems.
- Proficiency with enterprise data modelling tools such as ERwin, PowerDesigner, ER/Studio, or equivalent.
- Strong SQL skills and experience validating data structures and relationships.
Banking & Financial Services Knowledge
- Experience working with banking data across capital, risk, regulatory, or finance functions.
- Understanding of financial products and their associated data structures.
- Ability to translate complex banking requirements into well-structured data models.
Preferred Qualifications
- Experience supporting regulatory capital frameworks such as Basel III, RWA calculations, and capital adequacy reporting.
- Familiarity with Canadian banking regulatory requirements, including OSFI capital reporting.
- Experience working within Enterprise Risk, Capital Management, Regulatory Capital, or Finance technology teams.
- Experience with enterprise data governance, metadata management, and data lineage platforms.
Ideal Candidate Profile
The ideal candidate is a hands-on Data Modeler who has directly supported capital measurement or capital management initiatives within a major bank.
They should be comfortable discussing capital-related business processes, financial products, and regulatory data requirements while demonstrating strong technical expertise in designing complex logical and physical data models.
Candidates with general banking data modelling or capital markets experience but no direct capital measurement/management exposure will not be considered a strong fit.