Business Analyst - Capital Markets
About the role
Company Description Dimensionless Technologies is a global IT consultancy and AI services company that delivers AI-driven solutions across multiple industries. Founded in 2016 in Mumbai, India, the company focuses on helping organizations improve operational efficiency and achieve sustainable growth through advanced artificial intelligence. Its teams of data scientists, machine learning engineers, and software developers design and deploy bespoke solutions such as security automation, fraud detection, and natural language processing. With offices in Mumbai and New Jersey and a strong presence in both the US and India, Dimensionless serves a diverse, international client base. The company fosters an innovation-focused culture where professionals work on cutting-edge AI projects that directly impact clients’ business outcomes. Role Description The Business Analyst – Capital Markets is a full-time, on-site role based in Toronto, ON. This role is responsible for gathering, analyzing, and documenting business requirements for capital markets initiatives, working closely with stakeholders such as trading, risk, operations, and technology teams.
Key Responsibilities
- 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.
- 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.
- 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.
Similar Jobs
Business Analyst - Capital Markets
About the role
Company Description Dimensionless Technologies is a global IT consultancy and AI services company that delivers AI-driven solutions across multiple industries. Founded in 2016 in Mumbai, India, the company focuses on helping organizations improve operational efficiency and achieve sustainable growth through advanced artificial intelligence. Its teams of data scientists, machine learning engineers, and software developers design and deploy bespoke solutions such as security automation, fraud detection, and natural language processing. With offices in Mumbai and New Jersey and a strong presence in both the US and India, Dimensionless serves a diverse, international client base. The company fosters an innovation-focused culture where professionals work on cutting-edge AI projects that directly impact clients’ business outcomes. Role Description The Business Analyst – Capital Markets is a full-time, on-site role based in Toronto, ON. This role is responsible for gathering, analyzing, and documenting business requirements for capital markets initiatives, working closely with stakeholders such as trading, risk, operations, and technology teams.
Key Responsibilities
- 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.
- 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.
- 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.