Manager – AI-Driven Reporting Solutions

Key Accountabilities

The Manager – Commercial Performance Analytics & Reporting is responsible for owning analytics workstreams and delivering accurate, timely, and actionable commercial reporting and performance insights. This role is highly hands-on, combining technical execution with day-to-day stakeholder engagement to support Sales, Marketing, and Commercial Operations.

The Manager partners closely with Senior Managers and Associate Directors to build BI solutions, analytics datasets, and foundational AI-enabled reporting capabilities, while ensuring adherence to analytics standards, data governance, and delivery timelines.

Key Responsibilities

1. Commercial Performance Analytics Delivery

• Own assigned commercial analytics and reporting workstreams supporting Sales, Marketing, and Commercial Operations.
• Translate business requirements into KPIs, reports, and analytical outputs.
• Support business performance reviews with accurate, timely, and well-documented analytics.

2. BI Development & Reporting Execution

• Design, build, and maintain Power BI dashboards and reports, including:
  • Dataset and semantic model development
  • DAX measure creation and performance optimization
• Implement standardized KPI definitions and reporting templates.
• Ensure reports meet usability, accuracy, and performance standards.

3. Analytics Engineering & Data Preparation

• Develop and maintain analytics datasets using:
  • SQL-based transformations
  • Dimensional and semantic data modeling techniques
• Build and support data pipelines using:
  • Databricks and/or Dataiku
  • Cloud-native platform pipelines and orchestration tools
• Partner with Data Engineering to resolve data quality, refresh, and performance issues.

4. Performance Analysis & Insight Development

• Perform performance analyses including:
  • Sales and campaign performance tracking
  • Trend and variance analysis
• Develop clear performance summaries and basic insight narratives for stakeholders.
• Escalate complex analytical questions to Senior Managers as needed.

5. AI-Enabled Reporting & Conversational Analytics (Foundational)

• Support development and enhancement of AI-enabled reporting and conversational analytics solutions by:
  • Preparing, validating, and maintaining datasets used by conversational interfaces
  • Assisting with testing and validation of chatbot outputs
• Build basic natural-language query experiences under guidance from Senior Managers.
• Ensure AI-enabled outputs are accurate, explainable, and compliant with internal standards.

6. Stakeholder Engagement

• Serve as a day-to-day analytics partner for operational and Manager-level stakeholders.
• Manage request intake, timelines, and deliverables for assigned workstreams.
• Communicate assumptions, limitations, and findings clearly and professionally.

7. Team Collaboration & Coaching

• Provide technical guidance to Senior Analysts and Analysts.
• Review work products for accuracy, consistency, and adherence to standards.
• Contribute to documentation, best practices, and knowledge sharing within the team.

8. Governance, Quality & Continuous Improvement

• Ensure analytics deliverables comply with data governance, security, and regulatory requirements.
• Follow established analytics development standards and documentation practices.
• Identify opportunities to improve efficiency through automation, reuse, and standardization.

Qualifications & Experience

Education

• Bachelor’s degree in Engineering, Computer Science, Information Systems, Statistics, Economics, or related field
• Master’s degree preferred

Experience

• 6–8+ years of experience in commercial performance analytics, BI, or reporting
• Experience owning analytics workstreams or projects
• Strong preference for pharmaceutical or life sciences commercial experience
• Demonstrated ability to deliver analytics solutions in structured, regulated environments

Technical Skills

Required

• Strong hands-on experience with Power BI (report development, DAX, performance tuning)
• Proficiency in SQL
• Experience working with Databricks and/or Dataiku
• Understanding of analytics engineering fundamentals and data modeling
• Familiarity with commercial performance data domains (sales, marketing, field activity)
• Strong attention to data quality and governance

Desired

• Exposure to AI-enabled reporting or conversational analytics
• Basic familiarity with natural-language querying or LLM concepts
• Python experience for analytics automation
• Experience working in cloud data environments

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 team’s 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.