Senior Data Engineer: Snowflake/dbt, AI-Powered Pipelines

ZealTech; Sunnyvale (CA); Hybrid; USD 150,000 - 210,000; Full time

Job summary

ZealTech is seeking an experienced Senior Data Engineer / Analytics Engineer in Sunnyvale for a hybrid role. You will design, build, and maintain data pipelines, craft scalable data models, and apply AI-assisted coding tools to boost development productivity and data quality.

You will collaborate with data analysts, business stakeholders, and engineering teams to deliver trusted data solutions, optimize Snowflake workloads on AWS, and implement CI/CD and data governance best practices in

Qualifications

• Design, build, and maintain data pipelines and transformations.
• Develop reliable data models for analytics and reporting.
• Collaborate with analysts and engineers to deliver trusted data.

Responsibilities

• Design, develop, and maintain data pipelines and transformation workflows using SQL, Snowflake, and dbt.
• Build reliable, scalable, and optimized data models for analytics and reporting.
• Use Git for version control, code collaboration, and source code management.
• Work with Snowflake hosted on AWS, including data integrations, security, access controls, and connectivity.
• Develop and maintain dbt models, automated tests, documentation, and data quality checks.
• Leverage AI coding tools such as GitHub Copilot, Cursor, or ChatGPT to accelerate coding, debugging, testing, and documentation.
• Optimize SQL queries and Snowflake workloads for performance and cost efficiency.
• Collaborate with data analysts, business stakeholders, and engineering teams to deliver trusted data solutions.
• Follow best practices for code reviews, CI/CD, data governance, and production support.

Skills

SQL

Data transformation

Analytical thinking

Problem solving

Tools

Snowflake

dbt

Git

AWS

GitHub Copilot

Cursor

ChatGPT

Job description

ZealTech is seeking an experienced Senior Data Engineer / Analytics Engineer in Sunnyvale for a hybrid role. You will design, build, and maintain data pipelines, craft scalable data models, and apply AI-assisted coding tools to boost development productivity and data quality.

You will collaborate with data analysts, business stakeholders, and engineering teams to deliver trusted data solutions, optimize Snowflake workloads on AWS, and implement CI/CD and data governance best practices in