JobCubby JobCubby
Sign up
I

Snowflake Solutions Architect

INFOTRON New York, New York, United States · $120K–$180K/yr

IT Services and IT Consulting · 2-10 employees

7 h ago
software-architect Senior (5-10 yrs) Full-time United States
Log in to apply, save this posting, or score it against your profile with AI.

About the role

The Snowflake Solutions Architect will design and implement scalable data warehouse architectures while optimizing ETL/ELT pipelines for performance and cost. They will serve as the technical subject matter expert, collaborating with cross-functional teams to support data integration initiatives.

What they look for

Snowflake Data Warehousing SQL Data Modeling ETL ELT Data Integration Performance Tuning RBAC Python AWS Azure Dbt Airflow Fivetran Stakeholder Management

Requirements

Candidates must possess strong hands-on experience with Snowflake architecture, advanced SQL, and data modeling. Proficiency in building production data pipelines and excellent communication skills are required, with financial services industry experience preferred.

Full description

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.

Similar roles