Senior Snowflake Engineer - Technical Lead

Spectraforce Technologies, Inc.

Boston (MA)

Hybrid

USD 130,000 - 180,000

Full time

4 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Hybrid work model
Office in Boston

Job summary

Spectraforce Technologies, Inc. in Boston is seeking a Senior Snowflake Engineer to lead technical delivery in a hybrid, 12-month contract.

You will own Snowflake architecture, build production-grade data services, and drive data integration across enterprise sources. You will guide a Data Integration / Application Engineer, partner with Product Owners, IT, and Data Governance, and advance the Octopus platform to enable strategic decision-making.

Qualifications

  • Proven Snowflake data modeling and SQL optimization experience.
  • Experience building production data pipelines and ELT/ETL processes.
  • Ability to translate business needs into technical designs.

Responsibilities

  • Own Snowflake architecture and scalable data models.
  • Lead platform engineering with production-grade SQL/Python components.
  • Design reliable ELT/ETL pipelines and data integrations.
  • Collaborate with governance, security and compliance teams.

Skills

Snowflake
SQL
Python
ETL
Data integration
CI/CD
GitLab
APIs
AWS

Education

BS in CS

Tools

dbt
Airflow
Snowpark
Docker

Job description

Title: Senior Snowflake Engineer - Technical Lead
Duration: 12 months (Boston, MA 02134 (Hybrid - Starting in January, worker must be in office 2.5 days/week, 10 days/month)
Location: Boston, MA 02134 (Conversion to FTE possible, depending on performance)
Description:

This role is based in the Business Strategy & Operations (BSO) function, the strategic backbone and operational enabler for Product Development Data Sciences (PDD). BSO brings together Business Digital, Data & AI Infrastructure, Quality & Compliance, Resourcing & Metrics, Strategy & Operation and Employee Engagement to empower leaders and teams to deliver with focus, transparency and accountability. By connecting enterprise priorities with operational realities, BSO drives consistency, clarity and coordinated progress across PDD and the broader development organization. BSO is implementing an ambitious AI strategy: moving from producing operational information by hand to steering with it. This means AI agents that run recurring processes under human oversight, agentified dashboards that surface insights, alerts and scenarios, automated data flows across business systems, and AI assistants that turn data into decisions - all built on a shared, trusted and compliant foundation and reused across BSO. You will be part of BSO's Business Digital, Data & AI Infrastructure sub-function, which designs, builds and runs the data, digital and AI capabilities used across BSO. You will work closely with business teams, IT & Architecture, Data Governance, Information Security and Quality & Compliance.

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 Client's 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: Optimise 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 containerised 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

Senior Snowflake Engineer - Technical Lead
Senior Snowflake Engineer - Technical Lead

Sharp Decisions • Boston (MA)

On-site
USD 140,000 - 210,000
Senior Snowflake Engineer - Technical Lead
Senior Snowflake Engineer - Technical Lead

Motion Recruitment • Boston (MA)

Hybrid
USD 140,000 - 190,000
Data Integration / Application Engineer
Data Integration / Application Engineer

DGN Technologies Inc • Boston (MA)

On-site
USD 120,000 - 160,000
Senior Snowflake Engineer - Technical Lead
Senior Snowflake Engineer - Technical Lead

Apollo Professional Solutions • South San Francisco (CA)

Hybrid
USD 152,000 - 234,000
Tech Lead / Senior Architect – Data Engineering
Tech Lead / Senior Architect – Data Engineering

Virtusa Corporation • United States

Remote
USD 180,000 - 240,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 Platform Architect & Tech Lead
Senior Snowflake Platform Architect & Tech Lead

Sharp Decisions • Boston (MA)

On-site
USD 140,000 - 210,000
Sr Data Engineer
Sr Data Engineer

Cox Automotive • Atlanta (GA)

On-site
USD 140,000 - 190,000
Senior Data Engineer
Senior Data Engineer

RxSense • Boston (MA)

On-site
USD 150,000 - 190,000
Senior Snowflake Data Engineer - Talent Pipeline
Senior Snowflake Data Engineer - Talent Pipeline

BlueCloud • United States

On-site
USD 150,000 - 210,000