Aladdin Data Cloud: Snowflake Integration for Private Markets Reporting
Type: Internal Platform Product | Sector: Fintech / Data Infrastructure
Role: Product Manager
Keywords: Snowflake, Data Architecture, Reporting APIs, Row-Level Security, Whole Portfolio, Data Unification
Product Overview
This initiative focused on integrating private markets data into the firmwide Aladdin Data Cloud (ADC) via a Snowflake-based data architecture. The goal was to unify legacy reporting systems (like eFront) and enable scalable, API-accessible reporting for institutional clients managing both public and private assets.
The project was part of the broader Whole Portfolio strategy, providing a single source of truth for private equity, real estate, credit, and fund-of-funds data — delivered through Aladdin’s enterprise cloud ecosystem.
Objectives
Migrate legacy reporting datasets to Snowflake to support scalable analytics, automation, and role-based access
Standardize data models across positions, valuations, and cash flows to power downstream reporting APIs
Lay the foundation for integrated portfolio monitoring across private and public markets via ADC
Enable self-serve and real-time reporting experiences for investment teams and client ops
My Role & Responsibilities
🔄 Data Model Design & Governance
Partnered with engineering leads and data architects to design a normalized, scalable schema for reporting tables in Snowflake
Defined metadata tagging and transformation logic to support multi-level entity ownership, fund hierarchies, and accounting snapshots
Mapped legacy eFront data structures into Snowflake’s columnar model with flexible joins across reporting layers
🔐 Access Management & Security
Collaborated on a row-level security framework in Snowflake to support user-specific data entitlements
Integrated internal permissioning logic to support portfolio-level visibility and secure sharing with external stakeholders
🚀 Reporting API Enablement
Delivered core data views to power new Aladdin reporting APIs for positions, NAV, investor flows, and fund-level metrics
Structured query patterns and performance SLAs to support both bulk data extracts and on-demand analytics
📊 Telemetry-Driven Product Decisions
• Used internal telemetry data to identify top usage patterns, broken query logic, and priority reporting fields
• Defined new features to support high-traffic endpoints and reduce load on legacy pipelines
🤝 Stakeholder & Cross-Team Coordination
Served as product lead across Snowflake, Aladdin, and Reporting API teams, aligning timelines and dependencies
Ran working groups with client-facing product managers to validate feature sets and support rollout across 9+ enterprise clients
Key Achievements
*
Key Achievements *
• Consolidated over 80% of legacy reporting data into Snowflake, enabling unified access across 9 clients managing $300B+ AUM
• Defined the first set of Snowflake views adopted for production use by reporting APIs — powering performance dashboards, fund summaries, and risk analysis
• Introduced a scalable row-level security model compatible with both eFront and Aladdin user roles
• Reduced internal query latency by 60% through optimized view structure and materialization strategies
• Helped lay the groundwork for Whole Portfolio reporting through ADC, aligning private credit and public fund data into a common pipeline