Job Title: Lead Data Modeler
Duration: 12 months
Extension: Possible
Conversion: Possible
Work Arrangement: Ideally 4 days onsite
Work Location: 79 Wellington Street West, Toront
Role Overview
We are seeking a highly experienced Lead Data Modeler with specialized expertise in financial data modelling, particularly in capital management and balance sheet-related data.
The successful candidate will lead the design and development of enterprise-level conceptual and logical data models supporting capital management initiatives. They must possess a strong 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 the Databricks environment.
Team Size: Approximately 60
Project Domain: Capital Markets
Education: No specific requirement
Certifications: Not required
Customer Data Access: No
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 accurately represent capital-related data and balance sheet structures.
-
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, including entity relationships, data lineage concepts, grain and cardinality.
-
Experience modelling capital and financial domains, including capital, risk, regulatory or 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).
Interview Process
-
Maximum 2 interview rounds.
-
Round 1: Virtual interview.
-
Round 2: Onsite interview.
Additional Information
-
Assignment is project-based.
-
Upcoming PTO: End of December.
-
Performance measurement: Not specified.
-
Travel requirements: Not specified.
-
Additional furlough possibility: Not specified.
Applicant Notices & Disclaimers
- For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. The pay rate for this position is C$147.00/hr.