Lead Data Modeler - Capital Market

BeachHead

Toronto

On-site

CAD 120,000 - 180,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

BeachHead Inc. is seeking a Lead Data Modeler for Capital Markets to design enterprise-level conceptual and logical data models that support capital management initiatives.

You will act as a subject-matter expert, partnering with senior business stakeholders and guiding a small team of modelers. This role emphasizes strong financial domain knowledge, ability to translate complex requirements into robust data structures, and collaboration with data engineering teams, including Databricks

Qualifications

  • 10+ years in data modelling, with hands-on conceptual and logical modelling.
  • Strong knowledge of ER diagrams, data lineage, data grain, and cardinality.
  • Experience modelling capital, risk, regulatory, or finance-related data.
  • Deep understanding of financial data structures, especially capital management and balance sheets.
  • Proven ability to design complex, enterprise-level logical data models.
  • Able to translate financial business requirements into structured, scalable data models.
  • Experience leading modelling initiatives and mentoring other modelers.
  • Strong communication and stakeholder management, with business partners.

Responsibilities

  • Lead development of conceptual and logical data models for capital management initiatives.
  • Translate complex financial and business requirements into entities, attributes, relationships, and data structures.
  • Model capital-related data and balance sheet structures.
  • Create detailed entity-relationship diagrams, logical data models, lineage documentation, and supporting materials.
  • Establish consistent modelling standards, business definitions, and reusable data structures.
  • Collaborate with financial business stakeholders to gather, clarify, and validate data requirements.
  • Provide modelling direction, coaching, and mentorship to a small team of data modelers.
  • Partner with data engineering teams to ensure logical designs are accurately understood and implemented within Databricks.
  • Act as the subject-matter expert for financial data modelling and logical data design.
  • Support effective communication between business stakeholders, modelling teams, and implementation teams.

Skills

Data modelling
Conceptual modelling
Stakeholder management
Leadership
Financial data domain

Tools

Databricks
ERwin
PowerDesigner

Job description

Could you lead the design of data models that shape capital markets initiatives?


Working with one of our top financial clients, this role calls for a Lead Data Modeler - Capital Marketto design and develop enterprise-level conceptual and logical data models supporting capital management initiatives. This opportunity offers the chance to serve as a subject-matter expert in financial data modelling, partner with senior business stakeholders, guide a team of modelers, and contribute to a high-impact capital markets program.


Responsibilities


  • Lead the development of conceptual and logical data models for capital management initiatives.

  • Translate complex financial and business requirements into well-defined entities, attributes, relationships, and data structures.

  • Model capital-related data and balance sheet structures using strong financial domain expertise.

  • Create detailed entity-relationship diagrams, logical data models, lineage documentation, and supporting materials.

  • Establish consistent modelling standards, business definitions, and reusable data structures.

  • Collaborate with financial business stakeholders to gather, clarify, and validate data requirements.

  • Provide modelling direction, coaching, and mentorship to a small team of data modelers.

  • Partner with data engineering teams to ensure logical designs are accurately understood and implemented within Databricks.

  • Act as the subject-matter expert for financial data modelling and logical data design.

  • Support effective communication between business stakeholders, modelling teams, and implementation teams.


Desired Skill-Set


  • 10+ years of experience in data modelling, including extensive hands-on expertise in conceptual and logical data modelling.

  • Strong knowledge of entity relationships, data lineage, data grain, and cardinality.

  • Demonstrated experience modelling capital, risk, regulatory, or finance-related data.

  • Strong understanding of financial data structures, particularly capital management and balance sheet-related data.

  • Proven ability to independently design complex, enterprise-level logical data models.

  • Ability to translate financial business requirements into structured, scalable data models.

  • Experience leading modelling initiatives, establishing standards, and mentoring other modelers.

  • Strong communication and stakeholder management skills, with experience working directly with business partners.

  • Expertise in data modelling and design rather than data engineering or platform implementation.


Nice to Have


  • Experience with banking capital management, financial reporting, or related financial data domains.

  • Experience working within financial institutions, financial software vendors, or consulting firms serving financial institutions.

  • Familiarity with established financial services data modelling frameworks.

  • Exposure to Databricks environments and collaboration with implementation teams.

  • Experience with data modelling tools such as ERwin or PowerDesigner.


BeachHead is an equal opportunity agency and employer. We advocate for our candidates and welcome applicants regardless of race, color, religion, national origin, sex, age, or physical or mental disability. BeachHead or our clients may use technology-enabled tools, including automation and artificial intelligence (AI), to support parts of the recruitment process such as resume screening, application management, and candidate matching. These tools assist our recruiters and our clients, and do not replace human decision-making. This job posting represents a current or anticipated vacancy. The position may be filled at any time, and the posting may be removed without notice once the role has been filled.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data Modeler (10+ years) to design enterprise-level data models using conceptual and logical data modelling for capital management 59040
Lead Data Modeler (10+ years) to design enterprise-level data models using conceptual and logical data modelling for capital management 59040

S I Systems • Toronto

Hybrid
CAD 120,000 - 180,000
Databricks Business Systems Analyst Consultant – Capital Markets
Databricks Business Systems Analyst Consultant – Capital Markets

BeachHead Inc. • Toronto

On-site
CAD 90,000 - 130,000
Senior Solution Architect, Capital Management Applications
Senior Solution Architect, Capital Management Applications

BeachHead • Toronto

On-site
CAD 150,000 - 190,000
Senior Solution Architect, Capital Management Applications
Senior Solution Architect, Capital Management Applications

BeachHead • Toronto

On-site
CAD 140,000 - 190,000
Senior Data Modeler/Analyst
Senior Data Modeler/Analyst

EPAM Systems • Canada

Hybrid
CAD 90,000 - 130,000
Lead Data Analyst
Lead Data Analyst

Compunnel Inc. • Toronto

On-site
CAD 90,000 - 120,000
Technical Lead – Databricks, Data Engineering & Data Modeling
Technical Lead – Databricks, Data Engineering & Data Modeling

BeachHead Inc. • Toronto

On-site
CAD 103,000 - 110,000
Senior BSA Collateral Management/Capital Markets
Senior BSA Collateral Management/Capital Markets

BeachHead • Toronto

On-site
CAD 90,000 - 130,000
Data Scientist-AI/ML
Data Scientist-AI/ML

BeachHead • Toronto

On-site
CAD 68,000 - 82,000
Senior BSA Collateral Management/Capital Markets
Senior BSA Collateral Management/Capital Markets

BeachHead • Toronto

On-site
CAD 90,000 - 140,000