Lead Data Modeler
Community
·Yesterday
- Salary
- C$159 – C$169/hr
- Location
- Toronto, Ontario, Canada
- Workplace
- Hybrid
- Type
- Contract
- Seniority
- Lead
- Experience
- 10+ years
- Closing date
- Today
Description
Location: Toronto, ON (Hybrid)
Estimated Duration: 12 Months
Role Overview
We are seeking a highly experienced Lead Data Modeller with specialized expertise in financial data modelling, particularly within capital management and balance sheet-related data.
This individual will be responsible for designing and defining enterprise-level conceptual and logical data models that support capital management initiatives.
The ideal candidate will bring a deep understanding of financial data structures, financial instruments, and capital management concepts, with the ability to translate complex business requirements into clearly defined logical data models.
This is a data modelling and design-focused position, not a data engineering or platform implementation role. The successful candidate will own the logical design, while separate data engineering teams will be responsible for implementing the models within Databricks.
Key Responsibilities
- Lead the design and development of conceptual and logical data models supporting capital management initiatives.
- Translate complex financial and business requirements into logical data structures, entities, attributes and relationships.
- Apply financial domain expertise to represent capital-related data and balance sheet structures accurately.
- Develop detailed entity-relationship diagrams, logical data models and supporting documentation.
- Establish consistent modelling standards, business definitions and reusable data structures.
- Collaborate closely with financial business stakeholders to understand and validate data requirements.
- Provide modelling direction and mentorship to a small team of data modellers.
- Work with data engineers to ensure logical designs are correctly understood and implemented within the Databricks environment.
- Serve as the subject-matter expert for financial data modelling and logical data design.
- 10+ years of experience in data modelling, with extensive hands-on conceptual and logical data modelling expertise ( entity relationship, lineage concepts, grain/cardinality .. etc)
- Experience modelling capital / financial domain (capital, risk , regulatory, finance).
- Strong understanding of financial data structures, particularly capital management and balance sheet-related data.
- Demonstrated experience independently designing complex enterprise-level logical data models.
- Strong ability to translate financial business requirements into structured data models.
- Ability to lead modelling efforts, establish standards and mentor other modellers.
- Strong communication skills and experience working directly with business stakeholders.
- Experience with banking capital management, financial reporting or related financial data domains.
- Experience working within financial institutions, financial software vendors (e.g., Oracle or Bloomberg), or consulting firms serving financial institutions.
- Familiarity with established financial services data modelling frameworks.
- Exposure to Databricks environments to support collaboration with implementation teams.
- Experience with data modelling tools such as ERwin or PowerDesigner (no specific tool required).