Sr Snowflake Data Engineer (DBT/Fivetran) - Remote - 3-6 Months CTH - W2 Only
Posted 2 days ago by 1761378583
Negotiable
Outside
Remote
USA
Summary: The role of Senior Snowflake Data Engineer involves developing and maintaining data ingestion pipelines, focusing on scalable solutions and data integrity. The position requires expertise in Snowflake, SQL, and Python, along with experience in AWS services and workflow automation. The engineer will collaborate with other team members to optimize data processes and ensure high performance of the data infrastructure. This is a remote position with a contract-to-hire duration of 3-6 months.
Key Responsibilities:
- Design, build, test, and implement scalable data pipelines using Python and SQL.
- Maintain and optimize our Snowflake data warehouse's performance, including data ingestion and query optimization.
- Extract data from APIs using Python and AWS Lambda and automate workflows with AWS Airflow.
- Perform analysis and critical thinking to troubleshoot data-related issues and implement checks/scripts to enhance data quality.
- Collaborate with other data engineers and architect to develop new pipelines and/or optimize existing ones.
- Maintain code via CI/CD processes as defined in our Azure DevOps platform.
Key Skills:
- 10+ years of experience in Data Engineering roles, with a focus on building and implementing scalable data pipelines for data ingestion.
- Expertise in Snowflake, including data ingestion and performance optimization.
- Strong SQL skills for writing efficient queries and optimizing existing ones.
- Proficiency in Python for data extraction from APIs using AWS Lambda, Glue, etc.
- Experience with AWS services such as Lambda, Airflow, Glue, S3, SNS, etc.
- Highly self-motivated and detail-oriented with strong communication skills.
- Familiarity with ETL/ELT processes.
- Experience with Fivetran and DBT.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Sr Snowflake Data Engineer
Remote
3-6 Months CTH
Job Summary
We are looking for a hands-on Senior Data Engineer with expertise in developing data ingestion pipelines. This role is crucial in designing, building, and maintaining our data infrastructure, focusing on creating scalable pipelines, ensuring data integrity, and optimizing performance.
Key skills include strong Snowflake expertise, advanced SQL proficiency, data extraction from APIs using Python and AWS Lambda, and experience with ETL/ELT processes. Workflow automation using AWS Airflow is essential, and experience with Fivetran and DBT.
Job Responsibilities
- Design, build, test, and implement scalable data pipelines using Python and SQL.
- Maintain and optimize our Snowflake data warehouse s performance, including data ingestion and query optimization.
- Extract data from APIs using Python and AWS Lambda and automate workflows with AWS Airflow.
- Perform analysis and critical thinking to troubleshoot data-related issues and implement checks/scripts to enhance data quality.
- Collaborate with other data engineers and architect to develop new pipelines and/or optimize existing ones.
- Maintain code via CI/CD processes as defined in our Azure DevOps platform.
Job Qualifications
- 10+ years of experience in Data Engineering roles, with a focus on building and implementing scalable data pipelines for data ingestion.
- Expertise in Snowflake, including data ingestion and performance optimization.
- Strong SQL skills for writing efficient queries and optimizing existing ones.
- Proficiency in Python for data extraction from APIs using AWS Lambda, Glue, etc.
- Experience with AWS services such as Lambda, Airflow, Glue, S3, SNS, etc.
- Highly self-motivated and detail-oriented with strong communication skills.
- Familiarity with ETL/ELT processes.
- Experience with Fivetran and DBT