Job Title: Senior Data Engineer
Experience: 7+ Years
Work Mode: Remote
Shift Timing: 1/2 PM – 10/11 PM IST
Employment Type: Contract
Role Overview
We are looking for a highly skilled
Senior Data Engineer with strong expertise in
SQL, Python, and modern data stack tools to design and build scalable, end-to-end data pipelines. The ideal candidate should have hands-on experience with
Snowflake, dbt, and cloud-based data platforms, along with a deep understanding of data warehousing, orchestration, and performance optimization.
Key Responsibilities Data Engineering & Pipeline Development
- Design, build, and maintain end-to-end data pipelines (ingestion → transformation → loading)
- Develop scalable ETL/ELT workflows using Python and SQL
- Implement incremental loads, CDC, and data quality checks
- Handle pipeline failures, debugging, and performance optimization
Data Warehouse & Snowflake
- Work extensively with Snowflake for data ingestion, transformation, and analytics
- Implement Snowflake features such as tasks, streams, Snowpipe, and COPY INTO
- Optimize query performance, storage, and compute usage
Modern Data Stack & Orchestration
- Build and manage transformations using dbt (models, testing, and documentation)
- Work with Hevo Data for ingestion pipelines
- Implement orchestration workflows using Apache Airflow or similar tools
- Design and manage DAGs, dependencies, and scheduling strategies
Cloud & Data Platforms
- Work with AWS services such as S3, Glue, EMR, and CloudWatch
- Understand and apply use cases for Glue vs EMR
- Monitor pipelines using logging and observability tools
Collaboration & Tools
- Collaborate with cross-functional teams including analytics, product, and engineering
- Work in Agile environments using tools like Jira, Bitbucket, Slack, and Microsoft Teams
Required Skills & Experience
- 7+ years of experience in Data Engineering
- Strong proficiency in SQL (joins, window functions, optimization)
- Strong programming skills in Python for data processing and ETL pipelines
- Hands-on experience with Snowflake or similar data warehouse
- Experience building end-to-end data pipelines
- Strong understanding of data warehousing concepts and performance tuning
- Experience with dbt for data transformation and modeling
- Hands-on experience with Apache Airflow (or similar orchestration tools)
- Experience with incremental loads, CDC, and data quality frameworks
Nice to Have
- Experience with DynamoDB
- Exposure to additional AWS services
- Experience with Apache Iceberg / Delta Lake or data lake concepts
- Familiarity with Rocket (Analytical Engine)
Skills: optimization,snowflake,pipelines,sql,dbt,python
