Data Engineer – Snowflake Platform Lead

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

Job summary

A leading company is seeking a skilled Data Engineer to design and implement robust data pipelines using Snowflake within a modern cloud platform. This role encompasses managing data access, integrating with BI and ML teams, and optimizing data workflows to enhance system performance.

Benefits

Competitive salary and performance bonus

Comprehensive health, dental, and vision insurance

401(k) with company match

Flexible work arrangements

Professional development opportunities

Collaborative and innovative work environment

Qualifications

• 10+ years of experience in Data Engineering and AWS.
• 3+ years implementing Snowflake data warehouses.
• Deep proficiency in SQL and query optimization.

Responsibilities

• Design high-performance ELT pipelines in Snowflake.
• Implement cost-efficient data warehouse models.
• Ensure secure data access with RBAC and data-masking.

Skills

SQL Mastery

Data Engineering

Snowflake Expertise

AWS Fundamentals

Performance Optimization

Education

Professional experience in Data Engineering

Tools

dbt

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.