Business Analyst

Johannesburg, Gauteng, South Africa

Job Description


Company Description:

We are a global specialty and branded pharmaceutical company, improving the health of patients across the world through our high-quality and affordable medicines. Active at every stage of the value chain, we are uniquely diversi?ed by geography, product and manufacturing capability.

Aspen is a dynamic organisation built on entrepreneurial strength and forward-thinking minds. We attract high-performing individuals who are passionate about their career and have a desire to exceed expectations. At aspen, not only do we source for the best talent but we also provide a host of opportunities for continuous development.

The Groupxe2x80x99s key business segments are Manufacturing and Commercial Pharmaceuticals comprising Regional Brands and Sterile Focus Brands. We have approximately 9 100 employees at 69 established offices in over 50 countries and we improve the health of patients in more than 150 countries through our high quality, affordable medicines.

OBJECTIVE:

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:

(The primary tasks, functions and deliverables of the role)

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.
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
The job applicant acknowledges, agrees, accepts, and understands that the Company (Pharmacare Limited t/a Aspen Pharmacare), has a mandatory Covid-19 Vaccination Policy and Plan which, inter alia, provides for mandatory vaccination for customer-facing employees. Mandatory Covid-19 vaccination applies to this job vacancy. As such, in applying for and if applicable accepting an offer of employment for this job role, the applicant warrants that s/he is fully vaccinated and that his/her vaccination status is valid and up to date. The Job applicantxe2x80x99s electronic vaccination certificate, as issued by the NDOH, must be provided if the job application results in an offer and subsequent acceptance of this offer of employment. The applicant acknowledges, further, that there is no particular reason that he/she would refuse any future booster or vaccination requirements that may/should be recommended by the South African health authorities.

Aspen is committed to the principles of equal employment opportunity and suitably qualified job applicants are invited to submit their CV online on or before 25th August 2023. Preference will be given to applicants from designated groups through a fair recruitment and selection process in accordance with laws governing employment equity, where such laws are applicable to the Aspen entity that will employ the successful candidate. If you have not heard from the HR department within 30 days of this advert closing, please consider your application unsuccessful.

Internal Applications must be completed using an Aspen mailing address after applicants have had informed their direct line managers of their application.

Aspen Pharmacare

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD1249627
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Johannesburg, Gauteng, South Africa
  • Education
    Not mentioned