Lateral Group

Engineer

• 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

Senior Snowflake Engineer