Sr SQL Data Engineer with Snowflake

Sr SQL Data Engineer with Snowflake

Posted Today by People Force Consulting Inc

Negotiable
Undetermined
Remote
Remote

Summary: As a Sr SQL Data Engineer with Snowflake, you will join an Agile team focused on developing healthcare applications and implementing new features while maintaining high coding standards. The role requires extensive experience in SQL, Python, and Snowflake, with a strong emphasis on data modeling and pipeline design. You will collaborate with business leaders to translate requirements into technical solutions and optimize data performance. This position is remote, with potential travel to client locations as needed.

Key Responsibilities:

  • Design and implement scalable data models and pipelines that align with business objectives
  • Develop complex DBT models using advanced features (macros, packages, custom materializations)
  • Collaborate with business leaders to translate complex requirements into technical solutions
  • Identify and resolve performance bottlenecks in Snowflake queries and DBT models
  • Optimize Snowflake warehouse configurations and query performance
  • Design and implement data quality frameworks and testing strategies
  • Create reusable DBT packages and macros for team-wide use
  • Manage CI/CD pipelines for DBT deployments

Key Skills:

  • 10+ years of experience in SQL, Python, DBT, and Snowflake
  • Engineering Degree (BE/ME/BTech/MTech/BSc/MSc)
  • Technical certification in multiple technologies is desirable
  • Highly skilled in SQL
  • Intermediate or higher skill level in Python
  • Real-world experience using Snowflake
  • Experience in data profiling and identifying unique and primary keys
  • Experience with DBT

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

As a Sr SQL Data Engineer with Snowflake you will be a part of an Agile team to build healthcare applications and implement new features while adhering to the best coding development standards.

Experience: - 10+Years

Location: - Remote / PST work hours, travel to client location as needed.

Educational Qualifications: -

  • Engineering Degree BE/ME/BTech/MTech/BSc/MSc.

Technical certification in multiple technologies is desirable.

Mandatory skills - Python, DBT , Snowflake, SQL

Responsibilities: -

SQL: Highly Skilled

Python: Some experience is required. We prefer Intermediate or higher skill.

Snowflake: Prefer candidates with real-world experience using Snowflake.

Data Profiling: Must be able to identify unique and primary keys and determine cardinality, data type, precision, and scale, and skew.

DBT: Prefer candidates with real-world DBT experience.

Snowflake: Prefer candidates with real-world experience using Snowflake.

Design and implement scalable data models and pipelines that align with business objectives

Develop complex DBT models using advanced features (macros, packages, custom materializations)

Collaborate with business leaders to translate complex requirements into technical solutions

Identify and resolve performance bottlenecks in Snowflake queries and DBT models

Optimize Snowflake warehouse configurations and query performance

Design and implement data quality frameworks and testing strategies

Create reusable DBT packages and macros for team-wide use

Manage CI/CD pipelines for DBT deployments