Job Title: Lead Data Modeler
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.
Required Qualifications
- 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 Qualifications
- 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).
The pay range that the employer reasonably expects to pay for this position is between ¤159.00 and ¤169.00
Our voluntary benefits offering includes medical, dental, vision and retirement benefits.
This posting is for an existing vacancy.
If you believe this post to be fraudulent, please report by clicking here Tundra Technical Solutions is a global workforce and technology delivery firm, ranked by Staffing Industry Analysts as one of the largest in North America. At Tundra, we aren't just hiring top talent at the world's most recognizable brands; we are pioneers of social recruitment. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other legally protected characteristics. We welcome and encourage diversity in the workplace.
We use artificial intelligence tools to help our recruiters screen and assess talent. These tools do not replace human decision making in the process.
Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!