Business Data Analyst - Capital Markets

Dimensionless Technologies is seeking a Business Data Analyst specialized in Capital Markets. The role involves designing and maintaining data models, creating source-to-target mappings, and optimizing data structures for high-speed analytics in financial datasets.

Responsibilities:

• 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
• 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
• 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