Advisor, Category Planning - Analytics
Core
Aggregating, reporting, and forecasting P&L for designated businesses to support category financial plans and drive market share growth.
Role type
Senior IC analytics specialist (category planning)
Builds
Scalable foundational reports, interactive dashboards, and repeatable analytics solutions for category management leaders.
Domain
Pharmaceutical Distribution / Consumer Health / Retail
Deliverable
dashboards & analysis
Required skills
SQL, cloud data warehouses (Google BigQuery), modern BI tools (Looker, PowerBI, Tableau), workflow automation (Alteryx), data hygiene, business metrics interpretation
Preferred skills
AI tools (Gemini, Copilot), prompt engineering, enterprise ERP systems (SAP), syndicated market data analysis (NIQ, IRI)
Technologies
Google BigQuery, Looker, PowerBI, Tableau, Alteryx, SAP, Gemini, Copilot
Responsibilities
Develop and maintain core reports and dashboards; translate business questions into scalable reporting solutions; integrate non-transactional data into reporting workflows; validate inputs and outputs using reasonableness checks and source reconciliation; explore AI and automation use cases to enhance reporting workflows; assist with meeting preparation by pulling relevant metrics and summarizing insights.
Seniority
Senior, hands-on IC