Job Description: Big Data Engineer – Analytics Track

We are looking for an experienced Big Data Engineer – Analytics Track to build and maintain enterprise-scale analytics data products and reporting solutions. The role will focus on developing scalable data transformation pipelines using DBT, designing dimensional data models, enabling self-service analytics, and partnering with business stakeholders across Supply Chain, Finance, Sales, Customer, and Operations.

The ideal candidate will bring strong expertise in SQL, DBT, data warehousing, performance optimisation, and analytics engineering practices, with a focus on delivering reliable, production-grade data assets.
Technical Skills
• Solid hands-on experience with DBT (Data Build Tool)
• Expert-level SQL development
• Experience with Spark SQL, Trino, or Presto
• Strong understanding of data warehousing concepts
• Experience with dimensional modelling, including Star and Snowflake schemas
• Airflow workflow orchestration
• Git/Bitbucket version control
• Big Data Query performance tuning and optimisation




• Big Data architecture and implementation
• Data quality and reconciliation frameworks
• Database Technologies
• Oracle
• Hive
• Spark
• BI & Visualisation
• Metabase
• Tableau
• Power BI or equivalent BI platforms
•
• Key Responsibilities

Analytics Engineering & Data Transformation
• Design, develop, and maintain scalable DBT models and data pipelines.
• Apply Medallion and Data Mesh architecture principles.
• Build incremental and full-load transformation frameworks using DBT.
• Develop reusable macros, tests, snapshots, and documentation.
• Implement automated validation and reconciliation checks to ensure data quality.
• Optimise DBT models for performance, scalability, and cost efficiency.
• Data Modelling
• Develop enterprise and dimensional data models, including Star Schemas and Fact-Dimension structures.
• Design subject-area data marts for Finance, SCM, Customer, Sales, and Operations.
• Define KPI

📌 Big Data Engineer – Analytics Track (Gurugram)
🏢 Airtel
📍 Gurugram