Snowflake Solutions Architect

Location: New York, NY / Hybrid Preferred (Remote is available for highly qualified candidates)

Employment Type: Full-Time / Contract

We are looking for a Senior Snowflake Solutions Architect to support a strategic data warehousing and integration initiative for a leading financial-services / hedge fund client. The ideal candidate will be a hands-on Snowflake expert who can design enterprise data warehouse solutions, integrate multiple data sources, optimize performance and cost, and work directly with business and technology stakeholders.

Key Responsibilities:

• Design and implement scalable Snowflake data warehouse architectures.
• Serve as the Snowflake SME/Architect and provide technical guidance.
• Design and optimize ETL/ELT pipelines and data models.
• Work with multiple upstream/downstream systems and applications.
• Perform Snowflake performance, workload, security, and cost optimization.
• Collaborate with data engineering, application, infrastructure, security, and business teams.
• Troubleshoot production data, pipeline, and integration issues.
• Document architecture and technical standards.

Required Skills:

• Strong hands-on Snowflake architecture and implementation experience.
• Advanced SQL, data warehousing, data modeling, and ETL/ELT.
• Strong knowledge of Snowflake warehouses, stages, streams, tasks, clustering, RBAC, and performance tuning.
• Experience building and supporting production data pipelines.
• Strong data integration and architecture experience.
• Excellent communication and stakeholder-management skills.
• Ability to work as both a hands-on engineer and technical architect.

Preferred Skills:

• Experience in hedge funds, asset management, investment management, capital markets, or financial services.
• Experience with dbt, Airflow, Fivetran, Informatica, Matillion, or similar tools.
• Python and AWS/Azure experience.
• Experience with financial data such as trades, positions, securities, pricing, P&L, risk, or market data.
• Snowflake certification is a plus.

Flexible work from home options available.