Senior Snowflake Architect - Data Modernization & Ingestion

Moder Solutions; United States; Remote; USD 180,000 - 240,000; Full time

Job summary

Moder Solutions is seeking a Senior Data Architect to design Snowflake-based data platforms for enterprise clients across BFSI and other domains. You will lead end-to-end data migration, modernization, and governance initiatives, translating complex requirements into scalable data models and pipelines.

You will configure and optimize Snowpipe, ensure security and compliance, mentor junior engineers, and collaborate with stakeholders to deliver high-performance analytics solutions with CI/CD for

Qualifications

• 12-15 years of experience as Data Architect, with high-volume data warehouse and lakehouse platforms.
• Minimum 5 years hands-on Snowflake experience: data modeling, schema design, performance tuning.
• Deep understanding of Snowflake architecture, security, computing patterns and scaling.
• Strong Snowpipe expertise: building, scheduling, monitoring ingestion pipelines.
• Proficiency with ETL/ELT tools: Informatica, Talend, Matillion, dbt, and cloud-native tools.
• Scripting skills: SQL, Python or Scala for UDFs and orchestration.
• Cloud data platforms (Azure, AWS, GCP) with focus on security, roles, and data governance.
• Excellent communication for client-facing discussions and solution presentations.
• Experience with data migration, modernization, and CI/CD for data pipelines.

Responsibilities

• Architect, design, and implement Snowflake-based data solutions for enterprise clients across BFSI and other domains.
• Lead end-to-end data migration and modernization projects, transitioning legacy environments to Snowflake.
• Configure and optimize Snowpipe for automated, scalable data ingestion from diverse sources.
• Define and implement data governance, security, and compliance protocols leveraging Snowflake features.
• Collaborate with business stakeholders to translate requirements into high-performance data models and workflows.
• Develop reusable frameworks and accelerators for Snowpipe-based batch and real-time ingestion pipelines.
• Monitor and troubleshoot Snowpipe jobs, optimizing costs, performance, and reliability.
• Document best practices, architectures, and implementation approaches for Snowflake-centric ecosystems.
• Mentor and guide junior staff in Snowflake, Snowpipe, and cloud-native ETL development.

Skills

Snowflake

Snowpipe

Data modeling

SQL

Python

Scala

Cloud platforms

Data governance

Communication

Education

Bachelor’s or Master’s in Computer Science, Engineering, or related discipline

Tools

Informatica

Talend

Matillion

dbt

Azure

AWS

GCP

Job description

Moder Solutions is seeking a Senior Data Architect to design Snowflake-based data platforms for enterprise clients across BFSI and other domains. You will lead end-to-end data migration, modernization, and governance initiatives, translating complex requirements into scalable data models and pipelines.

You will configure and optimize Snowpipe, ensure security and compliance, mentor junior engineers, and collaborate with stakeholders to deliver high-performance analytics solutions with CI/CD for