*Senior Data Engineer (Contract to Hire role) *

Kellton - Charlotte, NC

Full-time - Senior

Remote - Charlotte, NC

About the position

The Senior Data Engineer role at Kellton Tech is a hands-on position focused on developing and maintaining data ingestion pipelines. This position is crucial for designing, building, and optimizing the data infrastructure to ensure data integrity and performance. The role requires expertise in Snowflake, advanced SQL, and Python, along with experience in AWS services and ETL processes.

Responsibilities

• Design, build, test, and implement scalable data pipelines using Python and SQL.
• Maintain and optimize the 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 architects to develop new pipelines and/or optimize existing ones.
• Maintain code via CI/CD processes as defined in the Azure DevOps platform.

Requirements

• 7+ years of experience in Data Engineering roles, focusing 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.

Nice-to-haves

• Experience with Fivetran and DBT is a plus.