Senior Data Engineer / Analytics Engineer

Job Description: Senior Data Engineer / Analytics Engineer

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.