Lead Data Modeler
Location: Toronto, ON
Onsite Flexibility: Hybrid
Contract Details
Position Type: Contract
Contract Duration: 1 year (with potential for extension; conversion possible)
Pay Rate: C$120.00–C$170.00 / Hour (CAD)
Shift / Schedule: Monday to Friday, core business hours
Job Summary
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.
Required Skills
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.
Preferred Skills
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).
Required Experience
10 years of experience in data modelling with extensive hands-on conceptual and logical data modelling expertise.
Important Notes
Interview process: maximum 2 rounds — 1 virtual, 1 onsite.
About the Client
This client is a leading financial services and banking institution operating across Canada and internationally, employing tens of thousands of professionals across technology, risk, finance, and operations. The organization supports a broad range of roles — including solutions developers, data modellers, release train strategists, and IT specialists — who collaborate within agile, fast-paced teams focused on capital markets, regulatory compliance, and enterprise data initiatives.
About GTT
GTT is an NMSDC-certified Minority Business Enterprise (MBE) headquartered in Portsmouth, New Hampshire. GTT is a subsidiary of Chenega Corporation, an Alaska-based company and one of the largest Alaska Native-owned corporations. An Inc. 5000 honoree and one of SIA's Best Staffing Firms to Work For, GTT connects professionals with Fortune 500 organizations across IT, engineering, construction, utilities, life sciences, financial services, and healthcare throughout the U.S. and Canada. We're committed to diverse, inclusive workplaces and to placing people in roles where they can do their best work.
Job Number: 26-19515 Industry: Data & Analytics
#LI-Hybrid #LI-GTT #gttca