Senior Analyst, BI Visualization, Data Integrations
Novartis
This listing was originally posted on Novartis's careers page. Formulate is an equal opportunity job aggregator and is not involved in the hiring process. Where salary information is estimated, it is derived from BLS industry benchmarks and may differ from actual compensation.
Upgrade to Pro to access the AI-generated 'Read before applying' briefing and other premium pharma intelligence.
Upgrade to Pro — $25/moJob Description Summary
We are seeking a Senior Analyst, BI Visualization to support the migration, redesign, and continuity of business intelligence dashboards and reporting solutions as part of a large-scale acquisition and platform change programs. This role ensures that the reporting ecosystem — dashboards, KPI visualizations, field-facing reports, and self-service analytics — is cataloged, mapped, rebuilt, and validated within the target organization's / target platform’s BI infrastructure with zero disruption to business decision-making.
Job Description
Location: Hyderabad # Hybrid
Key Responsibilities
Dashboard Discovery & Inventory: Catalog all dashboards, reports, and visualization assets — documenting data sources, refresh schedules, business owners, user audience, access permissions, and criticality tier. Classify each asset as migration-critical (e.g., field-facing, leadership, patient services) vs. deferrable.
Dashboard Migration & Rebuild: Design, develop, and rebuild dashboard solutions on the target BI platform, re-connecting to migrated data sources (curated/consumption-layer datasets). Ensure that visual design, interactivity, filters, drill-throughs, and calculated measures faithfully replicate reporting experience — or improve upon it where consolidation creates opportunity.
Data Source Re-Mapping: Work with data engineering teams to map legacy dashboard data connections (tables, views, semantic layers, direct queries) to their equivalents in the target data platform. Validate that underlying datasets are complete, accurate, and refreshing on schedule before connecting dashboards.
Metric Validation & Quality Assurance: Execute side-by-side validation of legacy vs. migrated dashboards — comparing KPI values, aggregations, trend lines, filters, and edge cases. Document discrepancies, perform root-cause analysis (data issue vs. calculation logic vs. visualization error), and drive resolution. Maintain quality checklists and SOPs for each migration wave.
Access & Permissions Configuration: Coordinate with security and governance teams to configure dashboard access, workspace permissions, row-level security, and distribution lists on the target BI platform. Ensure that user access models are translated appropriately to the target organization's / target platform’s security framework.
Stakeholder Communication & UAT: Serve as the interface between data/analytics teams and business consumers during dashboard migration. Coordinate UAT with field users, home office teams, and leadership — prepare test scenarios, collect feedback, triage defects, and drive to sign-off. Maintain regular communication on migration progress, timelines, and known issues.
Documentation & Standardization: Develop, document, and maintain SOPs, quality checklists, and dashboard specification documents for all migrated reporting assets. Identify opportunities to standardize reports across brands, domains, and functions enabled by platform consolidation — reducing redundancy and improving consistency.
Continuous Improvement: Continuously build technical and analytical capability by adopting new tools, approaches, and methods aligned to the target platform's evolving capabilities — including AI-powered analytics features where appropriate. Identify reporting enhancements made possible by migration (e.g., richer data, new domains, improved refresh frequency).
Essential Requirements:
Bachelor's degree in Engineering, Life Sciences, Pharmaceutical Sciences, or a related field.
3+ years of hands-on experience in data visualization and BI development, with strong expertise in Power BI (or equivalent enterprise BI platform such as Tableau or QlikSense).
Basic to intermediate working knowledge of SQL, Microsoft Excel, PowerPoint, and ETL/data preparation concepts.
Good interpersonal and communication skills with the ability to work across technical and business teams.
Demonstrated learning agility including the ability to leverage AI-powered tools to improve efficiency in day-to-day tasks.
Ability to manage multiple dashboard migrations in parallel across different business domains and stakeholder groups.
Desirable Requirement:
Hands-on experience with side-by-side metric validation between legacy and migrated dashboards — including KPI reconciliation, trend comparison, and root-cause analysis for discrepancies.
Experience coordinating dashboard UAT with business users — test scenario preparation, feedback collection, defect triage, and sign-off management across multiple stakeholder groups (field, commercial, leadership).
Strong focus on documentation, SOPs, and quality checklists — ability to maintain rigorous standards while operating under tight, wave-based migration timelines.
Commitment to Diversity & Inclusion
We are committed to building an outstanding, inclusive work environment and diverse teams representative of the patients and communities we serve.
Accessibility and accommodation
Novartis is committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the recruitment process, or in order to perform the essential functions of a position, please send an e-mail to diversityandincl.india@novartis.com and let us know the nature of your request and your contact information. Please include the job requisition number in your message
Skills Desired
Advertising Campaigns, Alteryx, Analytical Thinking, Brand Awareness, Business Networking, Curiosity, Digital Marketing, Marketing Communications, Marketing Plans, Marketing Strategy, Media Campaigns, Process Documentation, Statistical Analysis, Strategic MarketingExplore related positions you might be interested in
We'll notify you when matching roles are posted.
Interviewed at Novartis?
Help others prepare — share your experience anonymously.
PHARMACEUTICAL
Small Molecules, Vaccines, Biologics / Diagnostics
Upgrade to Pro to access AI interview prep brief and other premium pharma intelligence.
Upgrade to Pro — $25/mo