Skip to main content
Kelly Services logo

Senior Snowflake Engineer - Technical Lead

Kelly Services

South San Francisco, CA · HybridContract / Full-timeSeen todayIn the employer's feed · checked in the last 2 days

See where you stand before you apply. No sign-up to start.

You apply on the posting's application page, with no Olive account needed.

Watch jobs like this.

Don't just apply. Show up ready.

Olive works from this exact posting.

At a glance

Compensation
No compensation found
Location
South San Francisco, CAHybrid
Schedule
Contract / Full-time
Work Authorization
Not specified

Olive focuses on jobs in the United States, including remote roles you can work from there.

Job overview

The Senior Snowflake Engineer / Technical Lead will lead technical design and development for Snowflake-based data and analytics solutions supporting resourcing and strategic decision-making. The role combines hands-on engineering with technical leadership, including guiding a Data Integration / Application Engineer and collaborating with product owners, business teams, and technology partners. The posting describes a 12-month job duration with possible extension and also refers to an 18-month contractor engagement.

Skills & qualifications

RequiredNice to have

Skills

Snowflake, requiredAdvanced SQL, requiredData Modeling, requiredWarehouse Design, requiredQuery Profiling, requiredPerformance Tuning, requiredSecure Data Access, requiredPython, requiredPandas, requiredRequests, requiredPytest, requiredELT/ETL Pipelines, requiredOrchestration, requiredData Quality Checks, requiredData Reconciliation, requiredData Lineage, requiredProduction Troubleshooting, requiredREST APIs, requiredSecure Authentication, requiredGit, requiredGitLab, requiredCode Review, requiredCI/CD, requiredAutomated Testing, requiredDeployment Controls, requiredObservability, requiredData Privacy, requiredInformation Security, requiredComputer System Validation, requiredTraceability, requiredCommunication, requiredSnowpark, nice to haveDbt, nice to haveAirflow, nice to haveRole-Based Access, nice to haveData Masking, nice to haveSecure Data Sharing, nice to haveR Shiny, nice to haveShiny for Python, nice to haveAWS, nice to have

Qualifications

Bachelor's or Equivalent Experience, required4+ Years Engineering Experience, requiredMaster's Degree, nice to have

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

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.

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.

How this job compares

Set against the 6,490 open Data Engineer jobs on Olive Jobs, counted November 18, 2026.

Pay
  • This postingNot listed
  • California median$140–229K/yr689 salary ranges
  • California median$70–82/hr31 hourly ranges
Openings
Olive Jobs lists 861 open Data Engineer jobs in California and 6,490 across the US. 8% of them nationwide are listed as remote or flexible.
Hiring the most in California
Experience
This posting asks for at least 4 years of experience; Data Engineer postings that state a minimum ask for 5 years at the median (5,745 postings).
Education
2,581 of the 6,490 open Data Engineer jobs (40%) ask for a bachelor's degree or higher.

Counted across the open, public US postings on Olive Jobs on November 18, 2026. Figures based on too few postings are left out.

Prepare for this role

You've read the whole posting — now see how you match it.