Loading, Please wait..!!
W2 role - : Senior Snowflake Engineer - Technical Lead
-
Posted on: Nov 17, 2026
-
Boston, Massachusetts
-
Onsite
-
Full-time
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for W2 role - : Senior Snowflake Engineer - Technical Lead roles in Massachusetts.
View Salary Guide →Find your match !
Job Title :
W2 role - : Senior Snowflake Engineer - Technical Lead
Job Type :
Full-Time
Job Location :
Boston Massachusetts United States
Remote :
No
Job Description :
Location: Boston, MA 02109 (Hybrid role; worker must be local to Boston, MA)
worker must be in office 2.5 days/week, 10 days/month
Duration: 12 months contract with Conversion to FTE possible, depending on performance
Starting in January
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 technology partners.
- 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.
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 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.
- 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 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.
Position Details
Posted:
Nov 17, 2026
Reference Number:
1841-10990
Employment:
Full-time
City:
Boston
Job Origin:
CIEPAL_ORGANIC_FEED
Share this job:
Please wait..!!

