Snowflake Architect

Position: Snowflake Architect

Location: Chicago, IL (Hybrid)

Duration: Full Time

Job Responsibilities:

• Document data flows, data model and data architecture (security)
• Application Architecture (Cloud, Solution Design)
• Asset/Investment Management domain knowledge (AUM, Performance, Holdings)
• 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.
• 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.
• Collaborate with business stakeholders in investment operations, compliance, performance, and reporting teams to translate business concepts into structured data requirements and relationships.
• Document data definitions, hierarchies, and entity relationships to enable standardized reporting, analytics, and operational use across asset management functions.
• 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.
• Ensure alignment with enterprise data architecture and regulatory standards, focusing on data quality, consistency, lineage, and business traceability.