Lead Product AI Data Engineer & Architect

3d3 days ago

Clarivate

Bengaluru, IN · Full-time · INR 2,500,000 – INR 4,000,000

About this role

We are seeking a Lead Product Development AI Engineer to design, build, and optimize end-to-end data architecture and scalable data platforms that power product analytics and AI-driven capabilities. This role targets highly experienced data engineers with deep expertise in data architecture, dimensional data modeling, analytics architecture, and AI-ready data pipelines.

Own and evolve product-level data architecture to ensure scalability, reliability, and alignment with analytics and AI/ML use cases. Design and implement scalable data pipelines supporting product analytics, user behavior tracking, and AI/ML initiatives while defining enterprise-aligned dimensional data models including star and snowflake schemas.

Partner with Product Managers, Data Scientists, Analysts, and Engineers to translate requirements into well-architected data models and pipelines. Prepare, validate, and document datasets used for analytics, experimentation, and machine learning while supporting product event tracking architectures.

Mentor data engineers through architecture reviews, code reviews, and design discussions. Collaborate with platform, cloud, and security teams to ensure scalable, secure, and production-ready data architecture that meets product requirements and platform constraints.

Requirements

Bachelor’s degree in engineering or master’s degree (BE, ME, B Tech, MTech, MCA, MS).
Minimum 7+ years of professional experience in data engineering, analytics engineering, or data architecture-heavy roles.
Expert-level proficiency in SQL and relational database design.
Strong programming experience in Python for data pipelines and automation.
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.
Ability to influence technical outcomes through architectural leadership and collaboration.

Responsibilities

Own and evolve product-level data architecture ensuring scalability, reliability, and alignment with analytics and AI/ML use cases.
Design and implement scalable, reliable data pipelines supporting product analytics, user behavior tracking, and AI/ML initiatives.
Define and maintain enterprise-aligned dimensional data models using star and snowflake schemas with correct grain and consistency.
Design and maintain fact and dimension tables ensuring performance, correct grain, and data integrity.
Partner with Product Managers, Data Scientists, Analysts, and Engineers to translate requirements into well-architected data models and pipelines.
Implement monitoring, testing, and alerting for data quality, pipeline health, and freshness.
Mentor and support data engineers through architecture reviews, code reviews, and design discussions.
Contribute to and enforce data architecture standards, naming conventions, and ETL/ELT best practices within product teams.