Senior Snowflake Engineer - Technical Lead

Nesco Resource, LLC
Boston, MA, United States
1 day ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
4 years minimum
Working hours
Regular working hours

Tech stack

Airflow Amazon Web Services Data Analysis Audit Trail User Authentication Automation of Tests Software Code Optimization Profiling Code Review Cyber Security Information Systems Continuous Integration
+49 more
Data as a Services Data Architecture Data Validation Information Engineering Data Governance Data Integration Extract Transform Load (ETL) Data Masking Data Transformation Data Security Data Structures DevOps Github R (Programming Language) HP Systems Insight Manager Information Security Management Python (Programming Language) Octopus Deploy Operational Databases Performance Tuning Software Architecture Systems Development Life Cycle Role-Based Access Control Release Management Software Engineering SQL Databases System Testing Systems Integration Workflow Management Systems Data Logging Data Processing Enterprise Software Applications Snowflake Reliability of Systems Technical Debt Gitlab Git Fastapi Pandas Pytest Containerization Information Technology Data Lineage Star Schema Data Delivery Restful APIs Data Pipelines GXP Docker

Job description

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., 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.

Requirements

Technical Leadership, Technical Leadership, Communication Skills, People Management, Project/Program Management, Snowflake Schema, Data Analysis, Scalable System Development, Performance Tuning/Optimization, Software Engineering, The ideal candidate has strong Snowflake, SQL, Python, and data integration experience, along with the ability to lead technical initiatives and support production systems., * 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., * 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.

Benefits & conditions

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., 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…