Senior Data Engineer / Analytics Engineer

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

Location: Sunnyvale, California - Hybrid (Locals)

Job Summary

We are looking for an experienced Senior Data Engineer / Analytics Engineer with strong expertise in SQL, Snowflake, dbt, Git, and AWS. The ideal candidate will build and maintain scalable data pipelines, develop reliable data transformations, and leverage AI-assisted coding tools to improve development productivity and code quality.

Key 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.

Required Skills

• Strong experience with SQL and data transformation.
• Hands-on experience with Snowflake.
• Experience building data models and transformation pipelines using dbt.
• Proficiency with Git and version control workflows.
• Knowledge of AWS cloud services, particularly Snowflake integrations, security, and connectivity.
• Experience using AI-assisted development tools such as Cursor, GitHub Copilot, or ChatGPT.
• Strong analytical, debugging, and problem-solving skills.
• Experience supporting production data pipelines and data quality processes.

Preferred Qualifications

• Experience with automated testing and CI/CD for data pipelines.
• Knowledge of Python and data engineering best practices.
• Experience with data modeling, query optimization, and cloud data architecture.
• Ability to validate AI-generated code and ensure its correctness, security, and maintainability.
• Excellent communication and collaboration skills.

Ideal Candidate

A hands-on Senior Data Engineer / Analytics Engineer with strong SQL, Snowflake, dbt, and Git experience, working knowledge of AWS, and practical experience using AI tools to improve development efficiency.