Talent.com
HireOn Tech
Data Modeler - Capital MarketHireOn Tech • Toronto, ON, Canada
No longer accepting applications
Data Modeler - Capital Market

Data Modeler - Capital Market

HireOn Tech • Toronto, ON, Canada
4 days ago
Job type
  • Full-time
Job description

Hi,


This is Kumar Saurabh from HireOn Tech. I have Urgent Job opening for you. Let me know if you are looking for Better Opportunity to work with us.


Role / Skill - Data Modeler/ Data Business Analyst (Capital Market)

Location: Toronto, Day 1 Onsite - with 3 days at office.


JD:

  • 1. Capital Markets Data Modeling
  • * Design and maintain physical and logical data models for Capital Markets domains, including trade execution, portfolio positions, market data (ticks/pricing), and risk metrics.
  • • Translate complex financial hierarchies (e.g., fund-of-funds, multi-asset class structures) into optimized Databricks structures.
  • • Ensure data models support temporal requirements, such as Point-in-Time (PIT) analysis and "As-Of" financial reporting.
  • 2. Advanced STM (Source-to-Target Mapping) Creation
  • • Lead the creation of comprehensive STM documents, detailing the journey from legacy financial systems and external providers (e.g., Bloomberg, Reuters, Aladdin) to ADLS Gen2.
  • • Define complex transformation logic, business rules, and data enrichment steps within the STM to guide Data Engineering squads.
  • • Map data lineage to ensure full traceability for regulatory compliance.
  • 3. Databricks & ADLS Performance Engineering
  • • Design Delta Lake structures that prioritize "Shuffle-free" joins for massive capital markets datasets.
  • • Implement optimized partitioning and Z-Ordering strategies specifically for time-series financial data to enable high-speed analytics.
  • • Utilize Unity Catalog to govern data access and maintain a centralized metadata repository for the GWAM ecosystem.
  • ________________________________________

Required Skills & Qualifications

• Industry Expertise: 5+ years of experience in Capital Markets or Wealth Management, with a deep understanding of financial instruments and trade lifecycles.

• Technical Modeling: 7+ years of experience in data modeling, with a mastery of Azure Databricks and ADLS Gen2.

• STM Mastery: Proven track record of creating highly detailed Source-to-Target Mappings for complex data migration or integration projects.

• Data Engine Proficiency: Expert-level Spark SQL and PySpark. Ability to optimize data structures for the Spark Catalyst Optimizer.

• Storage Formats: Expertise in Delta Lake (ACID transactions, Time Travel) and Parquet optimization.

• Governance: Hands-on experience implementing data governance and security via Unity Catalog.

________________________________________


Technical Stack

• Compute: Azure Databricks (Jobs, SQL Warehouses).

• Storage: ADLS Gen2 (Delta/Parquet).

• Governance: Unity Catalog.

• Analysis Tools: SQL, Python, Excel (for data profiling).

• Documentation: Confluence/Visio for STM and ERDs.

Create a job alert for this search

Data Modeler - Capital Market • Toronto, ON, Canada

Similar jobs

Hybrid Data Modeler Focusing on SAP Environments and Data Quality

Cpus Engineering Staffing Solutions Inc.Toronto, Ontario, Canada
Full-time

Shape the future of data modeling as a Data Modeler.This hybrid role emphasizes SAP data structures, data quality, and thorough documentation to support organizational needs.As a key contributor, y... Show more

 • Promoted

AI Model Evaluation Analyst - markham

Workerbeemarkham, on, ca
Permanent

No C2C or third-party submissions.Workerbee connects workers with employers through trusted introductions.By joining Workerbee you can be matched for project-based, contract, or permanent opportuni... Show more

 • Promoted

Data Engineer - Minimum 12+ years experience - newmarket

NLB Servicesnewmarket, on, ca
Full-time

Lead the migration from Glue/Redshift to Databricks.Deep, hands-on experience with Apache Spark (PySpark and Spark SQL), including performance tuning (partitioning, shuffles, skew, caching, file si... Show more

 • Promoted

Data Modeler

GFT TechnologiesToronto, Ontario, Canada
Full-time

The role focuses on capturing business requirements, translating them into logical and physical data models, and partnering closely with data engineers to enable scalable client‑centric data soluti... Show more

 • Promoted

Data Architect - richmond hill

LatentView Analyticsrichmond hill, on, ca
Full-time

LatentView Analytics is a leading global analytics and decision sciences provider, delivering solutions that help companies drive digital transformation and use data to gain a competitive advantage... Show more

 • Promoted

RevOps Practice Lead - MergeYourData

MergeYourDatarichmond hill, on, ca
Full-time

MergeYourData is a RevOps consultancy and Top 0.HubSpot Partner globally, currently growing 150% YoY.We work with mid-market B2B companies and multi-company organizations who need their CRM to func... Show more

 • Promoted

Remote Venture Capital Analyst ($100/hr) - 75406 - markham

Turingmarkham, on, ca
Remote
Full-time

Based in San Francisco, California, Turing is the world’s leading research accelerator for frontier AI labs and a trusted partner for global enterprises deploying advanced AI systems.Turing support... Show more

 • Promoted

Data Modeler

MethodHubToronto, ON, Canada
Full-time

Retail (preferably Loyalty) and Finance/Capital Markets domain knowledge.The role focuses on designing scalable, consistent, and extensible data models that support complex operational lifecycles a... Show more

 • Promoted

Data Modeler

Cpus Engineering Staffing Solutions Inc.Toronto, Canada
Full-time

We are currently requesting resumes for the following position : Data ModelerResume Due Date : Thursday, August 21, 2025 (5:00PM EST)Job ID: 25-143Number of Vacancies : 1Level : MP4Duration : 12 Mo... Show more

 • Promoted

AI Model Evaluation Analyst - newmarket

Workerbeenewmarket, on, ca
Permanent

No C2C or third-party submissions.Workerbee connects workers with employers through trusted introductions.By joining Workerbee you can be matched for project-based, contract, or permanent opportuni... Show more

 • Promoted

Data Engineer - Minimum 12+ years experience - markham

NLB Servicesmarkham, on, ca
Full-time

Lead the migration from Glue/Redshift to Databricks.Deep, hands-on experience with Apache Spark (PySpark and Spark SQL), including performance tuning (partitioning, shuffles, skew, caching, file si... Show more

 • Promoted

Capital Markets Data Modeler — Hybrid Contract

Quantum World Technologies Inc.Toronto
Full-time +1

A leading technology firm is seeking a Sr.Technical Recruiter for a hybrid position in Toronto, Ontario.The ideal candidate will have experience in the capital market and the ability to accelerate ... Show more

 • Promoted

Data Modeler

Tredence Inc.Toronto, Ontario, Canada
Full-time

We are looking for a detail-oriented Data Modeler to design, develop, and maintain conceptual, logical, and physical data models that support business processes and analytics.The ideal candidate wi... Show more

 • Promoted

Data Architect

LatentView Analyticsnewmarket, on, ca
Full-time

LatentView Analytics is a leading global analytics and decision sciences provider, delivering solutions that help companies drive digital transformation and use data to gain a competitive advantage... Show more

 • Promoted

Data Analyst - markham

BET99markham, on, ca
Full-time

BET99 is Canada's Premiere Online Sportsbook and Casino.Launched in 2020, we have consistently innovated the online gaming landscape every step of the way, exponentially growing our customer base a... Show more

 • Promoted

Remote Venture Capital Analyst ($100/hr) - 75406 - newmarket

Turingnewmarket, on, ca
Remote
Full-time

Based in San Francisco, California, Turing is the world’s leading research accelerator for frontier AI labs and a trusted partner for global enterprises deploying advanced AI systems.Turing support... Show more

 • Promoted

Data Analyst - richmond hill

BET99richmond hill, on, ca
Full-time

BET99 is Canada's Premiere Online Sportsbook and Casino.Launched in 2020, we have consistently innovated the online gaming landscape every step of the way, exponentially growing our customer base a... Show more

 • Promoted

Data Modeler

STAFFWORXSToronto, Ontario, Canada
Temporary

At Staffworxs, we don’t just connect talent — we power transformation.Headquartered in Frisco, TX, with teams in Bengaluru and Hyderabad, we combine global reach with deep expertise.Our Digital & D... Show more

 • Promoted

Sr AWS DBT Engineer - markham

Mastech Digitalmarkham, on, ca
Full-time

Design and implement robust dimensional and relational data models.Own transformation and modeling of curated (Silver/Gold) datasets.Collaborate with analysts, product analytics, data scientists, a... Show more

 • Promoted

Data Modeler

Rodan Energy SolutionsToronto, ON, CA
Full-time

We are currently requesting resumes for the following position.Thursday, August 21, (5:00PM EST).Temp – University Ave, Toronto, Base – CHQ on rotating schedule.Analyze and document existing data s... Show more