Senior Snowflake Data Architect — FinServ Data Warehousing

Socket.dev; New York (NY); Hybrid; USD 140,000 - 210,000; Full time

Benefits offered by this job

Hybrid work options

Flexible work-from-home policy

Job summary

Socket.dev is seeking a Senior Snowflake Solutions Architect to lead enterprise data warehouse initiatives for a financial services client. You will design scalable Snowflake architectures, build robust data models, and optimize ETL/ELT pipelines while collaborating with business and technology teams.

The role requires hands-on Snowflake expertise and the ability to bridge engineering and architecture perspectives, with hybrid options and remote work for highly qualified candidates.

Qualifications

• Must have hands-on Snowflake design and implementation experience.
• Strong SQL, data warehousing, data modeling, and ETL/ELT skills.
• In-depth knowledge of Snowflake features: warehouses, stages, streams, tasks, RBAC, and performance tuning.
• Experience building and supporting production data pipelines and integrations.
• Excellent communication and stakeholder management.

Responsibilities

• Design 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.

Skills

Snowflake architecture

SQL

Data warehousing

ETL/ELT

RBAC and security

Performance tuning

Data integration

Stakeholder management

Hands-on engineer & architect

Tools

dbt

Airflow

Fivetran

Informatica

Matillion

Python

AWS

Azure

Job description

Socket.dev is seeking a Senior Snowflake Solutions Architect to lead enterprise data warehouse initiatives for a financial services client. You will design scalable Snowflake architectures, build robust data models, and optimize ETL/ELT pipelines while collaborating with business and technology teams.

The role requires hands-on Snowflake expertise and the ability to bridge engineering and architecture perspectives, with hybrid options and remote work for highly qualified candidates.