Senior Data Engineer - Remote, ETL/DBT & Snowflake

AssureSoft Corporation; United States; Remote; USD 130,000 - 190,000; Full time

Benefits offered by this job

Great Place To Work certification

Long-term projects

English scholarships

English classes

State-of-the-art tools

Certifications

Recreation activities

Regulatory compliance

Job summary

AssureSoft is seeking a Senior Data Engineer to design, build, and optimize scalable data pipelines and ETL/ELT processes. You will implement data ingestion, transformation, and quality checks using Python, SQL, dbt, and Airbyte, with Snowflake data warehousing and MySQL sources.

Collaboration with engineers, analysts, and stakeholders is essential. The role emphasizes performance tuning, reliable data solutions, and cost-efficient pipeline improvements, with remote-friendly arrangements and

Qualifications

• Senior data engineering experience with a track record of delivering scalable pipelines.
• Proficient in Python for data processing, automation, and pipeline development.
• Advanced SQL skills and performance tuning.

Responsibilities

• Design, develop, test, and maintain scalable data pipelines and ETL/ELT processes.
• Build and optimize data transformation workflows using Python, SQL, and dbt.
• Develop and maintain data ingestion, synchronization, and integration pipelines using Airbyte.
• Design and optimize data models, transformations, and queries in Snowflake.
• Extract, transform, and integrate data from relational databases, including MySQL.
• Implement data quality checks, validation processes, error handling, and pipeline monitoring.
• Troubleshoot pipeline failures, perform root cause analysis, and implement sustainable solutions.
• Develop clean, reusable, maintainable, and well-documented code and SQL transformations.
• Collaborate with engineers, analysts, developers, and stakeholders to deliver reliable data solutions.
• Participate in technical estimation and development planning.
• Improve pipeline performance, scalability, reliability, and cost efficiency.

Skills

Python

SQL

Data pipelines

ETL/ELT

Troubleshooting

Tools

dbt

Airbyte

Snowflake

MySQL

Git

CI/CD

Docker

Job description

AssureSoft is seeking a Senior Data Engineer to design, build, and optimize scalable data pipelines and ETL/ELT processes. You will implement data ingestion, transformation, and quality checks using Python, SQL, dbt, and Airbyte, with Snowflake data warehousing and MySQL sources.

Collaboration with engineers, analysts, and stakeholders is essential. The role emphasizes performance tuning, reliable data solutions, and cost-efficient pipeline improvements, with remote-friendly arrangements and