Principal Analyst — Dashboarding & Commercial Analytics

Role Overview

Reporting & Dashboarding Excellence — Tableau

• Architect, build, and maintain enterprise-grade Tableau dashboards that communicate brand performance, patient journey dynamics, HCP engagement and field force activity to global stakeholders.
• Define, implement and enforce UI/visualization best practices and design standards (layout, color, accessibility, interactivity, storytelling) and build self-service reporting frameworks and templates that reduce ad hoc requests.
• Establish, standardize, and govern KPIs and metrics — brand performance, patient shares, new starts, duration of therapy (DoT), adherence, source of business, campaign effectiveness etc. — across global markets, regions and channels.
• Optimize data models, data extracts and refresh pipelines feeding dashboards to ensure accuracy, reliability, and performance at scale.

Commercial Analytics & Insight Generation

• Lead end-to-end delivery of the most complex performance analytics workstreams that track brand KPIs across global, regional, and country levels, setting the quality bar for the team.
• Integrate and analyze diverse commercial data sources across markets — real-world data (claims, EMR/EHR, lab data), specialty pharmacy, sales, and channel data — to generate comprehensive patient and HCP insights that support brand strategy and launch readiness.
• Drive advanced, self-directed exploratory data analysis (EDA) and opportunity prospecting — moving beyond basic pulls (counts, topline, segmentation, time trends) to surface non-obvious commercial opportunities and hypotheses that shape brand strategy.
• Own the most complex custom reporting and ad hoc requests with independent hypothesis formulation, rigorous methodology, and well-documented, insight-rich outputs, and guide others in doing the same.

Cohort Development and Segmentation

• Set the standard for patient and HCP cohorts built on deterministic logic and lead advanced cohort and segmentation approaches — including cluster and probabilistic models — for sophisticated targeting, prioritization, and micro-segmentation.
• Perform ETL, design and orchestrate reproducible data pipelines feeding reporting products, and automate recurring workflows using SQL, Python or R, API programming, and GenAI tools (e.g., Claude Code) as a coding partner.

Stakeholder Leadership & Mentorship

• Partner with GCC Managers and global I&A brand leads to clarify requirements, align on scope, and synthesize findings into decision-oriented visual stories with clear 'so what' recommendations.
• Formally mentor Analysts and Senior Analysts on Tableau, visualization design, and analytical methods, and lead team knowledge management (design patterns, reusable templates and query libraries).

Education & Experience

• Bachelor's Degree required in Statistics, Data Science, Life Sciences, Computer Science, or a related quantitative field; Master's degree or MBA strongly preferred.
• 5–6 years of progressive quantitative analytical experience in pharmaceutical commercial analytics or healthcare analytics, with a significant portion focused on both commercial analytics and reporting, BI, and data visualization.
• Expert-level, hands-on Tableau experience (Tableau Desktop and Server/Cloud) building and governing enterprise-scale dashboards is required; Tableau certification is a strong plus. Working knowledge of Power BI is a plus.
• Deep working knowledge of pharma commercial datasets across markets patient-level claims (e.g., IQVIA, Komodo Health, Symphony Health), specialty pharmacy, EMR, and sales data is required.
• Hands-on experience with data beyond claims is strongly preferred — lab data, EMR/EHR, medical and regulatory coding systems (e.g., ICD, procedure/reimbursement codes), public datasets, and research literature (Citeline, PubMed).
• Advanced proficiency in SQL, SAS, R, or Python for data manipulation and workflow automation; advanced Excel required. Familiarity with API programming and GenAI (e.g., Claude Code) as a coding partner; working knowledge of Databricks or cloud platforms preferred.
• Experience supporting global or regional brand teams or cross-functional analytics programs is strongly preferred.

Skills & Competencies

• Tableau Mastery & Reporting Architecture: Expert Tableau design, development, performance optimization, and Server/Cloud governance; sets visualization and self-service reporting standards.
• Data Visualization & Storytelling: Applies advanced visualization and storytelling principles — layout, color, accessibility, and interactivity — to build intuitive, decision-ready products.
• Advanced Commercial Data Analysis: Independently designs, executes, and leads the most complex analyses on multi-source, multi-market pharma datasets; interprets results with deep domain context and sets analytical direction.
• Cohort Development & Segmentation: Leads deterministic, business-rule-based cohorts and advanced probabilistic and cluster-model approaches for patient/HCP targeting.
• Stakeholder Communication & Mentorship: Communicates persuasively to global I&A leads; coaches analysts on Tableau and analytical best practices as a technical authority.

Benefits

• Competitive Salary + Performance Annual Bonus
• Flexible work environment, including hybrid working
• Comprehensive Healthcare Insurance Plans for self, spouse, and children
• Group Term Life Insurance and Group Accident Insurance programs
• Employee Assistance Program
• Broad Variety of learning platforms
• Diversity, Equity, and Inclusion Programs
• Reimbursements – Home Internet & Mobile Phone
• Employee Referral Program
• Leaves – Paternity Leave (4 Weeks), Maternity Leave (up to 26 weeks), Bereavement Leave (5 calendar days)

About ICC in Takeda

Additional Information