Senior Data Engineer - Snowflake

Job Overview

We are seeking a highly experienced Senior Data Engineer specializing in Snowflake for a fully remote contract opportunity. The ideal candidate will have strong hands-on expertise in Snowflake, advanced SQL, Python, and enterprise-scale cloud data engineering.

The candidate will be responsible for designing, developing, optimizing, and supporting scalable, secure, and high-performing data pipelines and data products.

Key Responsibilities

• Design, develop, test, deploy, and maintain complex batch, incremental, and near-real-time data pipelines using Snowflake.
• Build reusable, metadata-driven data ingestion and transformation frameworks.
• Work with Snowflake Dynamic Tables, Streams, Tasks, Snowpipe, Snowpark, and secure data sharing.
• Develop complex SQL queries and optimize query performance, warehouse utilization, and Snowflake costs.
• Build Python and Snowpark solutions for data processing, automation, testing, and operational support.
• Implement data quality checks, reconciliation, error handling, monitoring, alerting, and recovery mechanisms.
• Contribute to data modeling, solution architecture, technical design reviews, and engineering standards.
• Implement CI/CD pipelines, version control, automated testing, and deployment automation.
• Ensure data security, privacy, governance, role-based access control, and audit compliance.
• Evaluate Snowflake Cortex AI capabilities and support governed AI/ML use cases.
• Collaborate with architects, analysts, data scientists, and engineering teams to deliver production-ready solutions.
• Conduct code reviews, troubleshoot production issues, document solutions, and provide technical guidance.

Required Qualifications

• 8+ years of hands-on experience developing enterprise solutions on cloud data platforms.
• 5+ years of hands-on Snowflake data engineering experience.
• Expert-level SQL skills, including complex transformations, data modeling, performance tuning, and troubleshooting.
• Advanced Python development skills for production data engineering and automation.
• Strong experience building complex, production-grade data pipelines and transformation frameworks.
• Knowledge of ETL/ELT, orchestration, CI/CD, source control, automated testing, monitoring, and production support.
• Experience with Snowflake security, governance, RBAC, data sharing, and performance/cost optimization.
• Ability to work independently and deliver results in a fast-paced environment.
• Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent practical experience.

Preferred Qualifications

• SnowPro Core certification; SnowPro Advanced: Data Engineer certification is a plus.
• Experience in healthcare, life sciences, biotechnology, pharmaceutical, or other regulated industries.
• Experience with Snowflake Cortex AI and governed AI-enabled data solutions.
• Knowledge of machine learning, feature pipelines, MLOps, or model deployment.
• Experience in solution architecture, technical design reviews, and data modeling.

Additional Information

• Fully remote contract opportunity.
• Strong emphasis on hands-on engineering, technical ownership, and independent delivery.