Data Modeler

Toronto, ON, CA • Posted 5 hours ago • Updated 1 hour ago

Contract Corp To Corp

On-site

Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

Data Modeler

Summary

Job Title: Data Modeler
Location: Toronto, ON (Hybrid 3 Days Onsite a week)

Role Overview:

Seeking an experienced Data Modeler with strong Finance/Capital Markets domain knowledge. The role focuses on designing scalable, consistent, and extensible data models that support complex operational lifecycles across multisystem environments.

Data Modeling & Architecture:

Design conceptual, logical, and physical data models across Retail, Supply Chain, Banking, and Capital Markets domains.
Model time, series, reference, market, and transactional data.
Align designs with Medallion Architecture (Bronze/Silver/Gold) and cloud lakehouse environments (AWS, Spark, Parquet, Iceberg).

Standards & Governance:

Define modeling standards, templates, naming conventions, and data dictionaries.
Establish best practices to ensure consistency, scalability, and long term extensibility.

Model Review & Optimization:

Evaluate existing data models for alignment with best practices.
Identify gaps, inconsistencies, and improvement areas for multisystem integration.

Lifecycle Wide Modeling Support:

Setup: Introduce new attributes for segmentation, eligibility, rules, and workflow triggers.
Execution: Model structures supporting multistep workflows, state transitions, and real time/near real time flows.
Financial Processing: Define data required for funding logic, allocation rules, settlement, and reconciliation.
Analytics: Build scalable facts, dimensions, and hierarchies for performance measurement and insights.

Collaboration:

Work with business SMEs, architects, engineering, finance, and analytics teams.
Translate business rules into normalized, logical, and physical models.

Required Skills & Experience:

6 12 years of enterprise data modeling experience in complex, multisystem environments.
Strong expertise in ERwin, ER/Studio, PowerDesigner, or similar tools.
Proficient in relational, dimensional, and lakehouse modeling.
Hands on experience with cloud storage formats (Parquet/Iceberg) and distributed computing platforms.
Solid understanding of Finance & Capital Markets data (trades, risk, positions, reference data).
Strong communication, analytical, and documentation skills.

Preferred Qualifications:

Exposure to Azure, Databricks, Snowflake, DBT.
Knowledge of data governance, lineage, and regulatory compliance.
Experience working in Agile/Scrum environments.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10106248
Position Id: 2026-3827
Posted 5 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Data Modeler

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs