We are seeking a Lead Product AI Data Engineer / Architect to design, build, and optimize end-to-end data architecture and scalable data platforms that power product analytics and AI-driven capabilities.
This role blends data architecture ownership, deep technical execution, dimensional modeling excellence, and team-level technical leadership for AI Ready Product Data Pipelines.

About You – experience, education, skills, and accomplishments
- Bachelor’s degree in engineering or master’s degree (BE, ME, B Tech, MTech, MCA, MS) with minimum 7 years professional experience in data engineering, analytics engineering, or data architecture–heavy roles.
- Expert-level proficiency in SQL and relational database design.
- Deep hands-on experience with data architecture and dimensional data modeling, including star schemas, snowflake schemas, fact tables, and dimension tables.
- Solid understanding of slowly changing dimensions (SCDs), surrogate keys, grain definition, and hierarchical dimensions.




- Experience designing and operating ETL/ELT pipelines for production analytics and AI/ML workloads.

It would be great if you also have:
- Experience with cloud data warehouses such as Snowflake, Data Bricks
- Robust programming experience in Python for data pipelines and automation is a big plus.
- Familiarity with tools such as dbt, Airflow, Fivetran, and Segment.
- Exposure to BI and visualization tools (Power BI, Tableau, SAP BusinessObjects).
- Familiarity with AWS, Azure, or GCP, including data governance and security best practices.

What will you be doing in this role?
- Define and evolve enterprise-level product data architecture across multiple product lines, ensuring scalability, reliability, and AI/ML readiness.
- Architect scalable ETL/ELT pipelines and distributed data workflows for analytics, AI, and product intelligence.
- Develop and enforce dimensional data modeling standards (star schemas, snowflake schemas) across the organization.
- Design and maintain fact a

📌 Lead Product AI Data Engineer (Bengaluru)
🏢 Clarivate
📍 Bengaluru