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 technology partners.
Key Responsibilities
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 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 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 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.