Talent.com
Saransh Inc
Data Business Analyst TorontoSaransh Inc • Toronto, Ontario, Canada
Data Business Analyst Toronto

Data Business Analyst Toronto

Saransh Inc • Toronto, Ontario, Canada
11 days ago
Job type
  • Full-time
Job description
  • Role / Skill - Data BA
  • 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 Databricksstructures.
    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.


Employment Type : Full Time
Experience: years
Vacancy: 1
Create a job alert for this search

Data Business Analyst Toronto • Toronto, Ontario, Canada

Similar jobs

Manager, Business Analyst - toronto

Altis Recruitmenttoronto, on, ca
Full-time

Strong written and verbal communication skills in English.Criminal Background Check and References.This is a unique leadership opportunity for a seasoned Business Analysis professional who is passi... Show more

 • Promoted

Business Analyst - toronto

Vitasoy North America Inc.toronto, on, ca
Full-time +1

This job posting is for a current, existing vacancy with a targeted start date of June 1, 2026.Senior Sales & Marketing Manager.Vitasoy International is a leading manufacturer and distributor of pl... Show more

 • Promoted

Business Operation Analyst - toronto

Dew Softwaretoronto, on, ca
Full-time

Support team members through the hiring process.Track health of hiring flow and unblock challenges to partner in building an extraordinary organization.Prepare weekly/monthly hiring summaries and a... Show more

 • Promoted

Business Analyst - toronto

ZenaTech Inc.toronto, on, ca
Full-time

ZenaTech is a Nasdaq-listed technology company focused on AI drone, Drone as a Service (DaaS), enterprise SaaS and Quantum Computing solutions for mission-critical applications for business, govern... Show more

 • Promoted

Senior Business Analyst - toronto

Torstafftoronto, on, ca
Full-time

Reporting to the President and CFO this large corporation located on the subway line requires a Senior Business Analyst.Support and analysis of daily operations as it relates to import transport an... Show more

 • Promoted

Business Analyst with Informatica - toronto

Pacer Staffingtoronto, on, ca
Full-time

Should have exp on Informatica Powercenter. Show more

 • Promoted

Hybrid Azure Data Analyst in Toronto

CGIToronto, ON, CA
Full-time

Elevate your career with a hybrid role as an Azure Data Analyst in downtown Toronto.Design and deliver data solutions in a dynamic banking environment, collaborating closely with stakeholders and t... Show more

 • Promoted

Senior Business Analyst in Toronto

GS1 CanadaToronto, ON, CA
Full-time

Elevate your career with a Senior Business Analyst role at GS1 Canada in Toronto.This contract position focuses on business analysis, systems thinking, and developing comprehensive business solutio... Show more

 • Promoted

Murex Business Analyst - toronto

Synechrontoronto, on, ca
Full-time

At Synechron, we believe in the power of digital to transform businesses for the better.Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital ... Show more

 • Promoted

Marketing Data Analyst - toronto

Mitsubishi Motor Sales of Canada, Inc.toronto, on, ca
Full-time

Mitsubishi Motor Sales of Canada, Inc.We are committed to building an environment where all employees and customers feel valued, respected, and supported.Mitsubishi Motor Sales of Canada, Inc.All e... Show more

 • Promoted

Operational Business Analyst in Toronto

Legal Aid OntarioToronto, ON, CA
Temporary

Elevate your analytical skills as an Operational Business Analyst for LAO in Toronto, Ontario.This 12-month contract role focuses on enhancing digital user experiences through stakeholder collabora... Show more

 • Promoted

Onsite Toronto Senior Business Analyst - 5-Month Contract

Source CodeToronto, ON, CA
Temporary

A technology services company is seeking a Senior Business Analyst for an onsite position in Toronto.The role involves providing comprehensive I&T business analysis services, engaging with stakehol... Show more

 • Promoted

Senior Business System Analyst - toronto

Insight Globaltoronto, on, ca
Temporary

JOB DESCRIPTION: $65-$75/hour - 6 month contract - Hybrid 2 days/week.Insight Global is hiring for a Senior Business Systems Analyst to support the modernization of loan management and collections ... Show more

 • Promoted

Senior Business Analyst - toronto

JamLabs Data Sciencetoronto, on, ca
Full-time

The Senior Business Analyst at JamLabs plays a critical role in translating complex business challenges, articulated at the most senior levels of the world's leading financial institutions, into pr... Show more

 • Promoted

Data Business Analyst - Toronto

Saransh IncToronto, ON, CA
Full-time

Toronto (Day 1 onsite, 3 days at office).Design and maintain physical and logical data models for Capital Markets domains, including trade execution, portfolio positions, market data (ticks/pricing... Show more

 • Promoted

Hybrid Business Analyst in Toronto

Iris Software Inc.Toronto, ON, CA
Full-time

Explore a contract-to-hire Business Analyst role with a leading financial services provider in Toronto.Leverage your retail trading knowledge and analytical skills in a hybrid work environment.This... Show more

 • Promoted

Business System Analyst - toronto

Pacer Grouptoronto, on, ca
Full-time

Business Systems Analyst in banking or payments.API integration projects, including microservices-based architecture and distributed systems.Should have understanding of Interac e-Transfer 3.APIs a... Show more

 • Promoted

Senior Business Process Analyst - toronto

Calculated Hiretoronto, on, ca
Temporary

Sr Business Analyst – Lean Belt.Hybrid (2-3 days onsite) - Chicago, IL or Toronto, CA.The Expert Business Analyst supports Commercial Lending Operations by driving process optimization, straight th... Show more

 • Promoted

Business Analyst - toronto

Synechrontoronto, on, ca
Full-time

At Synechron, we believe in the power of digital to transform businesses for the better.Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital ... Show more

 • Promoted

Business Analyst - toronto

Creative Circletoronto, on, ca
Full-time

Our consulting client is looking for a Business Analyst to join their team.This will be for 6+ months, fulltime hours per week, remote, and starting in September.Rate range is $85-90 per hour, cad/... Show more