Lead Product AI Data Engineer & Architect

5w1 month ago

Clarivate

Bengaluru, IN · Full-time · INR 3,500,000 – INR 5,000,000

About this role

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, technical execution, dimensional modeling excellence, and team-level technical leadership.

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 across the organization.

The DIA team operates globally and collaborates closely with product owners, architects, and data experts. This is a fast-paced, innovation-driven environment where you'll have the opportunity to take ownership of features and contribute to system design.

Serve as the technical authority guiding architecture decisions to meet product, platform, and AI requirements. You will also manage data architecture and technical leadership for product and AI data enablement, driving impactful projects and shaping AI-ready data platforms.

Requirements

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.
Strong 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.
Experience with cloud data warehouses such as Snowflake, Databricks.
Strong programming experience in Python for data pipelines and automation.
Familiarity with tools such as dbt, Airflow, Fivetran, and Segment.

Responsibilities

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 and dimension tables, ensuring proper grain, SCD handling, hierarchical dimensions, and high-performance queries.
Establish data architecture principles, naming conventions, and best practices for ETL/ELT, event tracking, and AI pipelines.
Serve as the technical authority guiding architecture decisions to meet product, platform, and AI requirements, and manage Data Architecture & Technical Leadership for Product & AI Data Enablement with Data Quality, Reliability & Operations.

Benefits

Hybrid working environment
Collaborate with a global, cross-functional team of product owners, architects, and data experts
Opportunity to take ownership of features and contribute to system design
Mission-driven culture focused on enabling life-changing insights