Job Title: Lead Data Modeller
Location: Toronto,ON – Hybrid
Duration: 12+ Month Contract with Possible Extension / Conversion
Job Overview
We are seeking an experienced Lead Data Modeller with strong financial services domain expertise, particularly in Capital Management, Balance Sheet, Finance, and Regulatory/Risk data.
The ideal candidate will have extensive hands-on experience designing enterprise-level conceptual and logical data models, translating complex business requirements into structured data entities, attributes, relationships, and data definitions.
This is a data modelling and design-focused leadership role, not a data engineering or platform development position. The individual will own the logical data design and collaborate with data engineering teams responsible for implementation within Databricks.
Key Responsibilities
- Lead the design and development of enterprise-level conceptual and logical data models.
- Translate complex financial and business requirements into entities, attributes, relationships, and logical data structures.
- Design data models supporting Capital Management, Balance Sheet, Financial Risk, and Regulatory Reporting initiatives.
- Develop detailed Entity Relationship Diagrams (ERDs), logical data models, and supporting documentation.
- Define data modelling standards, business definitions, data lineage, grain, and cardinality.
- Partner with business stakeholders to understand, validate, and translate data requirements.
- Provide technical leadership, guidance, and mentorship to a team of data modellers.
- Collaborate with data engineering teams to ensure logical models are accurately implemented within Databricks.
- Drive consistency, reusability, and quality across enterprise data modelling practices.
Required Qualifications
- 10+ years of experience in data modelling, with strong hands-on expertise in conceptual and logical data modelling.
- Strong financial services or banking domain experience.
- Demonstrated experience in Capital Management, Balance Sheet, Financial Risk, Finance, or Regulatory Reporting data.
- Strong understanding of financial data structures, financial instruments, and capital-related concepts.
- Expertise in entity relationships, attributes, grain, cardinality, data lineage, and ER modelling.
- Proven ability to independently design complex enterprise-level logical data models.
- Experience translating business requirements into detailed data models and documentation.
- Experience leading modelling initiatives and mentoring data modelling teams.
- Excellent communication and stakeholder management skills.
Preferred Qualifications
- Experience working with banks, financial institutions, financial software vendors, or financial services consulting firms.
- Familiarity with financial services data modelling frameworks.
- Experience with ERwin, PowerDesigner, or similar data modelling tools.
- Exposure to Databricks environments and modern data platforms.