Senior Data Engineer (immediate joiner)

Project Description:

We are seeking a highly experienced Senior Data Engineer to design, develop, and optimize enterprise-scale data platforms using modern cloud technologies. The role involves building robust ELT pipelines, scalable data models, and analytics-ready datasets leveraging Snowflake, Azure Data Factory (ADF), DBT, Python, and SQL. The ideal candidate will play a key role in enabling data-driven decision making by delivering high-quality, governed, and performant data solutions.

Responsibilities:

Key Responsibilities

• Design and develop scalable ELT pipelines using Snowflake, ADF, DBT, and Python.

• Build and maintain enterprise data models including 3NF, Star Schema, and Snowflake Schema.

• Optimize Snowflake performance through query tuning, clustering, micro-partitioning, and warehouse management.

• Develop reusable and modular data transformation frameworks using DBT (Jinja, Macros, Testing, Documentation).

• Automate data ingestion, transformation, and operational processes using Python, Pandas, and PySpark.

• Implement workflow orchestration using tools such as Apache Airflow, Prefect, or Dagster.

• Establish data quality, governance, monitoring, and CI/CD best practices.

• Collaborate with Data Analysts, Data Scientists, Product Owners, and Business Stakeholders to deliver trusted data products.

• Create and maintain technical documentation, deployment procedures, and operational runbooks.

Mandatory Skills Description:

Mandatory Skills

• Snowflake Data Warehouse

• Azure Data Factory (ADF)

• DBT

• Python

• Advanced SQL

• Data Modeling (3NF, Star Schema, Snowflake Schema)

• Apache Airflow / Prefect / Dagster

• Cloud Platforms (Azure preferred)

• Git and CI/CD

• Data Quality and Governance Frameworks

• Agile/Scrum Methodology