Our client, is seeking an accomplished, highly analytical Lead Data Modeler to join their Capital Markets data architecture and governance organization.
...
In this strategic, architectural leadership role, you will own the design and definition of enterprise-level conceptual and logical data models supporting major capital management and balance sheet initiatives. Serving as the subject-matter expert for financial data modeling, you will translate complex capital markets, risk, and regulatory requirements into structured logical data architectures, entity-relationship diagrams, and standardized business definitions. Embedded within a large-scale 60-person program ecosystem, you will mentor a dedicated squad of data modelers and partner closely with data engineering teams to ensure your logical designs are accurately understood and translated into physical implementations within Databricks.
Duration: 1-Year Contract (Full-time engagement; strong possibility of extension or permanent conversion)
Schedule: Monday to Friday, core business hours (No overtime required)
Work Arrangement: Hybrid (Ideally 4 days per week on-site, 1 day remote)
Advantages
Tier-1 Capital Markets Footprint: Architect foundational enterprise data structures powering critical capital management and balance sheet reporting within a leading financial institution.
1-Year Contract with Conversion Potential: Secure a stable, full-year foundational mandate with confirmed potential for multi-term extensions or full-time permanent conversion.
Pure Architectural & Modeling Focus: Concentrate directly on conceptual/logical data design, standards governance, and mentorship while dedicated engineering teams handle physical implementation in Databricks.
Enterprise Scale & Leadership: Guide and mentor a team of data modelers within a large, well-established 60-person capital markets transformation program.
Responsibilities
Conceptual & Logical Data Modeling: Lead the end-to-end design and development of enterprise conceptual and logical data models supporting capital management, regulatory, and balance sheet initiatives.
Financial Domain Translation: Apply deep capital markets and financial domain expertise to translate complex business requirements into precise entities, attributes, relationships, grain, and cardinality rules.
Documentation & Diagramming: Author detailed entity-relationship diagrams (ERDs), logical data models, data lineage mappings, and supporting architectural documentation.
Standards & Governance: Establish, enforce, and evolve consistent enterprise modeling standards, unified business glossaries, and reusable canonical data structures.
Team Leadership & Mentorship: Provide hands-on modeling direction, architectural review, and mentorship to a small team of data modelers.
Stakeholder & Engineering Alignment: Collaborate closely with financial business stakeholders to validate requirements, and partner with data engineers to ensure logical designs are accurately implemented within Databricks.
Qualifications
Extensive Data Modeling Experience: 10+ years of progressive, hands-on experience in enterprise data modeling, demonstrating mastery of conceptual and logical modeling (entity-relationship modeling, grain, cardinality, normalization, and data lineage concepts).
Capital Markets & Financial Domain Depth: Proven track record modeling complex financial data domains—specifically capital management, balance sheet structures, risk, regulatory reporting, or capital markets instruments.
Enterprise Architectural Ownership: Demonstrated ability to independently design complex, enterprise-scale logical data models from the ground up.
Leadership & Mentorship: Proven experience leading data modeling workstreams, establishing architectural standards, and mentoring fellow data modelers.
Stakeholder Communication: Exceptional communication and facilitation skills, with extensive experience partnering directly with financial business stakeholders and technical engineering teams.
Education: Practical, proven enterprise modeling experience is prioritized over specific academic degrees or mandatory certifications.
Preferred Assets & Nice-to-Haves
Direct experience with banking capital management, regulatory capital reporting, or institutional financial reporting domains.
Prior background working within Tier-1 financial institutions, financial software vendors (e.g., Bloomberg, Oracle Financial Services), or management consulting firms serving capital markets clients.
Familiarity with established industry-standard financial services data models and frameworks (e.g., FIBO, IBM BDW, or Teradata FSLDM).
Working exposure to Databricks environments to facilitate seamless collaboration with downstream physical data engineers.
Hands-on proficiency with enterprise data modeling tools such as ERwin Data Modeler or SAP PowerDesigner.
Summary
If you are a seasoned Lead Data Modeler who pairs 10+ years of conceptual and logical data modeling mastery with deep capital markets and balance sheet domain expertise, architectural mentorship skills, and Databricks alignment experience, this 1-year hybrid contract opportunity is an ideal next step. Bring your structural precision, financial data acumen, and architectural leadership to our client's capital markets program today!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
Our client, is seeking an accomplished, highly analytical Lead Data Modeler to join their Capital Markets data architecture and governance organization.
In this strategic, architectural leadership role, you will own the design and definition of enterprise-level conceptual and logical data models supporting major capital management and balance sheet initiatives. Serving as the subject-matter expert for financial data modeling, you will translate complex capital markets, risk, and regulatory requirements into structured logical data architectures, entity-relationship diagrams, and standardized business definitions. Embedded within a large-scale 60-person program ecosystem, you will mentor a dedicated squad of data modelers and partner closely with data engineering teams to ensure your logical designs are accurately understood and translated into physical implementations within Databricks.
Duration: 1-Year Contract (Full-time engagement; strong possibility of extension or permanent conversion)
Schedule: Monday to Friday, core business hours (No overtime required)
Work Arrangement: Hybrid (Ideally 4 days per week on-site, 1 day remote)
...
Advantages
Tier-1 Capital Markets Footprint: Architect foundational enterprise data structures powering critical capital management and balance sheet reporting within a leading financial institution.
1-Year Contract with Conversion Potential: Secure a stable, full-year foundational mandate with confirmed potential for multi-term extensions or full-time permanent conversion.
Pure Architectural & Modeling Focus: Concentrate directly on conceptual/logical data design, standards governance, and mentorship while dedicated engineering teams handle physical implementation in Databricks.
Enterprise Scale & Leadership: Guide and mentor a team of data modelers within a large, well-established 60-person capital markets transformation program.
Responsibilities
Conceptual & Logical Data Modeling: Lead the end-to-end design and development of enterprise conceptual and logical data models supporting capital management, regulatory, and balance sheet initiatives.
Financial Domain Translation: Apply deep capital markets and financial domain expertise to translate complex business requirements into precise entities, attributes, relationships, grain, and cardinality rules.
Documentation & Diagramming: Author detailed entity-relationship diagrams (ERDs), logical data models, data lineage mappings, and supporting architectural documentation.
Standards & Governance: Establish, enforce, and evolve consistent enterprise modeling standards, unified business glossaries, and reusable canonical data structures.
Team Leadership & Mentorship: Provide hands-on modeling direction, architectural review, and mentorship to a small team of data modelers.
Stakeholder & Engineering Alignment: Collaborate closely with financial business stakeholders to validate requirements, and partner with data engineers to ensure logical designs are accurately implemented within Databricks.
Qualifications
Extensive Data Modeling Experience: 10+ years of progressive, hands-on experience in enterprise data modeling, demonstrating mastery of conceptual and logical modeling (entity-relationship modeling, grain, cardinality, normalization, and data lineage concepts).
Capital Markets & Financial Domain Depth: Proven track record modeling complex financial data domains—specifically capital management, balance sheet structures, risk, regulatory reporting, or capital markets instruments.
Enterprise Architectural Ownership: Demonstrated ability to independently design complex, enterprise-scale logical data models from the ground up.
Leadership & Mentorship: Proven experience leading data modeling workstreams, establishing architectural standards, and mentoring fellow data modelers.
Stakeholder Communication: Exceptional communication and facilitation skills, with extensive experience partnering directly with financial business stakeholders and technical engineering teams.
Education: Practical, proven enterprise modeling experience is prioritized over specific academic degrees or mandatory certifications.
Preferred Assets & Nice-to-Haves
Direct experience with banking capital management, regulatory capital reporting, or institutional financial reporting domains.
Prior background working within Tier-1 financial institutions, financial software vendors (e.g., Bloomberg, Oracle Financial Services), or management consulting firms serving capital markets clients.
Familiarity with established industry-standard financial services data models and frameworks (e.g., FIBO, IBM BDW, or Teradata FSLDM).
Working exposure to Databricks environments to facilitate seamless collaboration with downstream physical data engineers.
Hands-on proficiency with enterprise data modeling tools such as ERwin Data Modeler or SAP PowerDesigner.
Summary
If you are a seasoned Lead Data Modeler who pairs 10+ years of conceptual and logical data modeling mastery with deep capital markets and balance sheet domain expertise, architectural mentorship skills, and Databricks alignment experience, this 1-year hybrid contract opportunity is an ideal next step. Bring your structural precision, financial data acumen, and architectural leadership to our client's capital markets program today!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more