Data Engineer – Snowflake & DBT

Kenexai; Pune District; On-site; INR 1,000,000 - 1,500,000; Full time

Benefits offered by this job

Flexible working hours

5-day work week

Comprehensive medical insurance

Performance-based bonuses

Annual company trip

Continuous learning opportunities

Fun Fridays and festive celebrations

Job summary

A growing data solutions company in Pune is seeking a talented Data Engineer to design and maintain robust data pipelines. The ideal candidate will have over 4 years of experience in Data Engineering, expertise in Snowflake and DBT Core, and proficiency in SQL and Python. The role offers competitive base compensation with performance-based bonuses, flexible working hours, and opportunities for continuous learning in a collaborative environment.

Qualifications

• 4+ years of experience in Data Engineering with strong expertise in Snowflake and DBT Core.
• Proficient in SQL and Python for data transformation, scripting, and analysis.
• Hands‑on experience with AWS ecosystem including S3, Glue, and Redshift.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Snowflake and DBT Core.
• Build scalable and modular data models in DBT, following best practices.
• Work with AWS Data Services to ingest and transform data.
• Orchestrate workflows and data pipelines using Airflow.
• Deploy and manage pipelines in containerized environments.
• Integrate streaming data using Kafka for real‑time processing.
• Participate in CI/CD pipelines using Terraform.

Skills

Snowflake

DBT Core

SQL

Python

AWS ecosystem (S3, Glue, Redshift)

Tools

Docker

Kubernetes

Airflow

Kafka

Terraform

Job description

Kenexai delivers smart, data-driven solutions that empower businesses across industries. Our mission is to combine deep, domain-specific expertise with cutting‑edge technology to drive meaningful impact.
With a trusted team, consistent quality, and a growing global presence, we remain committed to delivering excellence while staying true to our core values: innovation, integrity, and client success.
Be part of a team that’s not just building solutions, but shaping the future with intelligence.

Experience: 4 years

Job Type : Full Time

Roles and Responsibility :

We are seeking a talented and motivated Data Engineer with hands‑on experience in Snowflake and DBT Core to join our growing data team. The ideal candidate will play a critical role in designing, building, and maintaining robust, scalable, and high‑performance data pipelines that support analytics, reporting, and business intelligence initiatives across the organization. This role involves working closely with data analysts, data scientists, and engineering teams to ensure data is accurate, reliable, and readily available.

• Design, develop, and maintain end‑to‑end ETL/ELT pipelines using Snowflake and DBT Core.
• Build modular, scalable, and reusable data models in DBT following best practices, including version control, testing, and documentation.
• Work with AWS Data Services (S3, Glue, Redshift) to ingest, transform, and store large volumes of structured and unstructured data.
• Collaborate with teams to implement data validation and testing frameworks to ensure high‑quality, trustworthy data.
• Orchestrate complex workflows and data pipelines using Airflow / Astro, ensuring efficient scheduling and monitoring.
• Deploy and manage pipelines in containerized environments using Docker and Kubernetes for scalability and reliability.
• Integrate streaming data using Kafka for real‑time processing and analytics.
• Participate in CI/CD pipelines using Terraform to automate deployment, versioning, and environment management.
• Monitor and troubleshoot data pipelines to ensure performance, reliability, and availability, proactively addressing potential issues.
• Collaborate with cross‑functional teams to understand business requirements and translate them into efficient data solutions.
• Stay updated with emerging technologies and industry best practices in data engineering, cloud platforms, and modern data architecture.

Skill Requirement:

• 4+ years of experience in Data Engineering with strong expertise in Snowflake and DBT Core.
• Proficient in SQL and Python for data transformation, scripting, and analysis.
• Hands‑on experience with AWS ecosystem including S3, Glue, and Redshift.
• Ability to work effectively in a fast-paced, collaborative environment with multiple stakeholders.

Why Kenexai ?

• Be part of building something from the ground up in a high‑growth, high‑impact domain.
• Work alongside passionate experts in AI, data, and industry consulting.
• Competitive base + uncapped commission structure tied directly to performance.
• Remote‑first flexibility with real ownership and career growth potential.

Benefits

• Employees are entitled to flexible working hours to support work‑life balance.
• The company operates on a 5‑day work week.
• A healthy, inclusive, and collaborative work environment is maintained.
• The company organizes Fun Fridays and festive celebrations to foster team spirit.
• Employees have access to opportunities for continuous learning and career growth.
• An annual company trip is organized for team building and relaxation.
• Comprehensive medical insurance benefits are provided to employees.
• Performance‑based bonuses and annual salary revisions are offered.
• A hybrid working model is available, allowing a mix of in‑office and remote work as per company policy.