Remote Snowflake Architect & Data Warehouse Strategist

INFOTRON; New York (NY); Hybrid; USD 150,000 - 210,000; Full time

Benefits offered by this job

Flexible work from home

Job summary

INFOTRON is seeking a Senior Snowflake Solutions Architect to design enterprise data warehouse solutions and integrate multiple data sources. You will optimize performance and cost while collaborating with business and technology stakeholders to deliver scalable data architectures.

The role requires hands-on Snowflake expertise, strong SQL and data modeling skills, and experience building production data pipelines. Hybrid work is available with remote options for highly qualified candidates.

Qualifications

• Strong hands-on Snowflake architecture and implementation.
• 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.

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.

Skills

Snowflake architecture

SQL & data warehousing

ETL/ELT design

Data modeling

Data integration

Production pipelines

Stakeholder comms

Hands-on + architectural

Tools

dbt

Airflow

Fivetran

Informatica

Matillion

Python

AWS

Azure

Job description

INFOTRON is seeking a Senior Snowflake Solutions Architect to design enterprise data warehouse solutions and integrate multiple data sources. You will optimize performance and cost while collaborating with business and technology stakeholders to deliver scalable data architectures.

The role requires hands-on Snowflake expertise, strong SQL and data modeling skills, and experience building production data pipelines. Hybrid work is available with remote options for highly qualified candidates.