Business Analyst Associate (On-site) at Aspen Medical

OBJECTIVE:

Main Purpose of the Role

The Business Analyst Associate 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. This is a combination of supervised as well as independent work that will be signed off by manager.

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 associate will work under supervision and would do the calculations, which determine the targets, based on the strategy determined by the Heads of SA Commercial.

SSD models maintenance & management (Sales out)

• Work under supervision to perform 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

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

Reporting and data management

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

Brand performance trackers and reporting

• Under supervision, 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.

Educational Qualifications & Experience

• Matric
• Tertiary qualification, preferably in BSc Science, Mathematics or Health Sciences
• 1+ years in data analytics
• 1+ years of Pharmaceutical experience (sales and marketing) is an advantage
• Advanced skills in 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 organization

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