Senior Snowflake Engineer - Technical Lead

Motion Recruitment

Boston (MA)

Hybrid

USD 140,000 - 190,000

Full time

4 days ago
Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Motion Recruitment seeks a Senior Snowflake Engineer / Technical Lead in Boston. You will design Snowflake data models, build production SQL/Python components, and guide a Data Integration / Application Engineer. The role combines hands-on engineering with technical leadership across data integration and governance.

You will collaborate with Product Owners and business teams, optimize performance and costs, and ensure secure, scalable data platforms in a hybrid work environment.

Qualifications

  • Education: Bachelor’s or advanced degree in Computer Science, Software Engineering, Data Engineering or related field, or equivalent practical experience.
  •  4+ years in software or data engineering with Snowflake.

Responsibilities

  • Own the technical design of Snowflake data models, SQL transformations, warehouse configuration and secure access.

Skills

Snowflake
SQL
Python
ELT/ETL
GxP compliance
CI/CD
GitLab
Data modeling
API design
Data governance

Education

Bachelor's degree in CS/Engineering/DS or equivalent
Advanced degree preferred

Tools

GitLab
Python tooling
Snowflake platform
Airflow or dbt (preferred)

Job description

Job Title: Senior Snowflake Engineer - Technical Lead

Job Location: Boston, MA, 02134 (Hybrid)

Job Duration: 12 Months with possible extension

The Opportunity

As a Senior Snowflake Engineer / Technical Lead, you will be the technical lead for BSOs 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)
  • Education: Bachelors 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 prioritisation.
  • 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
  • Masters 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

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

Spectraforce Technologies, Inc. • Boston (MA)

Hybrid
USD 130,000 - 180,000
Hybrid work model
Office in Boston
Senior Snowflake Engineer - Technical Lead
Senior Snowflake Engineer - Technical Lead

Sharp Decisions • Boston (MA)

On-site
USD 140,000 - 210,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
Senior Snowflake Developer
Senior Snowflake Developer

TekDallas • Boston (MA)

Hybrid
USD 130,000 - 185,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
Snowflake Architect
Snowflake Architect

Compunnel Inc. • Alpharetta (GA)

On-site
USD 180,000 - 240,000
Lead / Principal Snowflake Engineer
Lead / Principal Snowflake Engineer

Anblicks Inc. • Dallas (TX)

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

Spyrosoft Ltd • United States

Remote
USD 120,000 - 180,000