Novartis Healthcare - Associate Director - Reporting Transformation & Artificial Intelligence Enablement

Job Posting Title: Associate Director Reporting Transformation & AI Enablement

Job Description 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.

Key Accountabilities :

- 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.

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.

- 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

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.

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.

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.

- Deliver compelling, executive-level storytelling through:

- Interactive BI experiences

- AI-generated narratives

- Strategic presentations and leadership reviews

- Act as a trusted analytics advisor to senior commercial stakeholders.

- Influence decisions by clearly communicating what happened, why it happened, and what actions to take.

- Lead, mentor, and develop analytics professionals across :

- BI and analytics engineering

- AI-enabled reporting and insight delivery

- Build team capability in modern analytics platforms, GenAI usage, and insight storytelling.

- Foster a culture of innovation, automation, and continuous improvement.

Education :

- Bachelors degree in Engineering, Computer Science, Information Systems, Statistics, Economics, or related field

- Masters degree or MBA preferred

- 12+ years of experience in commercial performance and advanced analytics, reporting, GenAI

- Strong preference for pharmaceutical or life sciences commercial experience

- Proven experience leading enterprise analytics modernization initiatives

Required :

- Advanced expertise in Power BI/Angular (enterprise semantic models, DAX optimization, capacity management)

- Strong hands-on experience with SQL and analytics engineering

- Deep experience with Databricks/Dataiku (Lakehouse architecture, Spark, Delta Lake)

- Experience with orchestration tools (dbt, Airflow, cloud-native pipelines)

- Strong understanding of commercial performance data domains (sales, marketing, field activity)

- Solid data governance, security, and compliance mindset

- Experience building GenAI-powered chatbots or conversational analytics solutions

- Hands-on exposure to LLMs, RAG architectures, prompt engineering, and AI evaluation

- Familiarity with agent-based or autonomous analytics concepts

- Python experience for analytics automation and AI integration

- Strong executive presence and stakeholder management skills

- Ability to balance strategic vision with hands-on execution

- Comfortable driving innovation in complex, regulated environments

- Excellent communication and storytelling abilities

Why Novartis : Helping people with disease and their families takes more than innovative science. It takes a community of smart, passionate people like you. Collaborating, supporting, and inspiring each other. Combining to achieve breakthroughs that change patients lives. Ready to create a brighter future together. https://www.novartis.com/about/roadmap/people-and-culture

Commitment to Diversity & Inclusion: Novartis is committed to building an outstanding, inclusive work environment and diverse teams representative of the patients and communities we serve.

Values and Behaviors: Demonstrates and upholds Novartis values and behaviors in all aspects of work and collaboration.

Location : Hyderabad NKC. Hybrid | 3 days a week in office is mandatory.