Business Analyst - JHB North at Aspen Pharma Group

Main Purpose of the Role

• The Business Analyst is responsible for delivering the analytical requirements of the business across Aspen SA Commercial including SADC, Public Health and Aspen Communications Centre. Reporting on data-based insights across the commercial organization for informed decision-making processes.

Key Responsibilities:

Sales Representative revenue target setting

• Clearly defined yearly targets for each sales representative per territory per brand. This is done by analysing IQVIA/CENTRIX/IRI reports to see a breakdown of products by territory and brand. This is historical.
• The business analyst will do the calculations, which determine the targets, based on the strategy determined by the Heads of SA Commercial.

SSD models maintenance & management (Sales out)

• Performs Data validations according to set criteria based on SADC/IQVIA/CENTRIX/IRI reports sent to them
• Update the system changes to reflect any territory or brick changes. Manage Customer Classifications (Key accounts).
• Management of Sales and Marketing structure (Resource movement). This includes any Salesforce movements that could affect target or commissions

Repwise system management

Maintain and update information related to:

• Wholesaler products code
• Team brand allocation
• SEP imports
• Detail brands allocation
• Ordering device settings
• Stock management and out of stocks

Glass system management

Maintain and update information related to:

• CPA measurement
• Employee list management
• Product team master
• Customer database
• Sales team reporting line management
• Territory structures
• Customer classification

Incentives and awards management

• Perform quarterly accurate incentive calculations that include updated focus brands and product weightings according to the incentive eligibility guidelines that are provided to them.
• Perform annual awards calculations based on predefined criteria and metrics management.

Reporting and data management

• Quality data reports are delivered as per business expectations and validated by the business unit heads.

Brand performance trackers and reporting

• Perform reporting of brand performance through appropriate analytical tools such as:
• Power BI
• Excel brand dashboards
• New product launch dashboards
• This is according to annual budgeted targets that have been set by the Business Unit Head team.

Adhoc data analysis request

• Adhoc data analysis as required by stakeholders/brand managers and Sales Representatives. These would relate to reports they require to assist them in understanding their customer more effectively.

Requirements

QUALIFICATIONS & EXPERIENCE:

Educational Qualifications & Experience

• Tertiary qualification, preferably in BSc Science, Mathematics or Health Sciences
• 3+ years in data analytics and insights
• 2+ years of pharmaceutical experience (sales and marketing) is an advantage.
• Advanced skills in Power BI, QlikView or other interactive BI dashboard tools
• Advanced skills in Microsoft suite (Excel advanced)
• SFDC Certified Administration is an advantage
• Proven track record and customer service experience
• Experience of having operated in a complex matrix organisation

 Skills and Attributes:

• 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
• 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

Knowledge:

• Experience in data analytics with the pharmaceutical market
• Understanding of market data and data extraction and transformation methodologies
• Systems (SAP) and data analytics / BI Tools (Power BI, QlikView)
• Advanced MS Excel
• Analytics and proficiencies in Microsoft
• Commercial operations and processes (Sales, Marketing, Key Accounts) and impact on business
• Budget process and target setting