Senior Snowflake Engineer - Technical Lead

Sharp Decisions

Boston (MA)

On-site

USD 140,000 - 210,000

Full time

35 hours 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

BSO is seeking a Senior Snowflake Engineer / Technical Lead to steer Snowflake-based data and analytics initiatives for Octopus, guiding a Data Integration / Application Engineer and collaborating with Product Owners, business teams, and technology partners.

The role blends hands-on engineering with technical leadership over an 18-month contractor engagement, emphasizing scalable data architecture, governance, and reliable production systems.

Qualifications

  • Bachelor's degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or related field, or equivalent practical experience.
  • At least 4 years in software or data engineering with hands-on Snowflake experience and leadership of technical workstreams.
  • Proven ability to translate business requirements into architecture, estimates, plans, risks, and release dependencies.

Responsibilities

  • Own the technical design of Snowflake data models, SQL transformations, warehouse configuration, and secure data access for Octopus and related data products.
  • Build and improve production-grade SQL and Python components, data services, and automated jobs; modernize the platform with minimal disruption.
  • Design reliable ELT/ETL pipelines and REST APIs connecting enterprise data sources to Snowflake and downstream apps; ensure data contracts and lineage.

Skills

Snowflake
SQL
Python
Data engineering
APIs
CI/CD
Git/GitLab
Observability
Data governance
Communication

Education

Bachelor's degree in Computer Science or related field

Tools

dbt
Airflow
Snowpark
Docker
GitLab

Job description

As a Senior Snowflake Engineer / Technical Lead, you will be the technical lead for BSO's Snowflake-based data and analytics solutions, reporting to the Business Digital, Data & AI Infrastructure Lead. You will advance Octopus, the platform supporting resourcing and strategic decision-making across PDD, by designing and building robust data architecture, integrations, and scalable enhancements. This 18-month contractor engagement combines hands-on engineering with technical leadership, guiding a Data Integration / Application Engineer and collaborating with Product Owners, business teams, and technology partners.

Key Responsibilities
The Opportunity

As a Senior Snowflake Engineer / Technical Lead, you will be the technical lead for BSO's Snowflake-based data and analytics solutions, reporting to the Business Digital, Data & AI Infrastructure Lead. You will advance Octopus, the platform supporting resourcing and strategic decision-making across PDD, by designing and building robust data architecture, integrations, and scalable enhancements. This 18-month contractor engagement combines hands-on engineering with technical leadership, guiding a Data Integration / Application Engineer and collaborating with Product Owners, business teams, and technology partners.

Key Responsibilities
  • Snowflake Architecture: Own the technical design of Snowflake data models, SQL transformations, warehouse configuration, and secure data access for Octopus and related BSO data products. Design for scalability, maintainability, and reuse.
  • Platform Engineering: Build and improve production-grade SQL and Python components, data services, and automated jobs. Evaluate technical debt and modernize the existing Octopus platform without disrupting service.
  • Data Integration: Design reliable ELT/ETL pipelines and APIs that connect approved enterprise data sources to Snowflake and downstream applications, with clear data contracts, lineage, and monitoring.
  • Shared Data Foundation: Develop reusable, trusted datasets and interfaces that support resourcing, portfolio, and performance analytics, as well as future AI-enabled workflows across BSO.
  • GxP and Data Trust by Design: Work with Data Governance, Information Security, and Quality & Compliance on privacy, access controls, auditability, validation evidence, and relevant GxP requirements where applicable.
  • Performance and Operations: Optimize query performance and cost, establish monitoring and alerting, investigate incidents and defects, and maintain production runbooks and recovery procedures.
  • Technical Leadership: Set engineering standards for GitLab, code review, automated tests, CI/CD, documentation, and controlled releases. Guide and review the work of a Data Integration / Application Engineer.
  • Stakeholder Partnership: Translate business requirements into clear technical designs, estimates, and delivery tasks. Coordinate architecture, dependencies, and approvals with IT & Architecture, Data Governance, and business Product Owners.
Who You Are (Must Haves)

You are a pragmatic, hands-on technical leader who enjoys improving established enterprise data products. You combine deep Snowflake expertise with strong engineering judgement, a focus on reliability, and the ability to explain technical trade-offs to business colleagues.

  • Education: Bachelor's or advanced degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or a related field, or equivalent practical experience.
  • Experience: At least 4 years in software or data engineering, including substantial hands-on experience developing and supporting production Snowflake solutions and leading technical workstreams.
  • Technical Delivery: Experience translating business requirements into architecture, engineering estimates, implementation plans, technical risks, and release dependencies. Able to guide another engineer without owning portfolio prioritization.
  • Snowflake and SQL: Advanced SQL, Snowflake data modelling, warehouse design, query profiling, performance tuning, and secure data-access patterns.
  • Python: Strong production-quality Python for data processing, application integrations, scheduled workflows, and automated testing (for example, pandas, requests, and pytest).
  • Data Engineering: Hands-on experience with ELT/ETL pipelines, orchestration, data quality checks, reconciliation, data lineage, and troubleshooting of production data flows.
  • APIs and Integration: Experience integrating enterprise systems through REST APIs, secure authentication, and reliable, documented interfaces.
  • Engineering Practices: Git/GitLab, peer code reviews, CI/CD, automated testing, deployment controls, and observability (logging, metrics, and alerting).
  • Regulated Environments: Understanding of enterprise data privacy, information security, and the need for computer system validation and traceability where GxP requirements apply.
  • Communication: Explains architectural decisions and trade-offs clearly to technical and non-technical colleagues and works effectively across global teams.
Preferred Qualifications
  • Master's degree in Computer Science, Data Engineering, or another relevant technical discipline.
  • Snowpark, dbt, Airflow, or comparable data transformation and orchestration tools.
  • Hands-on experience implementing role-based access, data masking, and secure data sharing in cloud data platforms.
  • Experience supporting enterprise dashboards or applications, including R Shiny, Shiny for Python, or comparable analytical interfaces.
  • Experience with cloud platforms such as AWS and containerized deployments (Docker).
  • Experience in pharmaceutical R&D, resourcing or demand-planning platforms, or another regulated industry.
  • A GitHub profile or portfolio showing relevant work is an advantage.
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

DGN Technologies Inc • Boston (MA)

On-site
USD 120,000 - 160,000
Senior Snowflake Platform Architect & Tech Lead
Senior Snowflake Platform Architect & Tech Lead

Sharp Decisions • Boston (MA)

On-site
USD 140,000 - 210,000
Senior Snowflake Architect: Lead Data Solutions
Senior Snowflake Architect: Lead Data Solutions

Compunnel Inc. • Alpharetta (GA)

Hybrid
USD 180,000 - 240,000
Senior Snowflake Engineer - Technical Lead
Senior Snowflake Engineer - Technical Lead

Apollo Professional Solutions • South San Francisco (CA)

Hybrid
USD 152,000 - 234,000
Snowflake Architect
Snowflake Architect

Compunnel Inc. • Alpharetta (GA)

On-site
USD 180,000 - 240,000
Data Engineer III
Data Engineer III

Seminole Hard Rock Support Services • Florida

On-site
USD 130,000 - 190,000
Benefits package
Senior Snowflake Data Engineer - Talent Pipeline
Senior Snowflake Data Engineer - Talent Pipeline

BlueCloud • United States

On-site
USD 150,000 - 210,000
Lead / Principal Snowflake Engineer
Lead / Principal Snowflake Engineer

Anblicks Inc. • Dallas (TX)

On-site
USD 135,000 - 165,000
Senior Data Engineer
Senior Data Engineer

RxSense • Boston (MA)

On-site
USD 150,000 - 190,000
Snowflake Data Engineer
Snowflake Data Engineer

NewVision • United States

Remote
USD 140,000 - 200,000