Snowflake Data Engineer

The Senior Data Engineer - Snowflake is a hands-on contract role responsible for designing, building, optimizing, and operating complex cloud data pipelines and data products on Snowflake. This role supports scalable, secure, and high-performing enterprise data capabilities in a fast-paced biotechnology environment. The engineer will collaborate with architects, technology teams, and business stakeholders to translate requirements into production-ready solutions., · Snowflake Data Engineering

o Design, develop, test, deploy, and support batch, incremental, and near-real-time pipelines.

o Build reusable ingestion and transformation frameworks using Streams, Tasks, Snowpipe, Snowpipe Streaming, and Snowpark.

o Implement robust error handling, monitoring, alerting, and recovery patterns.

· Performance & Cost Optimization

o Optimize SQL workloads, warehouse sizing, clustering, and query performance.

o Monitor reliability, concurrency, data freshness, and Snowflake credit consumption.

o Troubleshoot data, orchestration, and performance issues.

· Architecture & Standards

o Contribute to solution architecture, data modeling, and design reviews.

o Implement engineering standards for CI/CD, source control, testing, and deployment automation.

o Ensure compliance with enterprise security, privacy, governance, and RBAC requirements.

· SQL & Python Development

o Write advanced SQL for transformations, data quality, and performance tuning.

o Develop Python and Snowpark components for orchestration, automation, and operational tooling.

o Maintain documentation, runbooks, and knowledge-transfer materials.

· Snowflake Cortex AI

o Evaluate and implement Snowflake Cortex AI functions and governed AI services.

o Partner with stakeholders to assess AI/ML use cases, data readiness, and productionization.

o Stay current with Snowflake releases and recommend adoption of new features.

· Cross-Functional Collaboration

o Work with architects, analysts, data scientists, and business partners.

o Provide technical leadership via code reviews, design discussions, and mentoring.

o Communicate delivery status, risks, and tradeoffs clearly to stakeholders.

· Required:

o 8+ years of cloud data engineering experience.

o 5+ years of Snowflake engineering and platform development.

o Expert-level SQL and advanced Python.

o Strong knowledge of CI/CD, orchestration, monitoring, and operational support.

o Experience with Snowflake security, governance, RBAC, and cost optimization.

o Bachelor’s degree in Computer Science, Engineering, or related field.

· Preferred:

o SnowPro Core certification (Advanced Data Engineer certification highly desirable).

o Experience in healthcare, life sciences, or regulated environments.

o Architecture and solution design experience.

o Exposure to Snowflake Cortex AI and AI-enabled data solutions.

o Knowledge of ML concepts, feature pipelines, and MLOps.