Snowflake Developer

@ PB consulting
PB consultingpbconsulting.com

Snowflake Developer

Somerville, Massachusetts
Posted today

About the job

Our client specializes in data platforms and cloud solutions. This role focuses on designing scalable data pipelines, optimizing Snowflake architecture, and supporting analytics and BI efforts.

Requirements

  • 7–12 years data engineering experience
  • Hands-on Snowflake expertise
  • Advanced SQL development
  • ETL/ELT data pipeline skills
  • Cloud platform experience

Qualifications

  • Bachelor's degree in related field
  • Strong problem-solving skills
  • Knowledge of data security
  • Experience with CI/CD processes

Full job description

We are seeking an experienced Snowflake Developer with 7–12 years of experience in data engineering, data warehousing, and cloud data platforms. The ideal candidate will have strong hands-on expertise in Snowflake, SQL, ETL/ELT, data modeling, and cloud-based data solutions, with the ability to design and deliver scalable, high-performance data pipelines.

Required Technical Skills
  • 7–12 years of experience in data engineering, data warehousing, or database development.
  • Strong hands-on experience with Snowflake data platform and architecture.
  • Advanced proficiency in SQL and experience developing complex queries, stored procedures, views, and database objects.
  • Strong experience with ETL/ELT development and data pipeline design.
  • Experience with Snowflake features including warehouses, databases, schemas, stages, streams, tasks, views, and data sharing.
  • Strong understanding of data modeling, including dimensional modeling, fact/dimension tables, and schema design.
  • Experience integrating Snowflake with various source systems, APIs, databases, and cloud storage platforms.
  • Experience with at least one cloud platform, preferably AWS, Azure, or GCP.
  • Strong knowledge of data performance tuning, query optimization, and warehouse optimization.
  • Experience with data quality, validation, security, access controls, and governance.
  • Proficiency with Git and exposure to CI/CD and automated deployment processes.
Roles & Responsibilities
  • Design, develop, and maintain scalable Snowflake data solutions.
  • Develop efficient SQL queries, stored procedures, views, and data transformation logic.
  • Build and maintain reliable ETL/ELT pipelines for batch and real-time data processing.
  • Develop data models to support analytics, reporting, and business intelligence requirements.
  • Optimize Snowflake queries, warehouses, storage, and workloads for performance and cost efficiency.
  • Implement Snowflake Streams and Tasks for incremental and automated data processing.
  • Integrate Snowflake with enterprise data sources, cloud storage, and downstream applications.
  • Implement data quality checks, validation processes, and error-handling mechanisms.
  • Support data security, governance, access management, and compliance requirements.
  • Troubleshoot data pipeline, SQL, performance, and production issues.
  • Participate in technical design discussions, code reviews, and architecture decisions.
  • Develop and maintain technical documentation and data process specifications.
  • Collaborate with Data Engineers, Data Architects, BI Developers, Data Scientists, and business stakeholders.
  • Support CI/CD, automated testing, and deployment of Snowflake objects and data pipelines.
Show full description