What are the responsibilities and job description for the Snowflake Architect position at Programmers.io?
Hi
Hope you are doing well !
This is Dipendra Gupta from Programmers.ai as we have an urgent open role below, please check and do let me know if you
are comfortable with Job description and looking for a new role or interested.
Role: Snowflake Architect
Location: Chicago, IL (3 Days onsite/week)
Yrs. of experience: 10 Yrs.
Mode of employment: 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)
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.