Back to search

Data Tech Lead

Hyderabad Temporary View Job Description
As a Data Tech Lead in Hyderabad, you'll work in the cosmetics sector to manage and oversee data solutions. You'll ensure systems run smoothly and meet business needs.
  • France Based Cosmetic Gaint in india.
  • Be a part of growing GCC setup

About Our Client

A company in the cosmetics industry located in Hyderabad.

Job Description

A Day in the Life of Technical Lead - Python, SQL & AI-Augmented Engineering

As the Data Technical Lead, you are the hands-on master of the data factory. You will translate the Solution Architect's high-level data strategy into robust, production-grade code. Your mission is to lead a squad of data engineers in building scalable ETL and Reverse ETL pipelines using Python, SQL, and Airflow, while mandating the use of AI coding assistants to automate pipeline generation and query optimization.

In this role, You will..

1. AI-Driven Data Engineering (Mandatory)

  • AI Velocity: Standardize the use of GitHub Copilot, Cursor, or ChatGPT to generate complex SQL transformations, Python scripts, and PySpark logic.
  • Query Optimization: Use AI-assisted tools to refactor legacy SQL for performance and cost efficiency (e.g., reducing BigQuery/Snowflake compute costs).
  • Unit Testing for Data: Leverage AI to generate exhaustive test suites for data validation and schema drift detection.



2. ETL & Reverse ETL Mastery

  • Orchestration: Design and maintain complex, idempotent Airflow DAGs. Ensure high availability and observability of schedules.
  • Streaming & Batch: Implement data processing using Google Cloud Dataflow (Apache Beam) or Spark for massive-scale transformations.
  • Reverse ETL: Bridge the gap between the Data Warehouse and Business Apps (Salesforce, Braze, Google Ads) to ensure "Data Activation" is seamless and reliable.



3. Python & SQL Excellence (The "How")

  • Pythonic Patterns: Develop custom Python libraries and operators for the data team to ensure DRY (Don't Repeat Yourself) principles across all pipelines.
  • SQL Governance: Own the "Gold Standard" for SQL performance. Conduct rigorous code reviews focusing on window functions, partitioning, and indexing.



4. Partnership with Solution Architect

  • From Blueprint to Build: Take the Architect's ERD (Entity Relationship Diagram) and turn it into optimized Physical Tables and views.
  • Operational Integrity: Implement the CI/CD strategy for data (Git, dbt, or similar) to move from development to production without downtime.



What are we looking for?

What's In It for You?

· Working with cutting edge Technology, empowering employees with learning, global exposure, and opportunities to build future-ready careers.

· A flexible and modern workplace, enabling teams to perform at their best through a smart hybrid model that supports balance and autonomy. A 3 Day in Office, 2 Day Work from Home setup.

· Employee support at every life stage, with inclusive and progressive parental policies that help individuals and families thrive.

· Holistic wellbeing offerings - personalized health benefits and strong mental wellness support to ensure employees feel their best.

Reward and Recognition opportunities, long-term incentives, and opportunities to share in L'Oréal's collective success

The Successful Applicant

Technical Requirements

  • AI Tooling: Expert proficiency in GitHub Copilot or Claude Code for accelerating Python and SQL development.
  • Data Stack: Expert knowledge of Python 3.x and advanced SQL (analytical functions, recursive CTEs).
  • Orchestration: 3+ years of experience with Apache Airflow.
  • Cloud Processing: Proven experience with Google Cloud Dataflow (Apache Beam) or similar managed services (Dataproc, AWS Glue).
  • Data Concepts: Expert in ELT/ETL patterns, Data Lakehouse architecture, and Reverse ETL strategies.



Soft Skills & Qualifications

  • Experience: 7+ years in Data Engineering, with 2+ years leading a squad.
  • Pragmatism: Ability to balance "Perfect Code" with "Business Velocity" using AI.
  • Leadership: Experience mentoring junior data engineers in writing clean, scalable Python.
  • Education: Bachelor's or Master's degree in Computer Science, Engineering, or a related field.

What's on Offer

  • Work on impactful projects in the cosmetics industry.
  • Collaborative and supportive team environment.
  • Opportunity to develop technical and leadership skills.



If this role aligns with your skills, feel free to apply.

Quote job ref
JN-102026-7122838

Job summary

Function
Information Technology
Sub Sector
IT Development
What is your area of specialisation?
FMCG (Fast Moving Consumer Goods)
Location
Hyderabad
Job Type
Temporary
Job Reference
JN-102026-7122838

Diversity & Inclusion at Michael Page

We don't just accept difference - we celebrate it. We encourage applicants from all backgrounds to apply for this role and are committed to building inclusive, diverse workplaces where everyone can thrive. If you require any support or reasonable adjustments during the recruitment process, please let us know.