*Sr. Data Engineer (Snowflake, DBT, and Fivetran exp is must) - W2 role

*Sr. Data Engineer (Snowflake, DBT, and Fivetran exp is must) - W2 role

Posted 1 week ago by Kellton

Apply
Negotiable
Undetermined
Remote
Remote
Apply
Airflow Amazon Simple Notification Service (SNS) Amazon Web Services (AWS) Apache Airflow Application Programming Interface (API) Automation AWS Lambda Azure DevOps Cloud Computing Cloud Technology Continuous Integration and Continuous Delivery Data Engineering Data Extraction Data Infrastructure Data Ingestion Data Integrity Data Quality Data Warehousing DevOps Information Technology Consulting Internet Of Things (IoT) Microsoft Azure Microsoft Word Mobile Devices Python (Programming Language) Query Optimisation Snowflake (Data Warehouse) Software Development SQL (Programming Language) Workflow Automation Workflows

Summary: Kellton Tech is seeking a Senior Data Engineer for a 6-month contract-to-hire position, focusing on developing data ingestion pipelines and maintaining data infrastructure. The ideal candidate will have strong expertise in Snowflake, SQL, and Python, along with experience in ETL/ELT processes and workflow automation using AWS tools. This role is essential for ensuring data integrity and optimizing performance within the company's data systems. The position is fully remote, allowing for flexibility in work arrangements.

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 architects to develop new pipelines and/or optimize existing ones.
  • Maintain code via CI/CD processes as defined in our Azure DevOps platform.

Key Skills:

  • 7+ 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 is a plus.

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Kellton Tech is a full-service software development company, offering end-to-end IT solutions, strategic technology consulting and product development services in Web, SMAC (Social, Mobile, Analytics, Cloud), ERP-BPM, and IoT space Our methodology of inventing infinite possibilities with technology helps us develop best in-class and cost effective solutions for our clients.

Currently Kellton Tech is looking for talented resources for one of our listed client. Below are the position details

Job Title: Sr. Data Engineer

Assignment Type: 6 month contract-to-hire

Location: Remote

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 is a plus.

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

  • 7+ 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 is a plus.

Apply: Interested candidates can apply with their detailed word formatted resume along with their contact information\availability to raj (dot) sekhar (at) kellton (dot) com Phone 703-5 9 2 .9.5.1.7

Thanks for all your time!

Apply
Similar Jobs
Loading data...