We use cookies. Find out more about it here. By continuing to browse this site you are agreeing to our use of cookies.
#alert
Back to search results
New

Senior Snowflake Engineer - Technical Lead

Spectraforce Technologies
United States, Massachusetts, Boston
Nov 17, 2026
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.

Applied = 0

(web-7dc44f465b-227nn)