Snowflake Data Engineer

We are seeking a
Snowflake Data Engineer
with a strong background in cloud data engineering to join our high-performing Enterprise Data Services team. This role demands a
hands-on leader
with deep experience in
Snowflake
,
SQL
, and
ETL/ELT development
, responsible not only for solution design but also execution, team leadership, and code quality assurance.

Location:

San Francisco Bay Area / Remote

Nex Dimension 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 Nex Dimension’s senior architects.

• 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

• Architect and develop ELT pipelines using Snowflake, dbt, and Azure services (Azure Data Factory, Azure Blob Storage)
• Design Integration Layer structures aligned to Nex Dimension’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

• Write and optimize complex SQL (SnowSQL, dbt models) and Snowflake UDFs
• Build and manage pipelines using dbt for transformation and Snow Pipe for continuous loading
• Support unit testing and QA initiatives

• Implement CI/CD pipelines using Git Hub, Azure Dev Ops, and deployment automation tools
• Maintain source control, release management, and secure deployment practices
• Collaborate with architecture teams to ensure scalable, governed solutions

• Work directly with Nex Dimension 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

• 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

• 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