Snowflake Data Engineer

NexDimension AI, Inc; San Francisco (CA); Híbrido; USD 140 000 - 210 000; Tempo integral

Resumo da oferta

NexDimension is seeking a Snowflake Data Engineer to join our Enterprise Data Services team as a hands-on leader. You will architect and deliver ELT pipelines on Snowflake, dbt, and Azure, while guiding a small engineering team and ensuring high-quality deployments.

You will translate business requirements into scalable data solutions, optimize performance and costs, and own the full development lifecycle from ingestion through deployment. A strong SQL and data modeling background is essential.

Qualificações

• Bachelor’s degree in Computer Science, Engineering, or a related field.
• 7+ years of data engineering experience with Snowflake as the primary platform.
• 5+ years of technical lead experience managing developers and delivering solutions.
• 7+ years total in data engineering, data warehousing, and ELT pipeline development.

Responsabilidades

• Lead and mentor a team of 2-3 data engineers across client engagements.
• Architect and develop ELT pipelines using Snowflake, dbt, and Azure services.
• Write and optimize complex SQL (SnowSQL) and dbt models; support testing and QA.
• Implement CI/CD pipelines and maintain secure release practices.

Conhecimentos

Snowflake

dbt

SQL

Team leadership

Kafka

Formação académica

Bachelor’s degree in CS/Engineering

Ferramentas

Azure Data Factory

Azure Blob Storage

SnowPipe

GitHub / Azure DevOps

Descrição da oferta de emprego

We are seeking aSnowflake Data Engineerwith a strong background in cloud data engineering to join our high-performing Enterprise Data Services team. This role demands ahands-on leaderwith deep experience inSnowflake,SQL, andETL/ELT development, responsible not only for solution design but also execution, team leadership, and code quality assurance.

Snowflake Technical Lead

Location: San Francisco Bay Area / Remote

NexDimension 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