
Senior Snowflake Engineer - Technical Lead
Nesco Resource · Boston, MA · Hybrid
Strong hiring record · median 7 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
Senior Snowflake Engineer / Technical Lead
Location
Must be local to Boston, MA
Work Arrangement
Hybrid – Candidates must be local to Boston, MA
Contract Duration
18 months
Schedule
Beginning in January, onsite attendance is required approximately 2.5 days per week (10 days per month).
Conversion Opportunity
Potential conversion to a full-time employee based on performance and business needs.
The position requires someone who can lead technical decisions while remaining actively involved in development, communicate effectively with business stakeholders, and guide another engineer.
This is not a traditional project management or people management position. The primary focus is hands-on Snowflake engineering, data architecture, platform reliability, and technical leadership.
Position Overview
We are seeking an experienced Senior Snowflake Engineer / Technical Lead to lead the design, development, and enhancement of Snowflake-based data and analytics solutions.
This role will support Octopus. The selected candidate will be responsible for developing scalable data architectures, improving existing integrations, optimizing platform performance, and ensuring reliable data delivery.
This is a hands-on technical leadership position that combines software and data engineering with architectural oversight. The individual will guide a Data Integration / Application Engineer and collaborate with Product Owners, business stakeholders, and technology teams.
The ideal candidate has strong Snowflake, SQL, Python, and data integration experience, along with the ability to lead technical initiatives and support production systems.
Key Responsibilities
Snowflake Architecture & Development
- Design, develop, and maintain Snowflake data models, SQL transformations, and warehouse configurations.
- Establish secure data access and scalable architecture for enterprise data solutions.
- Optimize Snowflake performance, reliability, and cost efficiency.
- Develop reusable data structures that support analytics and reporting.
Data Engineering & Integration
- Build and maintain production-level SQL and Python applications, automated jobs, and data services.
- Design and implement reliable ETL/ELT pipelines connecting enterprise systems to Snowflake.
- Develop and maintain REST API integrations with secure authentication.
- Establish data quality checks, reconciliation processes, monitoring, and data lineage.
- Troubleshoot production data pipelines and resolve integration issues.
Platform Optimization & Support
- Enhance and modernize the existing Octopus platform while maintaining business continuity.
- Identify technical debt and recommend improvements to existing architecture and processes.
- Monitor platform performance, investigate incidents, and resolve defects.
- Maintain technical documentation, operational procedures, and recovery plans.
Data Governance, Security & Compliance
- Collaborate with Data Governance, Information Security, and Quality & Compliance teams.
- Implement appropriate data privacy, security, and access controls.
- Support auditability, validation documentation, and traceability.
- Ensure solutions align with applicable GxP and regulated industry requirements.
Technical Leadership & Engineering Standards
- Provide technical guidance and code reviews for a Data Integration / Application Engineer.
- Establish engineering standards for GitLab, CI/CD, automated testing, and deployment processes.
- Oversee technical designs, implementation plans, and release readiness.
- Promote consistent coding practices, documentation, and system reliability.
Stakeholder Collaboration
- Partner with Product Owners and business stakeholders to understand technical and business requirements.
- Translate business needs into technical designs, estimates, and implementation plans.
- Communicate technical risks, dependencies, and architectural decisions.
- Coordinate with IT, Architecture, Data Governance, and global technology teams.
Required Qualifications
Education & Experience
- Bachelor's degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or a related field, or equivalent practical experience.
- Minimum of 4 years of professional experience in software engineering or data engineering.
- Strong hands-on experience developing, implementing, and supporting production Snowflake solutions.
- Experience leading technical workstreams and providing guidance to other engineers.
Technical Requirements
Snowflake & SQL
- Advanced SQL development and optimization.
- Strong Snowflake architecture, data modeling, and warehouse design experience.
- Experience with query profiling, performance tuning, and secure data access.
Python Development
- Strong hands-on Python programming experience in production environments.
- Experience developing data processing solutions, integrations, and automated workflows.
- Familiarity with Python libraries and testing frameworks such as pandas, requests, and pytest.
Data Engineering
- Experience designing, building, and maintaining ETL/ELT pipelines.
- Knowledge of workflow orchestration, data quality validation, reconciliation, and data lineage.
- Ability to troubleshoot and support production data pipelines.
API Integration
- Experience integrating enterprise applications using REST APIs.
- Knowledge of secure authentication and reliable system-to-system integrations.
DevOps & Engineering Practices
- Hands-on experience with Git/GitLab, code reviews, and CI/CD pipelines.
- Experience with automated testing, controlled deployments, and release management.
- Familiarity with application monitoring, logging, metrics, and alerting.
Technical Leadership & Communication
- Ability to translate business requirements into technical architecture, estimates, and implementation plans.
- Experience identifying technical risks and managing engineering dependencies.
- Strong communication skills with technical and non-technical stakeholders.
- Ability to collaborate across global teams and provide technical direction.
Regulatory & Compliance Knowledge
- Understanding of enterprise data privacy and information security practices.
- Familiarity with computer system validation, documentation, and traceability in environments subject to GxP requirements.
Preferred Qualifications
- Master's degree in Computer Science, Data Engineering, or a related technical discipline.
- Experience with Snowpark, dbt, Apache Airflow, or similar data transformation and orchestration tools.
- Knowledge of role-based access control (RBAC), data masking, and secure data sharing.
- Experience supporting enterprise dashboards or analytical applications, including R Shiny or Shiny for Python.
- Familiarity with AWS and containerization technologies such as Docker.
- Previous experience in pharmaceutical R&D, resource planning, demand planning, or another regulated industry.
- GitHub portfolio demonstrating relevant engineering projects.
Nesco Resource offers a comprehensive benefits package for our associates, which includes a MEC (Minimum Essential Coverage) plan that encompasses Medical, Vision, Dental, 401K, and EAP (Employee Assistance Program) services.
Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
More jobs at Nesco Resource
All 30- Technical Program ManagerNesco Resource · Atlanta, GAtoday
- CNC ProgrammerNesco Resource · Streetsboro, OH · USD 25–30/hrtoday
- CNC Programmer - 1st shiftNesco Resource · Bay Shore, NY · USD 34–40/hrtoday
- Desktop Support/PC EngineerNesco Resource · Melville, NYyesterday
- Network Engineer (Active Secret Clearance)Nesco Resource · Courtland, AL3d ago
Similar roles
- Lead Data Engineer (Hybrid, office is based in Austin, Texas)CFC · TX, United Statestoday
- Global Research – Agentic AI & Data Science Lead – AssociateChase- · New York, NY, United States · USD 200,000–285,000today
- Manager - Data AnalyticsAmerican Express · New York, NY, United States · Phoenix, AZ, United States · USD 103,750–174,750/yrtoday
- Data EngineerPlayStation Global · United States, Austin, TXtoday
- Analyst I, Business IntelligenceWM · Windsor, CT, United States · USD 69,300–94,875/yrtoday
- Business/ Data AnalystPyramid Consulting · Hartford, CT · USD 50–87/hrtoday