Senior Snowflake Engineer

Lateral Group

. Design, develop, and maintain scalable Snowflake data pipelines and transformation logic using SnowSQL, Snowpark, Streams, Tasks, and Warehouses .

Posted 10/1/2026full-timeRemoteSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and maintaining scalable Snowflake data pipelines, optimizing SQL performance, and implementing data ingestion frameworks. Proficient in data modeling, ensuring data quality, and collaborating with cross-functional teams to deliver effective data solutions.

Highest-signal resume keywords

Snowflake DevelopmentAdvanced SQL ExpertiseETL/ELT Tools ExperienceData Modeling for AnalyticsCloud Data Ecosystems

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SnowSQLSnowparkSQLStored ProceduresUDFsData Vault3NF ModelingPerformance TuningData QualityCI/CD Processes

Soft Skills

Strong Communication Skills

Tools & Technologies

DbtAirflowAzure Data FactoryAWS GlueMatillionTableauLookerPower BI

Industry Keywords

Data EngineeringData GovernanceSchema DesignLifecycle ManagementData Ingestion Frameworks

Tech Stack

Tools & technologies

AirflowAWSAzureCloudETLGoogle Cloud PlatformMatillionSQLTableauVault

About the role

Key responsibilities & impact

Design, develop, and maintain scalable Snowflake data pipelines and transformation logic using SnowSQL, Snowpark, Streams, Tasks, and Warehouses
Build and optimize complex SQL, stored procedures, UDFs, and performance-tuned queries
Implement data ingestion frameworks and integrations from APIs, files, SaaS systems, cloud storage, and other sources
Model and structure data using 3NF, Data Vault, and dimensional modeling
Optimize Snowflake compute usage, warehouse sizing, caching strategies, and cost-performance tradeoffs
Ensure data quality, lineage, observability, and reliability throughout the pipeline lifecycle
Improve CI/CD processes for data development, including version control, automated testing, and safe deployment patterns
Work with TPMs and client stakeholders to clarify requirements, scope data work, communicate progress, and align timelines
Collaborate with engineers, analysts, and product teams to deliver business-focused data solutions
Contribute to documentation, coding standards, and data engineering best practices

Requirements

What you’ll need

5+ years of experience in data engineering
At least 2–3 years dedicated to Snowflake development
Advanced SQL expertise, including optimized queries, analytical functions, complex transformations, and performance tuning
Hands-on experience with Snowflake Warehouses, RBAC, Streams, Tasks, Snowpipe, external stages, and data sharing
Strong experience with ETL/ELT tools and orchestration such as dbt, Airflow, Azure Data Factory, AWS Glue, or Matillion
Experience modeling data for analytics and operational systems, including star/snowflake schemas and Data Vault
Deep understanding of data quality, governance, schema design, and lifecycle management
Comfort working with AWS, Azure, or GCP cloud data ecosystems
Experience integrating Snowflake with Tableau, Looker, Power BI, and downstream consumers
Strong communication skills with technical and non-technical stakeholders
High standards for craft, reliability, and accuracy

Benefits

Comp & perks

Remote-first work from home, co-working spaces, or offices
Flexible remote work and optional office access
Async collaboration and respect for time zones
Professional growth and opportunities for greater responsibility
Meaningful work across healthcare, commerce, sustainability, and next-generation technology
Sustainable workload with no burnout or crunch
Variety and stability at a profitable, independent company
Supportive, talented, and collaborative team culture