Business Analyst (JHB North) at Aspen Pharma Group

OBJECTIVE OF ROLE

• The Business Analyst is responsible for delivering the analytical and reporting requirements of the sales, key account and marketing business units. This role owns the end-to-end reporting cycle, from daily operational dashboards and automated data flows through to monthly commercial reviews and half-yearly strategic analyses, providing data-driven insights that support informed decision-making.

KEY RESPONSIBILITIES

Daily Operational Reporting & Dashboards

• Deliver daily reports including Meridian Daily Push Report, Product Trackers, UPD Expiry Report, Push/In Pick report, and Power BI dashboards. Ensure all daily datasets are refreshed and published accurately.

Sales revenue target setting calculation support

• Clearly defined monthly, quarterly and yearly targets for Channel Operations Managers per territory per brand. Analyse IQVIA/IRI/Nielsen/Sales Out Data/TM1 reports to see a breakdown of products by territory and brand. The business analyst would do the calculations, which determine the targets, based on the strategy determined by Commercial Head.

Commercial models maintenance & management (Sales out)

• Data validations according to set criteria based on IQVIA/IRI/Nielsen/Sales Out Data/TM1 reports sent to them. Update the system changes to reflect any territory or brick changes. Manage Customer Classifications (Key accounts). Strongly assess and monitor each channel’s sales, regional, national per product, portfolio and total. Includes monthly TM1 mapping.

Weekly & Monthly Reporting Suite

• Weekly: Retail SOH reports across key retailers. Monthly: Commission reports, Consumer Dashboards, Traditional Trade Reviews, Service Levels Reports, SSD Data reports.

Power BI Dashboard Development & Maintenance       

• Build, maintain, and publish Power BI dashboards. Manage automated flows, dataset scheduling, and mailing lists for all BI reports.

Ad hoc data analysis & Merchandising support

• Ad hoc data analysis as required by stakeholders/Commercial functions. These would relate to reports they require to assist them in understanding their customers more effectively. Maintain and update all data metrics, scorecards and KPIs provided by Merchandising Service Providers.

Requirements
EDUCATIONAL REQUIREMENTS

• Tertiary qualification required (ideally in data analysis or similar)

KNOWLEDGE & EXPERIENCE REQUIREMENTS

• 1-3 years’ experience in data analytics within the FMCG and/or pharmaceutical markets
• Proven track record in servicing internal customers / stakeholders
• Experience of having operated in a complex matrix organisation
• Familiarity with and experience in third-party market data sources (IQVIA, IRI, Nielsen, Circana, Sales Out Data)
• Understanding of Sales, Marketing & Key Accounts commercial operations and processes, including the budget process and target setting, within an FMCG setting
• Experience in commission structures and incentive calculations

SOFT SKILLS AND COMPETENCY REQUIREMENTS

• Sound knowledge of data and insight integration to inform, support, and direct business strategy
• Strong analytical, strategic, and creative problem-solving skills
• Storytelling and sense-making of data to translate into business insights
• Demonstrate the ability to turn data driven insights into actionable ways to drive business results
• Able to proactively identify business opportunities and translate it to key stakeholders
• Efficient prioritization of tasks for critical business deliverables, balancing daily, weekly, monthly, quarterly, and half-yearly reporting cadences
• Ability to develop and deliver compelling executive-level presentations
• Ability to perform well under pressure and maintain commitment to deadlines
• Cross collaboration across the organization
• Excellent interpersonal, teamwork and communication skills
• Self-motivated, curious, and critical thinker
• Excellent written and verbal communication skills and the ability to simplify complex data-driven insights
• Drives accountability for personal and team performance