Data Business Analyst with Capital Markets

• Role / Skill - Data Business Analyst • Location: Toronto, 3 days at office JD : 1. Capital Markets Data Modeli ng* Design and maintain physical and logical data models for Capital Markets domains, including trade execution, portfolio positions, market data (ticks/pricing), and risk metric s.• Translate complex financial hierarchies (e.g., fund-of-funds, multi-asset class structures) into optimized Databricksstructure s.• Ensure data models support temporal requirements, such as Point-in-Time (PIT) analysis and "As-Of" financial reportin g.2. Advanced STM (Source-to-Target Mapping) Creati on• Lead the creation of comprehensive STM documents, detailing the journey from legacy financial systems and external providers (e.g., Bloomberg, Reuters, Aladdin) to ADLS Gen 2.• Define complex transformation logic, business rules, and data enrichment steps within the STM to guide Data Engineering squad s.• Map data lineage to ensure full traceability for regulatory complianc e.3. Databricks & ADLS Performance Engineeri ng• Design Delta Lake structures that prioritize "Shuffle-free" joins for massive capital markets dataset s.• Implement optimized partitioning and Z-Ordering strategies specifically for time-series financial data to enable high-speed analytic s.• Utilize Unity Catalog to govern data access and maintain a centralized metadata repository for the GWAM ecosyste m.______________________________________ __Required Skills & Qualificatio ns• Industry Expertise: 5+ years of experience in Capital Markets or Wealth Management, with a deep understanding of financial instruments and trade lifecycle s.• Technical Modeling: 7+ years of experience in data modeling, with a mastery of Azure Databricks and ADLS Gen 2.• STM Mastery: Proven track record of creating highly detailed Source-to-Target Mappings for complex data migration or integration project s.• Data Engine Proficiency: Expert-level Spark SQL and PySpark. Ability to optimize data structures for the Spark Catalyst Optimize r.• Storage Formats: Expertise in Delta Lake (ACID transactions, Time Travel) and Parquet optimizatio n.• Governance: Hands-on experience implementing data governance and security via Unity Catalo g.______________________________________ __Technical Sta ck• Compute: Azure Databricks (Jobs, SQL Warehouses ).• Storage: ADLS Gen2 (Delta/Parquet ).• Governance: Unity Catalo g.• Analysis Tools: SQL, Python, Excel (for data profiling ).• Documentation: Confluence/Visio for STM and ERD s. Thanks & Reg a rds Aayush Kha tanaSr. Executive Recru iterHIREON TECH INC.E-mail: aayush.k@hireontech .com

Want to see how well you match this job?