Data Engineer (Snowflake | SQL | Python | dbt)

Dreampath Services; Bengaluru; Remote; INR 900,000 - 1,500,000; Full time

Job summary

Dreampath Services is seeking an experienced Data Engineer to join remotely. You will design, develop, and maintain scalable data pipelines using Snowflake, SQL, Python, and dbt, and build analytics-ready data models for reporting.

You will create Tableau dashboards, ensure data quality, and collaborate with business and technical teams to deliver end-to-end analytics solutions, with a 2:00 PM–10:00 PM shift alignment in a remote setup.

Qualifications

• Strong hands-on experience with Snowflake, SQL, Python, and dbt.
• Experience designing and implementing ETL/ELT pipelines.
• Proficiency in data modeling and data warehousing concepts.
• Experience in query optimization and performance tuning.
• Hands-on experience in Tableau dashboard development and data visualization.
• Knowledge of Git and version control tools.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Work with Snowflake for data storage, transformation, and processing.
• Develop and optimize complex SQL queries for efficient data processing.
• Use Python for data processing, automation, and pipeline development.
• Build and maintain data transformation workflows using dbt.
• Perform data modeling, data warehousing, and performance optimization.
• Develop and maintain Tableau dashboards and reports for business analytics.
• Use Git for version control and collaborative development.
• Ensure data quality, accuracy, and consistency across data pipelines.
• Collaborate with business and technical teams to deliver analytics solutions.

Skills

ETL/ELT design

Data modeling

Data warehousing

Query optimization

Tableau data visualization

Git/version control

Analytical skills

Communication

Tools

Snowflake

SQL

Python

dbt

Tableau

Git

Job description

Experience: 4–8 Years

Work Mode: Remote

Working Hours: 2:00 PM – 10:00 PM

Job Summary

We are looking for an experienced Data Engineer with strong expertise in Snowflake, SQL, Python, and dbt to design, develop, and maintain scalable data pipelines and analytics solutions. The ideal candidate should have hands‑on experience in ETL/ELT development, data warehousing, data modeling, and Tableau dashboard development.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Work with Snowflake for data storage, transformation, and processing.
• Develop and optimize complex SQL queries for efficient data processing.
• Use Python for data processing, automation, and pipeline development.
• Build and maintain data transformation workflows using dbt.
• Perform data modeling, data warehousing, and performance optimization.
• Develop and maintain Tableau dashboards and reports for business analytics.
• Use Git for version control and collaborative development.
• Ensure data quality, accuracy, and consistency across data pipelines.
• Collaborate with business and technical teams to deliver analytics solutions.

Required Skills

• Strong hands‑on experience with Snowflake, SQL, Python, and dbt.
• Experience designing and implementing ETL/ELT pipelines.
• Proficiency in data modeling and data warehousing concepts.
• Experience in query optimization and performance tuning.
• Hands‑on experience in Tableau dashboard development and data visualization.
• Knowledge of Git and version control tools.
• Strong analytical, problem‑solving, and communication skills.

Candidate Profile

• 4–8 years of relevant experience in Data Engineering / Data Analytics.
• Strong practical knowledge of modern data engineering tools and technologies.
• Ability to work independently and collaborate with cross‑functional teams.
• Comfortable working in the 2 PM – 10 PM shift.