Snowflake Data Engineer

Location: San Francisco Bay Area / RemoteNexDimension partners with mid-market companies to build analytics platforms that deliver trusted data to the business. We are looking for a Snowflake Technical Lead to drive pipeline architecture and development on client engagements, working directly alongside NexDimension’s senior architects.

Key Responsibilities: Technical Leadership Lead and mentor a team of 2-3 mid-level and junior data engineers across client engagements Provide technical guidance, code reviews, and best practices to ensure delivery quality Translate business requirements into technical designs, user stories, and acceptance criteria Own the full development lifecycle from ingestion through transformation, testing, and deployment Data Engineering & Architecture Architect and develop ELT pipelines using Snowflake, dbt, and Azure services (Azure Data Factory, Azure Blob Storage) Design Integration Layer structures aligned to NexDimension’s Analytical MDM methodology Optimize Snowflake performance and compute costs through smart data modeling and materialized views Design data flows and transformations based on ingestion and analytic requirements Hands-On Development Write and optimize complex SQL (SnowSQL, dbt models) and Snowflake UDFs Build and manage pipelines using dbt for transformation and SnowPipe for continuous loading Support unit testing and QA initiatives DevOps & CI/CD Implement CI/CD pipelines using GitHub, Azure DevOps, and deployment automation tools Maintain source control, release management, and secure deployment practices Collaborate with architecture teams to ensure scalable, governed solutions Stakeholder Engagement Work directly with NexDimension architects, client stakeholders, and analysts to align technical design with business goals Participate in Agile ceremonies as a key technical contributor Identify technical risks, propose mitigation strategies, and support production issue resolution

What We’re Looking For: 7+ years of data engineering experience with Snowflake as the primary platform Strong dbt expertise — models, tests, documentation, and deployment Kafka or similar streaming platform experience Strong SQL — SnowSQL, stored procedures, UDFs Experience leading small engineering teams on complex data platform builds Familiarity with Kimball dimensional modeling a strong plus Skills & Experience Bachelor’s degree in Computer Science, Engineering, or a related field 5+ years of hands-on Snowflake experience in a production environment 5+ years of technical lead experience managing developers and delivering solutions 7+ years total in data engineering, data warehousing, and ELT pipeline development Strong SQL proficiency — SnowSQL, stored procedures, and UDFs Proven experience with dbt for transformation, testing, and deployment Experience working with structured and semi-structured data (JSON, Parquet) Solid understanding of Snowflake performance tuning, cost management, and licensing Hands-on experience with data lakes, data masking, and access control Strong foundation in dimensional modeling, data profiling, and metadata management Familiarity with Kimball methodology a strong plus Ready to architect a data platform built to last?“Zbis is here… Wow!!! It’s better than what we expected. This is transformational to our company and how we drive our business forward. It’s customer-centric, fact-driven, and captures margins and market-share across all dimensions. Zbis is truly a game changer!” – Frederick Howard