Job Description Summary
-The Manager – AI-Driven Reporting Solutions leads end-to-end delivery of commercial performance analytics and reporting workstreams, supporting Sales, Marketing, and Commercial Operations. This hands-on role designs and builds scalable BI dashboards, analytics datasets, and data pipelines using Power BI, SQL, and modern data platforms.
Job Description
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.
Skills Desired
Agility, Analytical Thinking, Brand Awareness, Business Analytics, Cross-Functional Collaboration, Digital Marketing, Marketing Strategy, Media Campaigns, Project Management, Project Planning, Sales, Stakeholder Engagement, Stakeholder Management, Strategic Marketing, Waterfall Model