Associate Director – Reporting Transformation & AI Enablement

Summary The Associate Director will lead the modernization of commercial performance analytics, transforming traditional reporting into AI-enabled, insight-driven decision support. The role is responsible for architecting and delivering enterprise-grade BI and analytics solutions using modern data platforms such as Databricks and cloud data warehouses, while driving advanced KPI harmonization and scalable semantic models.

This leader will spearhead GenAI-powered conversational analytics, intelligent automation, and agent-based insight generation to shift from reactive dashboards to proactive performance management. The role partners closely with commercial stakeholders to embed analytics into strategic decision-making and ensure executive-ready storytelling.

Additionally, the Associate Director will build and mentor high-performing analytics teams, champion data governance and compliance, and foster innovation across modern analytics, AI, and automation capabilities.

About The Role Location: Hyderabad | Key Accountabilities

• Commercial Performance Analytics Strategy
• Define and execute the future-state vision for commercial performance analytics, evolving from static dashboards to AI-augmented, conversational, and proactive insights.
• Partner with senior commercial leaders to embed analytics into performance reviews, planning cycles, and execution tracking.
• Act as a thought leader for modern analytics platforms, advanced BI, and GenAI adoption within Commercial Reporting Analytics.
• Advanced BI & Reporting Products

• Lead the design and delivery of enterprise-grade reporting and analytics products, leveraging:

• Power BI/Angular (enterprise semantic models, optimized DAX, deployment pipelines)

• Standardized KPI frameworks and reusable metrics layers

• Drive adoption of self-service analytics while maintaining strong governance, consistency, and performance.
• Transition reporting from dashboard-centric delivery to insight-centric experiences, including narrative and AI-generated explanations.
• Modern Analytics & Data Platform (Core Focus)

• Architect and oversee analytics solutions built on modern platforms such as:

• Databricks (Lakehouse architecture, Spark, Delta Lake)

• Cloud data warehouses (Snowflake, BigQuery, Azure Synapse)

• Lead analytics engineering best practices, including:

• Advanced SQL and dimensional / semantic data modeling

• Good to have experience of building data ingestion pipelines using Databricks, Dataiku, Airflow, and cloud-native orchestration tools

• Partner with Data Engineering and IT to ensure:

• Scalable, performant, and compliant data pipelines

• Strong data quality, lineage, and governance controls

• Advanced Performance Analytics & Insight Generation

• Drive advanced analytical approaches focused on commercial performance, including:

• Sales performance tracking and trend analysis
• Forecast versus actual performance monitoring

• Promotional and campaign performance measurement

• Design scalable analytical frameworks that enable root-cause analysis, performance narratives, and actionable recommendations.
• Translate complex analytical outputs into clear, executive-ready insights.
• Generative AI & Conversational Analytics

• Lead the design and deployment of GenAI-powered conversational analytics solutions, including:

• Chatbots enabling natural-language interaction with commercial performance data

• AI assistants delivering on-demand insights, explanations, and performance summaries

• Implement enterprise-ready GenAI architectures using:

• Azure OpenAI / OpenAI / Vertex AI
• Retrieval-Augmented Generation (RAG)

• Secure prompt engineering, evaluation, and monitoring frameworks

• Ensure AI solutions adhere to pharma compliance, data privacy, and responsible AI standards.
• Agent-Based Analytics & Intelligent Automation (Advanced / Emerging)

• Design and pilot agent-driven analytics capabilities that:

• Monitor KPIs and detect performance anomalies
• Proactively generate insight narratives and alerts

• Automate recurring reporting and analytical workflows

• Collaborate with platform teams to evolve from reactive reporting to proactive, agent-enabled insight delivery.
• Evaluate emerging agent orchestration and workflow automation frameworks.
• Stakeholder Engagement & Insight Storytelling

• Deliver compelling, executive-level storytelling through:

• Interactive BI experiences
• AI-generated narratives
• Strategic presentati…