Independent Senior Data Architect · Toronto, Canada

Ramandeep Marwaha

Senior Data Architect  ·  Collibra Certified Solution Architect  ·  Toronto, Canada

I build the data infrastructure that capital markets firms run on — greenfield platforms, enterprise governance, Data Mesh strategy, and AI-powered data tools for Tier 1 Canadian banks and government organisations.

Collibra Solution Architect CDMP PMP CBAP CSM SFC
18+ Years Experience
11+ Years Independent
9+ Tier 1 Clients

Platform Builder.
Governance Architect.

Since 2006, I've specialized in delivering senior data architecture expertise to organisations tackling complex, high-stakes data challenges. In 2014, I began operating independently to focus on the most challenging engagements at Tier 1 Canadian banks, crown corporations, and government agencies.

My deepest work: architecting a greenfield capital markets data platform for one of Canada's largest banks — a production-grade streaming platform now governing data across derivatives, FX, equities, fixed income, and regulatory reporting.

I sit at the intersection of three disciplines most organisations struggle to combine: capital markets domain depth, modern platform architecture, and enterprise data governance. That combination is rare. That is why Tier 1 institutions seek me out.

"The governance framework, CDE policies, and ASD standards I designed are still the backbone of a Tier 1 bank's GBM data platform — years after initial delivery."

Selected Clients

Scotiabank National Bank TD Securities RBC Capital Markets BCLC CMHC CIBC Royal Bank of Scotland State Street Bank

Core Expertise

What I Deliver

Senior data architecture and AI engineering engagements across seven practice areas — each built on real production experience at Tier 1 institutions.

⚡

Streaming Data Platforms

Greenfield and transformation engagements — designing real-time capital markets data platforms from architecture to production.

Kafka GCP BigQuery Elasticsearch Avro Pub/Sub Dataflow
🏛

Collibra Implementation

Full lifecycle Collibra delivery — from POC and vendor selection through enterprise production, administration, workflow automation, and Edge integration.

Collibra Workflow Designer REST APIs Edge Business Glossary Python
🤖

AI-Powered Data Solutions

Building practical AI tools on top of governed data platforms — RAG pipelines, local LLM deployments, and natural language interfaces for enterprise data assets.

RAG Ollama ChromaDB Mistral LLaMA 3 Vertex AI Streamlit
🕸

Data Mesh & Data Products

Designing federated governance frameworks, domain ownership models, and data product contracts for large financial institutions.

Data Mesh Data Contracts Dataplex Federated Governance
🗂

MDM & Client Data Strategy

Enterprise MDM strategy, 360° client view design, and data mastering programme delivery across capital markets organisations.

Tamr GoldenSource IBM MDM Snowflake Client Central
📐

Capital Markets Data Modeling

Physical and logical data modeling across 15+ asset classes using FpML, FIX, and Common Data Models — Elasticsearch, Avro, and relational.

FpML FIX Avro ERwin Power Designer
⚖️

Regulatory Data Architecture

Data architecture for Basel III, CAT, BCBS239, ESG, T+1, and Initial Margin — bridging regulatory requirements and technical platform design.

Basel III CAT BCBS239 ESG T+1 Initial Margin

Experience

Senior Engagements.
Nine Institutions. One Standard.

Independent consulting since 2014. Building data platforms for Tier 1 institutions since 2006.

Senior Data Architect — GBM Capital Markets Data Platform

Scotiabank · Global Banking & Markets

Architected and delivered the Intake & Governance framework for the GBM Data Platform across 10+ capital markets asset classes. Led Collibra administration, workflow development, and Edge integration. Spearheaded the Capital Markets Client Data Strategy and MDM programme. Contributed to Enterprise Liquidity Risk, T+1 Settlements, GCP Migration, and ESG Reporting initiatives.

Sr. Collibra Architect & Developer

BCLC · British Columbia Lottery Corporation

Architected the enterprise Collibra operating model and self-serve governance framework. Designed automated workflows, built Power BI DQ reporting dashboards, integrated Collibra with Snowflake for metadata exchange and policy alignment, migrated legacy workflows to Collibra Workflow Developer, and delivered team training programmes.

Senior Data Architect — Finance Domain Data Modelling

CMHC · Canada Mortgage and Housing Corporation

Designed and delivered enterprise data models for the Finance domain across Azure Databricks and MySQL — spanning Appraisal, Lender, Fraud, Property, and Organisation subject areas. Modelled complex nested JSON data structures using ERwin, producing well-governed physical and logical schemas aligned to organisational data standards. Built an automation script that derived JSON schemas directly from the data dictionary — eliminating significant manual effort for the team and accelerating delivery of new data structures across the platform.

Senior Data Architect — Strategic Operating Model Architecture

National Bank of Canada

Architected Wealth Management data models and governance migration to AWS. Designed data governance policies and automation solutions for the Common Data Model framework.

Senior Data Architect — Greenfield Data Platform Build

Scotiabank · Global Banking & Markets

Built Scotiabank's GBM Data Platform from the ground up — establishing the foundational streaming architecture, Kafka topic naming conventions, data strategy, and governance framework. Led Collibra POC and full implementation. Designed data models for 15+ capital markets asset classes. Served as primary regulatory liaison for CAT compliance.

Senior Data Architect — VaR Reporting & Basel III

TD Securities

BCBS239 data aggregation requirements for Basel III RWA capital calculation. OTC Derivatives data integration across Darwin, Murex, and Calypso.

Senior Business Consultant — Wholesale Credit Risk

RBC Capital Markets · Group Risk Management

LGD Engine business rules for Basel III capital calculation across FX, Equities, and Derivatives. BSC and CMI policy authorship.

Earlier Career

CIBC · Royal Bank of Scotland (London) · State Street Bank (Toronto & Boston) · Vocalink (London) · UBS · Level 3 Communications

Capital markets business analysis and data architecture across Basel II/III, derivatives valuation, payment processing, and data migration at global financial institutions.

Credentials

Formally Verified.
Practically Earned.

Six professional certifications spanning data management, architecture, project delivery, and agile methodology.

DAMA International

Certified Data Management Professional

CDMP

PMI — Project Management Institute

Project Management Professional

PMP

IIBA Canada

Certified Business Analysis Professional

CBAP

Scrum Alliance

Certified Scrum Master

CSM

SCRUMstudy

Scrum Fundamentals Certified

SFC

Google Cloud · In Progress

Professional Data Engineer

GCP PDE

Databricks · In Progress

Data Engineer Associate

Databricks DE

Microsoft · In Progress

Azure Data Engineer Associate

DP-203

Portfolio

Open Source Work

Production-grade projects demonstrating real patterns from Tier 1 financial institution data platforms — including AI-powered tools built for enterprise use.

00 — AI Tool  ·  Featured Project

DataOracle — Ask Your Documents Anything

A fully local RAG (Retrieval-Augmented Generation) pipeline that lets business users ask plain English questions about internal documents — schemas, policies, pipelines, data dictionaries, governance docs, runbooks, and KPIs. Supports PDF, Word, Excel, PowerPoint, CSV, JSON, and Markdown. Runs 100% locally — no cloud, no API keys, no data leaving your machine. Built for data teams at financial institutions who need AI-powered document intelligence without the security risk of sending data to external services.

Ask questions like "Which columns contain PII?" or "What should I do if nightly_aggregation fails?" — and get grounded answers with source citations from your actual documents.

RAG Pipeline Ollama ChromaDB Mistral / LLaMA 3 Sentence Transformers Streamlit Python 100% Local

01 — Streaming Pipeline

Kafka → BigQuery Capital Markets Pipeline

Production-grade streaming pipeline for equity and FX trade events — Avro serialisation, 15-rule DQ validation engine, batched BigQuery sink, DLQ routing, and optional Collibra lineage registration.

Kafka GCP BigQuery Avro Python Collibra API

02 — Governance Toolkit

Collibra Automation Toolkit

Enterprise Collibra automation — bulk asset management, automated CDE registration, BPMN workflow library, lineage ingestion, Snowflake integration, and DQ reporting via REST APIs.

Collibra REST APIs Python Snowflake Power BI

03 — Data Contracts

Capital Markets Data Contract Framework

YAML-based data contracts for capital markets asset classes with automated Soda Core validation, contract enforcement on Kafka topics, and Power BI contract health dashboards.

Data Contracts Soda Core YAML Kafka BigQuery

04 — Data Mesh

Financial Services Data Mesh Framework

Data product YAML specifications, domain ownership registry, federated governance policy templates, and self-serve catalog model adapted for capital markets organisations on GCP.

Data Mesh GCP Dataplex Collibra YAML

Capital Markets Domain

18 Years of Domain Depth

The asset class, source system, and regulatory knowledge that takes a decade to build — and cannot be learned from a course.

Asset Classes

FX Spot & Forward Interest Rate Derivatives Equity Options Swaptions Credit Default Swaps Total Return Swaps Fixed Income Futures Commodities Bonds & Loans Vanilla & Exotic Derivatives Market Data Reference Data

Source Systems

Murex Calypso Ion MMI LoanIQ SCOTS Peak XV Fidessa Bloomberg Thomson Reuters Markit WSSFX

Regulatory Frameworks

Basel III — RWA & Capital BCBS239 CAT — Consolidated Audit Trail FDSF EWST T+1 Settlement Initial Margin Trade Surveillance ESG Reporting Enterprise Liquidity Risk

Standards & Protocols

FpML FIX Protocol Apache Avro ISO 6166 — ISIN ISO 10383 — MIC ISO 4217 — Currency Common Data Model DAMA DMBOK

Open to Senior Engagements

I work with financial institutions and government organisations on data platform architecture, Collibra governance implementations, and Data Mesh strategy. If you have a complex data challenge — let's talk.