Snowflake Data Engineer (SnowPro Core/SnowPro Advanced Certifications required)

ROLIM Global Corporation is hiring a Snowflake Data Engineer for a Bio-Tech Project.

Title: Snowflake Data Engineer (SnowPro Core / SnowPro Advanced Certification Required)

Location: Plano, TX - Onsite

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.

Key Responsibilities

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

Qualifications

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