Data Tech Lead

• Data Tech Lead
• Company: Michael Page
• Job Location: Hyderabad, Telangana, India
• Employment Type: Not specified
• Experience Required: 3+ years
• 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.
• 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 MasteryOrchestration: 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 ArchitectFrom 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'Oral'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. .