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.
Recommended Jobs
Vision Therapist
Job Description Job Description Vision Therapist The MedServ Group Compensation : $25.00 - 30.00 per hour. Schedule : 1 Visit Monthly. The MedServ Group is a rapidly growing medical…
Retail Associate
Retail Associate — Madison Avenue Flagship 1069 Madison Avenue, New York City Full-Time / Part-Time · In-Person We're Roxanne Assoulin — a New York jewelry brand built on color, happiness, and t…
Bartender
Located in the heart of Grand Central Terminal, Grand Brasserie is where classic brasserie energy meets modern New York vibrancy. We’re bringing that energy to life with a menu that’s crafted for enj…
Accounts Receivable Specialist
Role: AR Specialist Location: Manhattan, NY Pay: $30 - $34 / hour Hours: 37.5 hours per week, Hybrid Schedule Benefits: This position is eligible for medical, dental, vision, and 401(…
Retail Sales Associate - The UPS Store
Retail Sales Associate - The UPS Store (Customer Service, Shipping & Printing) Locations: Multiple openings across Long Island and NYCPay: $17 - $20/hour (based on experience)Job Type: Full-time or …
SHIFT SUPERVISOR (FULL TIME)
Job Description Job Description We are hiring immediately for full time SHIFT SUPERVISOR positions. Location : Capital One - 731 Lexington Avenue, New York, NY 10022 Note: online applic…
Office Manager
Job Description Job Description This is your chance to be part of a champion team with a unique, forward-thinking company that is paving the way in the PT industry with its non-traditional approa…
Physical Education (gym teacher for Pre k - 4th)
Job Description Job Description Elementary school gym teacher to work with very young children from Pre-K to 4th Grade; creates interactive games that are simple and easy for the students to unde…
Infant Nanny Position
Start Date: January, 2027 Location: Melville, NY (Long Island) Compensation: $30 per hour Schedule: Rotating two-week schedule — Week 1: Monday–Thursday, 6:30 AM–6:30 PM; Week 2: Monday–Thur…