Yabot Jobs
Motion Recruitment logo
Log in to apply

Motion Recruitment

Senior Snowflake Engineer - Technical Lead

South San Francisco, California, United States

Job at a glance

Workplace
On-site
Sector
Engineering & Technology
Posted
Nov 17, 2026
First found
Nov 17, 2026, 12:08 PM ET

What's your fit?

Score your resume against this job to see your fit, the gaps and the risks.

About the job

**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):

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: 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.** ****