Senior Snowflake Engineer - Technical Lead

Apollopros

South San Francisco (CA)

Hybrid

USD 152,000 - 234,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Apollopros seeks a Senior Snowflake Engineer / Technical Lead to guide the enterprise data platform from Boston in a hybrid arrangement. This 18-month contract-to-hire role demands strong Snowflake design, ELT/ETL excellence, and leadership across distributed teams.

Youll modernize the data stack with Python and SQL, implement governance, and drive performance optimization while mentoring engineers. Transition to full-time leadership is possible based on performance.

Qualifications

  • Bachelor’s degree or equivalent in a technical field.
  • 4+ years of software or data engineering experience.
  • Proven Snowflake production experience and leadership.
  • Strong Python and SQL with data modeling expertise.

Responsibilities

  • Lead Snowflake architecture and data platform leadership for enterprise analytics.
  • Design ELT/ETL pipelines, APIs, and data integrations with governance.
  • Modernize platforms, optimize performance, and manage automated workflows.
  • Ensure security, privacy, and regulatory compliance across environments.
  • Provide technical leadership and mentor engineers on the team.
  • Translate business needs into technical roadmaps and delivery plans.

Skills

SQL
Snowflake
Python
ETL/ELT
Git/GitLab
CI/CD
Data modeling
Data warehousing
APIs
Security

Education

Bachelor's degree in Computer Science or related field

Tools

dbt
Apache Airflow
Snowpark
AWS

Job description

Senior Snowflake Engineer / Technical Lead (Contract-to-Hire) ? Location: Boston, MA (Hybrid) ? Work Schedule: Local candidates only. Beginning in January, this role requires approximately 2.5 days per week onsite (10 days per month). ? Duration: 18-Month Contract ? Contract-to-Hire Opportunity: Potential for full-time conversion based on performance.

Lead Enterprise Data Innovation with Snowflake

Key Responsibilities
  • Snowflake Architecture & Data Platform Leadership Own the design and architecture of Snowflake data models, warehouse configurations, SQL transformations, and secure access frameworks. Build scalable, maintainable, and reusable data solutions that support enterprise analytics and operational reporting. Define technical standards and best practices for data engineering and platform development.
  • Data Engineering & Integration Design and implement reliable ELT/ETL pipelines, APIs, and integrations connecting enterprise data sources with Snowflake and downstream applications. Establish data lineage, monitoring, and governance processes to ensure trusted and traceable data. Create reusable datasets and data services that support current business analytics and future AI-enabled initiatives.
  • Platform Modernization & Development Develop and enhance production-grade solutions using Snowflake, SQL, and Python. Modernize existing platforms and reduce technical debt while maintaining operational stability. Build and support automated workflows, data services, and scheduled processing jobs.
  • Data Security, Compliance & Governance Collaborate with Data Governance, Information Security, and Quality teams to implement privacy, auditability, validation, and access-control requirements. Support compliance initiatives, including environments that require GxP controls and system validation.
  • Production Support & Performance Optimization Optimize Snowflake performance, scalability, and cost efficiency. Implement monitoring, logging, alerting, incident response processes, and recovery procedures. Troubleshoot production issues and continuously improve platform reliability.
  • Technical Leadership Establish engineering standards for GitLab, code reviews, automated testing, CI/CD, documentation, and release management. Provide technical guidance and mentorship to engineering team members. Translate business requirements into technical roadmaps, architecture designs, delivery plans, and implementation estimates.
Required Qualifications
  • Education Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or a related field, or equivalent professional experience.
  • Experience 4+ years of experience in software engineering or data engineering.
  • Proven success designing, building, and supporting production Snowflake environments.
  • Experience leading technical workstreams and mentoring engineers.
  • Technical Expertise Advanced SQL and Snowflake capabilities, including: Data modeling Warehouse design Query optimization and profiling Performance tuning Secure data access patterns Strong Python development experience for: Data processing Enterprise integrations Scheduled workflows Automated testing Libraries such as pandas, requests, and pytest Hands-on experience with ETL/ELT pipelines, orchestration, data quality frameworks, lineage tracking, and production troubleshooting. Experience integrating enterprise systems through REST APIs, authentication protocols, and documented interfaces. Strong knowledge of Git/GitLab, CI/CD pipelines, automated testing, deployment controls, logging, monitoring, and alerting.
  • Additional Requirements Understanding of enterprise data security, privacy, traceability, compliance, and validation requirements in regulated environments.
  • Excellent communication skills with the ability to explain technical concepts and architecture decisions to both technical and non-technical stakeholders.
  • Experience collaborating with distributed and global teams.
Preferred Qualifications
  • Master's degree in Computer Science, Data Engineering, or a related technical discipline.
  • Experience with Snowpark, dbt, Apache Airflow, or similar data transformation and orchestration tools.
  • Expertise implementing role-based security, data masking, and secure data-sharing practices.
  • Experience supporting analytical applications or dashboards using R Shiny, Shiny for Python, or comparable technologies.
  • Experience with AWS, Docker, and cloud-native deployments.
  • Experience within regulated industries, including life sciences, healthcare, manufacturing, or other compliance-driven environments.
  • GitHub portfolio or technical project portfolio showcasing relevant work.
Why Join This Opportunity?
  • Lead architecture and engineering decisions for a high-impact enterprise data platform.
  • Work with modern technologies including Snowflake, Python, APIs, cloud platforms, and AI-enabled data solutions.
  • Influence data strategy while remaining deeply involved in hands-on development.
  • Mentor engineers and establish best practices across the data engineering lifecycle.
  • Opportunity to transition into a full-time leadership role based on performance.

SEO Keywords: Senior Snowflake Engineer, Snowflake Technical Lead, Data Engineering Lead, Cloud Data Architect, Snowflake Developer, Data Platform Engineer, ETL Engineer, Python Developer, SQL Engineer, Data Warehouse Architect, AWS Data Engineer, Airflow, dbt, Data Integration, Hybrid Jobs Boston, Technical Lead Data Engineering.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Integration / Application Engineer
Data Integration / Application Engineer

Apollopros • South San Francisco (CA)

Hybrid
USD 120,000 - 150,000
Lead Data Architect
Lead Data Architect

Motion Recruitment • United States

Hybrid
USD 140,000 - 190,000
Health, Dental, Vision
401K
Hybrid
+1
Senior Snowflake Architect: Lead Data Solutions
Senior Snowflake Architect: Lead Data Solutions

Compunnel Inc. • Alpharetta (GA)

Hybrid
USD 180,000 - 240,000
Senior Snowflake Developer
Senior Snowflake Developer

TekDallas • Boston (MA)

Hybrid
USD 130,000 - 185,000
Senior Snowflake Engineer
Senior Snowflake Engineer

Spyrosoft Ltd • United States

Remote
USD 120,000 - 180,000
Data Engineer (Snowflake)
Data Engineer (Snowflake)

Tek Ninjas • United States

Remote
USD 100,000 - 130,000
Senior Snowflake Data Engineer - Talent Pipeline
Senior Snowflake Data Engineer - Talent Pipeline

BlueCloud • United States

On-site
USD 150,000 - 210,000
Tech Lead / Senior Architect – Data Engineering
Tech Lead / Senior Architect – Data Engineering

Virtusa Corporation • United States

Remote
USD 180,000 - 240,000
Snowflake Architect
Snowflake Architect

Compunnel Inc. • Alpharetta (GA)

On-site
USD 180,000 - 240,000
Data Engineer (Snowflake) | Jobs in US
Data Engineer (Snowflake) | Jobs in US

DigitalXNode • United States

Remote
USD 140,000 - 190,000