Snowflake Data Cloud Architect - Hybrid @ New York, NY - Must be local

Hybrid @ New York, NY - Must be local

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 Data Quality Tool 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.