Strategic Analytics & Insights Analyst

Opella; Wien; On-site; EUR 13,000 - 20,000; Part time

Job summary

Opella is seeking a Business Excellence Analyst intern for a 1-year fixed-term position in Vienna, Austria. You will monitor in-market performance for Austria & Switzerland, build dashboards, and generate data-driven insights to support commercial decisions.

Collaboration with cross-functional teams is required to ensure forecast accuracy and effective performance tracking. The role emphasizes data quality, reporting automation, and a data-driven culture within a growing self-care business.

Qualifications

• Two–Three years of experience with performance reporting, forecasting, and business analytics.
• Ability to translate complex data into simple insights.
• Proficiency in Excel, Power BI/Power Query, and data management tools.
• Strong analytical and communication skills.
• Knowledge of AT/CH pharma market is an advantage.

Responsibilities

• Market & business performance tracking.
• Support in monitoring in-market performance (sales, share, distribution, pricing, competitive activity).
• Build and maintain dashboards, scorecards, and KPI trackers.
• Identify performance risks, opportunities, and early warning signals.
• Category forecasting & planning: support monthly and quarterly forecasts (volume, value, share).
• Collaborate with supply, finance, brand and commercial teams to ensure forecast accuracy.
• Translate data into actionable insights for commercial strategy and business cases.
• Support commercial teams with performance deep-dives, pricing analysis, and customer insights.
• Prepare insight-driven recommendations for leadership reviews.

Skills

Excel

Power BI

Data analysis

Communication

Tools

Power Query

Job description

Opella is seeking a Business Excellence Analyst intern for a 1-year fixed-term position in Vienna, Austria. You will monitor in-market performance for Austria & Switzerland, build dashboards, and generate data-driven insights to support commercial decisions.

Collaboration with cross-functional teams is required to ensure forecast accuracy and effective performance tracking. The role emphasizes data quality, reporting automation, and a data-driven culture within a growing self-care business.