Back to search

Lead Data Modeler

Lead the design and development of conceptual and logical data models supporting capital management initiatives.

  • Toronto, Ontario, Canada
  • Full-time
  • Hybrid
  • Posted Nov 16, 2026
INDUSTRYFinance & AccountingFintech & PaymentsAccounting & Bookkeeping

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

Requirements

  • Experience in a Banking
  • Experience in a Capital management
  • Experience in a Financial reporting

Skills

Data modellingConceptual data modellingLogical data modellingEntity relationshipLineage conceptsGrain/cardinalityFinancial data structuresCapital managementBalance sheet-related dataEnterprise-level logical data modelsDatabricksERwinPowerDesigner

Benefits

  • Health Benefits
  • Referral Program

Full description

Our client, a Banking company, is looking for a Lead Data Modeler for their Toronto, ON/Hybrid location. 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. Requirements: Years of Overall Experience: 10 plus years experience 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). Why Should You Apply? Health Benefits Referral Program Excellent growth and advancement opportunities

Lead Data Modeler at ICONMA, LLC | Referso Jobs