Snowflake Data Cloud Architect

Title: Snowflake Data Cloud Architect
Location: New York, NY

As a Snowflake Data Cloud Architect , you will be responsible for designing and implementing scalable, secure, and high-performance data solutions on Snowflake to support our Investment Management business goals . You will lead the architecture for data platform integration , enabling seamless communication between upstream (custodians, market data providers) and downstream (risk, performance, reporting) systems using event-driven approaches . This role requires strategic thinking, technical leadership, and deep expertise in Snowflake and modern data engineering practices.

The Contributions You''ll Make:

• Architect and Implement Snowflake Solutions:
  • Design and optimize Snowflake-based data architectures for portfolio, security master, transactions, benchmarks, and performance data.
  • Implement advanced Snowflake features (Streams, Tasks, Snowpipe, Snowpark) for real-time and batch processing.
• Enable Event-Driven Integration:
  • Build ingestion pipelines leveraging Kafka, Azure Event Hub, or similar technologies for market data and transactional feeds.
  • Design workflows for upstream and downstream system interoperability.
• Data Governance and Compliance:
  • Implement RBAC, data masking, and encryption aligned with enterprise data policy.
  • Ensure lineage and observability for regulatory reporting and audit.
• Technical Leadership:
  • Act as a trusted advisor for architectural decisions and future-state roadmaps.
  • Prepare technical specifications and design documentation.
• Innovation and Best Practices:
  • Advocate for data quality through automation, validation frameworks, and rigorous testing.
  • Recommend new technologies to improve system performance and reliability.

Minimum Knowledge and Experience:

• Bachelor''s degree in Computer Science, MIS, Engineering, or related field.
• 10 years of experience in data architecture/engineering, with 3 years focused on Snowflake.
• Strong background in financial data domains (IBOR/ABOR, transactions, market data, reference data).
• Hands-on experience with:
  • Snowflake architecture (warehouses, streams, tasks, Snowpark). SQL, Python; experience with DBT.
  • Event-driven technologies (Kafka / Azure Event Hub).
  • Web API development (Flask / FastAPI).
• Experience implementing data security measures and compliance frameworks.
• Experience building data solutions with AI tools like Github Copilot.
• Experience with Data Quality Tools such as dbt Test, Monte Carlo, SODA.
• Excellent communication skills with ability to collaborate across business and technology teams.

Nice to Have:

• SnowPro Core / Advanced Architect certification.
• Experience with Aladdin Data Cloud, Bloomberg DL, or similar investment data platforms.
• Experience with Data Application development (Streamlit, Dash).
• Familiarity with BI tools (Power BI, Tableau).
• Knowledge of FinOps for cost optimization.
• Exposure to Databricks, PySpark, and advanced analytics workflows.