Senior Snowflake Engineer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Snowflake Engineer building scalable pipelines and analytics data platforms for Lateral’s client products. Optimizing Snowflake, SQL, ingestion, modeling, quality, and delivery.
Responsibilities:
- 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:
- 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:
- 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
Similar Jobs
Lead Substation Engineer
Lead substation engineer designing transmission, distribution, and renewable-energy infrastructure for AECOM. Providing technical leadership across utility projects, grid modernization, and construction support.
Interview Engineer
Interview Engineer facilitating technical interviews for Karat, which supports developer hiring worldwide. Evaluating coding skills, technical knowledge, and candidate performance through its interview platform.
Interview Engineer
Interview Engineer facilitating technical interviews and evaluating developers for Karat's hiring platform. Collaborating on interview content, processes, and products.
Interview Engineer
Interview Engineer facilitating software interviews for Karat's global technical hiring platform. Evaluating coding skills and collaborating on interview content, processes, and products.
Interview Engineer
Contract Interview Engineer facilitating technical interviews and evaluating software developers for Karat. Collaborating on inclusive hiring processes, content, and platform improvements.
Interview Engineer
Interview Engineer facilitating coding and technical interviews for Karat, which supports software engineering hiring. Evaluating candidates and partnering on interview content, processes, and products.
Interview Engineer
Interview Engineer facilitating technical interviews and evaluating developers through Karat's platform. Contract opportunity for candidates based in Kenya.
Interview Engineer, Japan
Contract Interview Engineer facilitating technical interviews and evaluating developers through Karat’s platform. Creating objective, inclusive hiring processes for software teams.
Interview Engineer
Interview Engineer facilitating technical interviews and evaluating developers for Karat’s global hiring platform. Contract work focused on objective coding assessments and inclusive candidate experiences.
Senior Entity Resolution Engineer
Senior Entity Resolution Engineer building production entity-resolution and graph provenance systems. Supporting DEFCON AI’s AI-driven platform for resilient optimization of complex government missions.
Senior Distribution Engineer – Electric Utilities
Senior Distribution Engineer reviewing electric and gas utility designs for Capital Project Intelligence. Ensuring QA/QC compliance, approvals, cost reviews, and construction readiness for California clients.
Forward Deployed Engineer
Forward Deployed Engineer deploying and improving Field AI’s autonomous robotic systems in customer environments. Integrating software, hardware, and AI systems while enabling customer adoption.
Staff Forward Deployed Engineer
Staff Forward Deployed Engineer building AI-powered client integrations for OpenLoop’s telehealth infrastructure. Creating reusable SDKs, agents, API tooling, and deployment practices across U.S. virtual care.
Specification Engineer – HVAC
Specification Engineer expanding HVAC cooling and heating solutions across Spain’s Levante region. Advising customers on efficient climate-control products while driving product specification growth.
Senior Technical Services Engineer – Remote US West
Senior Technical Services Engineer troubleshooting WEKA enterprise infrastructure for top-tier customers. Bridging customer needs with Engineering while supporting storage, networking, virtualization, and cloud environments.
Senior Technical Services Engineer – Remote US West
Senior Technical Services Engineer supporting WEKA’s enterprise infrastructure customers. Troubleshooting Linux, networking, storage, cloud, and HPC environments while bridging customers and Engineering.
Designated Services Engineer
Senior services engineer supporting enterprise customers using WEKA’s AI-native data infrastructure. Troubleshooting distributed storage, networking, and cloud systems while bridging customers and Engineering.
Exposure Management Engineer
Exposure Management Engineer deploying Axonius-based asset and vulnerability management for GuidePoint Security, a cybersecurity solutions provider. Automating remediation workflows and improving clients' cyber risk visibility.
Technical Success Engineer
Technical Success Engineer helping investment firms maximize Addepar’s financial data and AI platform. Delivering client solutions, automating workflows, and partnering cross-functionally to improve investment operations.
Lead Program Engineer – Major Projects Group
Lead program engineer integrating renewable, gas, storage, and data center infrastructure for Blattner. Coordinating engineering scopes, design reviews, budgets, procurement, and construction support.