Snowflake Solutions Architect
INFOTRON New York, New York, United States · $120K–$180K/yr
IT Services and IT Consulting · 2-10 employees
Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
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
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
-
Staff Solutions Architect - N.A. [REMOTE]
Upbound - Job Posting Boston, Massachusetts, United States
-
Staff Solutions Architect - N.A. [REMOTE]
Upbound East Riding of Yorkshire, England, United Kingdom
-
Solutions Architect, AI
Simform - Product Engineering Company Ahmedabad, Gujarat, India
-
Forward Deployed Solutions Architect, Agentic Commerce Trust
Tiger Analytics Inc. United States
-
Splunk Solutions Architect (m/f/d)
Cisco Garching bei München, Bavaria, Germany
-
Sr. Solutions Architect - Amazon Web Services (Canberra), ANZ Federal Government, National Security and Defence Solution Architecture
Amazon Canberra, Australia