Data Engineer – Snowflake Platform Lead

None; Boston (MA); Remote; USD 120,000 - 160,000; Full time

Job summary

A leading company is seeking a skilled Data Engineer to architect and optimize data pipelines using Snowflake within a modern cloud platform. The role involves collaboration with BI and ML teams, ensuring data security and efficient workflows, ideal for candidates with over 10 years of relevant experience in data engineering.

Benefits

Competitive salary and performance bonus

Comprehensive health, dental, and vision insurance

401(k) with company match

Flexible work arrangements

Professional development opportunities

Qualifications

• 10+ years of professional experience in Data Engineering.
• 3+ years implementing and tuning Snowflake data warehouses.
• Strong written and verbal communication skills.

Responsibilities

• Design and build high-performance ELT workflows in Snowflake.
• Implement cost-efficient schemas and performance optimizations.
• Collaborate with BI and ML teams to integrate data solutions.

Skills

Data Engineering

SQL Mastery

Snowflake Expertise

Performance Optimization

Data Integration

Collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

SnowSQL

Apache Airflow

AWS Glue

Job description

• Location: Remote (EST) | Boston
• Employment Type: Full-Time (No-immigration support)
• Experience Level: 10+ Years in Data Engineering, with Snowflake expertise

Position Overview

We’re seeking a skilled Data Engineer to architect, develop, and optimize Snowflake‐powered data pipelines within a modern cloud data platform. In this role, you will lead ELT workflow design, implement cost‐efficient warehouse models, and enforce secure data access through advanced RBAC and data-masking policies. You’ll collaborate closely with BI and ML teams to ensure seamless integration, high performance, and optimal storage/compute utilization.

Key Responsibilities

• ELT Pipeline Development: Design and build high-performance, modular ELT workflows in Snowflake using SnowSQL, dbt, Airflow, or AWS Glue.
• Warehouse Modeling: Implement cost-efficient schemas (star, snowflake, or hybrid), clustering, and data partitioning strategies to optimize compute and storage.
• Performance Tuning: Analyze query performance; apply optimizations such as micro-partition pruning, result caching, and warehouse sizing.
• Security & Governance: Configure role-based access control (RBAC), dynamic data masking, and object-level permissions; manage secure data sharing and Snowflake Data Marketplace integrations.
• Cloud Integration: Interface Snowflake with AWS services (S3, Lambda, IAM); automate data ingestion and event-driven processes.
• BI & ML Enablement: Collaborate with analytics and data science teams to integrate BI tools (e.g., Looker, Tableau, Power BI) and support ML pipelines with feature tables and Snowpark.
• Monitoring & Troubleshooting: Implement observability (query history, resource monitors); troubleshoot production issues and enforce SLAs.
• Best Practices & Documentation: Establish coding standards, version control, and CI/CD for data projects; author clear technical documentation and runbooks.

Required Qualifications

• 10+ years of professional experience in Data Engineering and AWS
• Snowflake Expertise: 3+ years implementing and tuning Snowflake data warehouses, SnowSQL, and Snowflake-specific features.
• SQL Mastery: Deep proficiency in SQL, query optimization, and analytical query patterns.
• Orchestration Tools: Hands-on experience with dbt, Apache Airflow, or AWS Glue for workflow automation.
• Cloud Fundamentals: Familiarity with AWS S3, Lambda functions, and IAM for secure, serverless data workflows.
• Performance & Cost Optimization: Proven ability to partition data, size virtual warehouses, and apply caching strategies.
• Security Practices: Experience configuring RBAC models, dynamic masking, and secure data sharing in Snowflake.
• Integration Skills: Track record of connecting Snowflake to BI platforms and supporting ML feature engineering.
• Collaboration & Communication: Strong written and verbal skills; comfortable gathering requirements and presenting technical solutions to stakeholders.

Preferred Qualifications

• Certifications in Snowflake (SnowPro Core) or AWS
• Experience with Snowflake’s Snowpark API for Python, Scala, or Java
• Familiarity with data catalog and governance tools (e.g., Collibra, Alation)
• Background in agile development and CI/CD for data projects (Jenkins, GitLab CI/CD)
• Prior work in regulated industries (finance, healthcare, insurance)

Benefits

• Competitive salary and performance bonus
• Comprehensive health, dental, and vision insurance
• 401(k) with company match
• Flexible work arrangements
• Professional development and continuous learning opportunities
• Collaborative and innovative work environment

Our company is an Equal Opportunity Employer committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Application Process:Qualified candidates should submit their resume, cover letter, and a brief description of relevant projects.