Senior Data Engineer

Job Title: Senior Data Engineer

Mandatory Skills: (DBT, Airflow, Cosmos, SQL, Apache Airflow, AWS Redshift, S3)

Experience: 510 Years

Location: Bangalore (Hybrid 3 Days from office)

Role Overview

We are looking for a Senior Data Engineer with strong expertise in DBT, SQL, Airflow, and Cosmos to design, build, and optimize scalable data pipelines. This role requires a mix of technical depth, data modelling expertise, and strong communication skills to collaborate effectively with cross-functional teams.

Key Responsibilities

Design, develop, and maintain scalable data pipelines using DBT, Airflow, and Cosmos.

Build and optimize complex SQL transformations for large-scale datasets.

Implement robust data models following best practices in analytics engineering.

Orchestrate workflows and ensure reliability, monitoring, and performance of pipelines.

Collaborate with data analysts, BI teams, and business stakeholders to translate requirements into data solutions.

Ensure data quality, governance, and documentation across data assets.

Troubleshoot and resolve data pipeline and performance issues.

Mentor junior data engineers and contribute to best practices and standards.

Required Skills

Strong hands-on experience with DBT (data modelling, testing, documentation).

Advanced SQL skills with performance tuning expertise.

Experience with Apache Airflow for orchestration.

Familiarity with Cosmos (or similar modern data orchestration frameworks).

Solid understanding of data warehousing concepts (star schema, dimensional modelling).

Experience working with cloud platforms, primarily with AWS Redshift, S3 etc.

Strong problem-solving and analytical skills.

Excellent communication and stakeholder management abilities.

Good to Have

Experience with BI tools such as Tableau or Power BI.

Exposure to data governance and data quality frameworks.

Knowledge of CI/CD practices in data engineering using GitHub.

Experience in Agile/Scrum environments.

Knowledge of Informatica Power Canter

Qualifications

Bachelors or masters degree in computer science, Engineering, or related field.

510 years of experience in data engineering or analytics engineering roles.