Lead Product AI Data Engineer & Architect

Lead product development AI/data engineering in a hybrid Bangalore setup, focusing on end-to-end architecture and scalable platforms for analytics and AI/ML.

Responsibilities

• Own and evolve product-level data architecture for scalability, reliability, and alignment to analytics and AI/ML use cases
• Design and implement scalable, reliable data pipelines for product analytics, user behavior tracking, and AI/ML initiatives
• Define and maintain dimensional data models using star and snowflake schemas
• Design and maintain fact and dimension tables with correct grain, performance, and consistency
• Help enforce data architecture and modeling standards, including naming conventions and ETL/ELT best practices across product teams
• Provide architectural guidance to ensure data solutions meet product requirements, platform constraints, and AI/ML needs
• Partner with Product Managers, Data Scientists, Analysts, and Engineers to translate requirements into well-architected models and pipelines
• Prepare, validate, and document datasets used for analytics, experimentation, and machine learning
• Support and evolve product event tracking architectures aligned with dimensional models and downstream analytics
• Implement monitoring, testing, and alerting for data quality, pipeline health, and freshness
• Ensure integrity of fact and dimension data via validation, reconciliation, and automated checks
• Diagnose and resolve complex data issues impacting analytics, AI workflows, or product features
• Mentor and support data engineers through architecture reviews, code reviews, and design discussions
• Participate in cross-team data architecture, modeling, and pipeline design reviews
• Collaborate with platform, cloud, and security teams to deliver scalable, secure, production-ready data architectures
• Drive enterprise-grade outcomes such as well-architected product and AI data platforms and analytics- and AI-ready datasets

Requirements

• Bachelor's degree in engineering or master’s degree (BE, ME, B Tech, MTech, MCA, MS)
• 7+ years professional experience in data engineering, analytics engineering, or data architecture-heavy roles
• Expert 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 modeling (star schemas, snowflake schemas, fact tables, 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

Technologies

• SQL, Python
• Snowflake, Data Bricks, BigQuery, Amazon Redshift
• dbt, Airflow, Fivetran, Segment
• Power BI, Tableau, SAP BusinessObjects
• AWS, Azure, GCP
• JSON

It would be great if you also had

• Experience with cloud data warehouses such as Snowflake, Data Bricks, BigQuery, or Amazon Redshift
• Familiarity with dbt, Airflow, Fivetran, and Segment
• Experience working with event-driven or semi-structured data (JSON, logs, clickstream)
• Exposure to BI and visualization tools (Power BI, Tableau, SAP BusinessObjects)
• Familiarity with AWS, Azure, or GCP, including data governance and security best practices

About the team

• Builds and maintains internal tools to convert unstructured internet data into structured datasets for cross-referencing and analysis
• Data is exposed to multiple products delivered to company customers
• Works with other teams to create a service mesh structure that communicates through asynchronous queue services hosted in AWS

Hours of work

• Hybrid role working 2-3 days a week in Bangalore, India