Senior Snowflake Data Engineer — Scale Analytics & Pipelines

Lateral Group; United States; Remote; USD 150,000 - 210,000; Full time

Job summary

Lateral Group is seeking a senior data engineer to design, build, and operate large-scale analytics infrastructure on Snowflake. You will own ingestion, transformation, modeling, and performance tuning to ensure reliable, cost-aware pipelines.

You will implement ingestion frameworks from APIs, files, SaaS tools, and cloud storage, model data using 3NF, Data Vault, and dimensional schemas, and tune warehouse sizing for balance of cost and performance.

Qualifications

• Hands-on experience building production pipelines on Snowflake.
• Strong SQL craft, including stored procedures, UDFs, and tuning.
• Familiarity with ingestion from APIs, flat files, SaaS, and cloud storage.
• Knowledge of data modeling approaches: 3NF, Data Vault, and dimensional schemas.
• Experience with CI/CD for data workflows and automated testing.
• Comfort working in a distributed, asynchronous environment with multiple stakeholders.

Responsibilities

• Design, build, and maintain scalable data pipelines and transformation logic using Snowflake features such as SnowSQL, Snowpark, Streams, Tasks, and Warehouses.
• Develop and optimize complex SQL, stored procedures, user-defined functions, and high-throughput queries against large datasets.
• Implement ingestion frameworks that connect APIs, files, SaaS platforms, and cloud storage into a unified data layer.
• Model data using 3NF, Data Vault, and dimensional approaches to support analytics and enterprise reporting.
• Tune warehouse sizing, caching, and compute usage to balance cost and performance.
• Strengthen data quality, lineage, and reliability practices, partnering closely with technical program managers, analysts, and product stakeholders.

Skills

Snowflake

SQL

Stored procedures

UDFs

Query performance tuning

CI/CD for data workflows

Data modeling

3NF

Data Vault

Dimensional schemas

Tools

Snowpark

Job description

Lateral Group is seeking a senior data engineer to design, build, and operate large-scale analytics infrastructure on Snowflake. You will own ingestion, transformation, modeling, and performance tuning to ensure reliable, cost-aware pipelines.

You will implement ingestion frameworks from APIs, files, SaaS tools, and cloud storage, model data using 3NF, Data Vault, and dimensional schemas, and tune warehouse sizing for balance of cost and performance.