Quick overview
Job description
Pay rate- $37.61- up to $68.87/h for Visa Independent candidate
Description:
Hybrid role; worker must be local to Boston: 60 Western Ave, Suite 9100 9th Floor Boston, MA
Starting in January, worker must be in office 2.5 days/week, 10 days/month
Conversion to FTE possible, depending on performance
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 Roche 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: 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.
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 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.
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- ME

Business Intelligence AnalystRecently posted Auto Apply
Monster Energy · USA - Corona · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLMicrosoft ExcelGreenhouse+4Technology$72k/yr - LI

Senior Software Engineer, LifecycleRecently posted Auto Apply
Life360 · Remote · Remote · Posted 19 Nov 2026 🇺🇸
OnboardingGitAWS+8Technology$148k - $216k/yr - NR

Software Engineer II - Query GatewayRecently posted Auto Apply
New Relic · Portland · Hybrid · Posted 19 Nov 2026 🇺🇸
DockerGCPAWS+8Technology$126k - $158k/yr - LE

Technical Support RepresentativeRecently posted Auto Apply
LG Electronics · Huntsville · Hybrid · Posted 19 Nov 2026 🇺🇸
Microsoft ExcelMicrosoft OfficeMicrosoft PowerPoint+5Technology$55k - $60k/yr - MI

Senior Security EngineerRecently posted Auto Apply
Mixpanel · San Francisco · Hybrid · Posted 19 Nov 2026 🇺🇸
GCPGitAWS+16Technology$230k - $300k/yr - ME

Quality Assurance AnalystRecently posted Auto Apply
Monster Energy · USA - Corona · Hybrid · Posted 19 Nov 2026 🇺🇸
ScrumCRMConfluence+8Technology$86.3k/yr - LA
Senior Cyber Security Engineer - Identity and Device Management, & Networking SecurityRecently posted Auto Apply
Latitude AI · Pittsburgh · Hybrid · Posted 19 Nov 2026 🇺🇸
RoboticsAnsibleBash+11Technology$160k - $240k/yr - LA

Applications Security EngineerRecently posted Auto Apply
Ladder · United States - Remote · Remote · Posted 19 Nov 2026 🇺🇸
DockerGCPBigQuery+11Technology$109k - $144k/yr - JS

Hardware Engineer (FPGA/ASIC) Auto Apply
Jane Street · New York · Hybrid · Posted 3 Nov 2026 🇺🇸
FPGAVHDLVerilogTechnologySalary not listed - KH

Senior Security Engineer, Product SecurityRecently posted Auto Apply
Komodo Health · United States · Hybrid · Posted 19 Nov 2026 🇺🇸
GCPRustGit+11Technology$200k/yr - FI

Senior Forward Deployed Data ScientistRecently posted Auto Apply
Fin · Chicago · Hybrid · Posted 19 Nov 2026 🇺🇸
SQLCRMCustomer Success+5Technology$185k - $205k/yr - FI

Technical Support SpecialistRecently posted Auto Apply
Fin · Chicago · Hybrid · Posted 19 Nov 2026 🇺🇸
Generative AIRESTSlackTechnology$62k - $74k/yr
