About Our Client

This company operates in the cosmetics sector, part of the broader FMCG industry, and is based in Hyderabad.

Job Description

We are looking for a hands-on Senior Data Engineer to join our data squad and work directly with the Technical Lead to execute our data strategy. You will be responsible for the "build" part of the blueprint. This role focuses on delivering production-grade implementations, optimizing complex SQL, and building scalable ETL/Reverse ETL pipelines using Python, SQL, Airflow and Apache Beam. You will collaborate with the Tech Lead to ensure that AI coding assistants are used effectively, code is clean, and data is activated reliably via automated piplines. In this role, You will..

1. AI-Driven Data Engineering (Execution Focus)

* AI Productivity: Use GitHub Copilot, Cursor, ChatGPT or Claude Code to generate complex SQL transformations, Python scripts, PySpark logic and data processing pipelines, in accordance with the AI standardization strategy.

* Performance Tuning: Use AI tools to analyze query execution plans, identify bottlenecks,



and refactor legacy SQL for performance and cost efficiency (e.g., reducing BigQuery/Snowflake slot usage).

* Data Validation: Utilize AI to generate comprehensive test suites for data quality checks and schema drift detection.ETL & Reverse ETL Build

* Orchestration: Build and maintain complex, robust and idempotent Airflow DAGs. Ensure high availability and observability of schedules.

* Batch & Streaming: Develop data pipelines using Python, Spark, or Google Cloud Dataflow (Apache Beam), Dataform to handle large-scale data transformations.

* Data Activation: Design and implement Reverse ETL processes to sync data between the Data Warehouse and critical business applications (Salesforce, Tealium, Braze, Google Ads etc), ensuring "Data Activation" is seamless and reliable.3. Python & SQL Excellence

* Core Libraries: Contribute to the development and maintenance of internal Python librarie

📌 Senior Data Engineer (Hyderabad)
🏢 Michael Page
📍 Hyderabad