Closed
Snowflake Developer
PB consulting · Wayland, Massachusetts
It stopped taking applications.
Snowflake Developer
@ PB consultingClosed to new applicants.
PB consultingpbconsulting.com
Closed to new applicants.
Snowflake Developer
Wayland, Massachusetts
Posted 1 week ago
About the job
Our company specializes in data solutions, focusing on data engineering, warehousing, and cloud platforms. This role involves designing and maintaining high-performance Snowflake data pipelines, working with cross-functional teams, and optimizing data workloads for analytics and BI.
Requirements
- 7–12 years data engineering experience
- Hands-on Snowflake expertise
- SQL, ETL/ELT development
- Data modeling and architecture
- Experience with cloud platforms
Qualifications
- Bachelor's degree or equivalent
- Strong analytical skills
- Experience with data security
- Excellent problem-solving
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