Job Responsibilities :
Document data flows, data model and data architecture (security)
Application Architecture (Cloud, Solution Design)
Asset / Investment Management domain knowledge (AUM, Performance, Holdings)
1. Define conceptual and logical data models for key Asset Management areas such as Assets Under Management (AUM), portfolio performance, holdings, transactions, benchmarks, and security master.
2. Design high-level and detailed data flows across the Azure and Snowflake ecosystem, mapping data movement from upstream systems (e.g., custodians, accounting systems, market data feeds) to reporting and analytical layers.
3. Collaborate with business stakeholders in investment operations, compliance, performance, and reporting teams to translate business concepts into structured data requirements and relationships.
4. Document data definitions, hierarchies, and entity relationships to enable standardized reporting, analytics, and operational use across asset management functions.
5. Create and maintain data flow diagrams, source-to-target mappings, and interface specifications to guide data ingestion, transformation, and publishing processes on Azure and Snowflake.
6. Ensure alignment with enterprise data architecture and regulatory standards, focusing on data quality, consistency, lineage, and business traceability.
Snowflake Architect • Chicago, IL, United States