
Senior Snowflake Engineer(Technical Lead — Contractor)
ICONMA · Boston, CA
Strong hiring record · median 11 days open
- First seen
- 17 November 2026
- Reposted
- Not since September 2026
All reasons
In its favour
- Posted today
- Still listed on the employer's own board
Our client, a Biotech company, is looking for a Senior Snowflake Engineer(Technical Lead -Contractor) for their Boston, MA/Hybrid location.
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.
Requirements
- 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.
- Bachelor’s or advanced degree in Computer Science, Software Engineering, Data Engineering, Information Systems or a related field, or equivalent practical 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.
Why Should You Apply?
- Health Benefits
- Referral Program
- Excellent growth and advancement opportunities
More jobs at ICONMA
All 186- Dynatrace AdministratorICONMA · Plano, TXtoday
- Product Owner (Digital Banking-Cards & Payments)ICONMA · Remote, AStoday
- GenAI Solution Developer (LLM, PostgreSQL, MySQL, MongoDB, DynamoDB).ICONMA · Charlotte, NCtoday
- Senior Health Intelligence ProgrammerICONMA · Remote, GAtoday
- Automation Test Engineer (TOSCA)ICONMA · Deerfield, ILtoday
Similar roles
- Data ScientistSterling Computers · North Sioux City, SD, United Statestoday
- Data Science Intern (2027 Start)Databricks · Mountain View, California · San Francisco, California · USD 54–60/hrtoday
- Staff Data Scientist - Trust and SafetyDatabricks · San Francisco, California · USD 192,000–260,000/yrtoday
- Staff Data Scientist - InfrastructureDatabricks · Mountain View, California · USD 192,000–260,000/yrtoday
- Staff Data ScientistDatabricks · San Francisco, California · USD 192,000–260,000/yrtoday
- Sr. Product Manager, Data EngineeringDatabricks · San Francisco, California · USD 115,400–204,200/yrtoday