Bachelor's or advanced degree in Computer Science, Software Engineering, Data Engineering, or related field.
4+ years in software or data engineering with hands-on Snowflake experience.
Advanced SQL and Snowflake data modeling expertise.
Strong production-quality Python skills for data processing and automation.
Experience with ELT/ETL pipelines and data quality checks.
Familiarity with REST APIs and secure data integration.
Understanding of data privacy and GxP requirements.
Responsibilities
Own the technical design of Snowflake data models and secure data access.
Build and enhance production-grade SQL and Python components.
Design reliable ELT/ETL pipelines connecting enterprise data sources to Snowflake.
Develop reusable datasets for analytics and AI workflows.
Collaborate with governance teams on data privacy and compliance.
Optimize query performance and maintain production runbooks.
Translate business requirements into technical designs and delivery tasks.
Benefits
Four medical plans for you and your family.
Dental and orthodontia benefits.
Vision benefits.
Health Savings Account (HSA).
Flexible Spending Accounts for health and dependent care.
Voluntary life insurance and disability insurance.
401(k) plan with matching options.
Paid sick time leave.
Legal and identity protection plans.
Pre-tax commuter benefit.
529 College Saver Plan.
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. You will receive the following benefits:
Medical Insurance - Four medical plans to choose from for you and your family
Dental & Orthodontia Benefits
Vision Benefits
Health Savings Account (HSA)
Health and Dependent Care Flexible Spending Accounts
Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
Hospital Indemnity Insurance
401(k) including match with pre and post-tax options