Senior Data Engineer – Snowflake (Contract)

Work Location: 100% Remote
Employment Type: Contract
Experience Required: 8+ Years

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.