Snowflake Data Engineer

About the Role

This is a contract-based, remote role for a Snowflake Data Engineer based in the United States. The position is for a partner company, and all applications and next steps are managed by them. The role involves designing, developing, and optimizing cloud-based data solutions, building and maintaining data pipelines, integrating information from multiple enterprise sources, and developing efficient data models.

Key Responsibilities

• Cloud Data Warehouse Development: Develop, maintain, and optimize data warehouse solutions using Snowflake.
• Data Pipeline Engineering: Design, build, and maintain ETL/ELT pipelines to extract, transform, and load data into Snowflake from multiple enterprise source systems.
• SQL Development & Optimization: Write, test, and optimize complex SQL queries and data transformations.
• Data Integration: Integrate data from diverse sources into centralized data platforms.
• Data Modeling & Transformation: Develop and maintain data models, structured datasets, and analytical data layers.
• Python-Based Development: Use Python, Snowflake stored procedures, and user-defined functions for workflow automation and advanced data processing.
• Performance Monitoring & Troubleshooting: Identify and resolve data quality issues, pipeline failures, query bottlenecks, and warehouse performance challenges.
• Cloud Platform & Tool Integration: Work with cloud infrastructure, orchestration tools, and data transformation technologies.
• Security & Access Management: Support Snowflake security configurations, role-based access controls, and warehouse settings.
• Continuous Improvement: Apply engineering best practices to improve pipeline reliability, maintainability, and scalability.

Requirements & Tech Stack

• Snowflake Experience: Hands-on experience developing, implementing, or supporting data solutions on Snowflake.
• SQL Proficiency: Strong SQL skills for complex query development, data transformations, troubleshooting, and performance optimization.
• ETL/ELT Pipeline Development: Practical experience designing, developing, maintaining, or supporting ETL/ELT pipelines.
• Data Integration Skills: Experience connecting and consolidating information from multiple source systems.
• Data Warehousing & Modeling: Understanding of data warehouse architecture and data modeling principles.
• Troubleshooting & Performance Optimization: Ability to investigate data discrepancies, diagnose pipeline failures, and improve data workflow performance.
• Analytical & Problem-Solving Skills: Strong attention to detail and logical thinking.
• Collaboration & Communication: Ability to work effectively with technical stakeholders and communicate technical issues clearly.

Preferred Qualifications

• Python & Advanced Snowflake Capabilities: Familiarity with Python, Snowflake stored procedures, or user-defined functions is preferred.
• Data Integration Tools: Experience with Matillion or other data integration and orchestration platforms is an advantage.
• Cloud & Transformation Technologies: Familiarity with AWS, dbt, or IBM DataStage is desirable.
• Snowflake Administration & Security: Knowledge of role-based access controls, security configurations, and virtual warehouse management is beneficial.

Work Arrangement

• Must be able to work remotely from the United States.
• Contract-based employment arrangement.
• Candidates will be asked to provide current location and work authorization details.

Benefits

• Competitive Contract Rate: Indicative hourly compensation of $46–$56 per hour.
• Remote Work Flexibility.
• Contract-Based Opportunity.
• Exposure to Snowflake, SQL, ETL/ELT, data modeling, and cloud data platforms.
• Opportunities to work with complementary technologies such as Python, AWS, dbt, Matillion, and other integration tools.
• Technical growth in data pipeline optimization, cloud warehouse performance, data integration, and scalable data architecture.
• Collaborative environment with technical professionals.