Aspen has a proud heritage dating back more than 160 years and is committed to sustaining life and promoting healthcare through increasing access to its high quality affordable medicines and products. Aspen has a market capitalisation of approximately US$10 billion, is the largest pharmaceutical company listed on the JSE Limited (share code: APN) and rank...
Read more about this company
Objective:
The Business Intelligence Analyst is responsible for supporting the SSD sales dataset that plays a pivotal part in driving business decisions. The Business Intelligence Analyst is responsible for building and maintaining a partnership with Sales and Marketing and Business Excellence teams. Closely align with the Business Intelligence (BI) dev team with reviewing current and future based BI and reporting solutions on datasets. This includes creating user requirement specifications, be part of development phase as a tester and rolling out the BI solution to business.
KEY RESPONSIBILITIES
SSD Sales budgets integration
- Be a key person in the team that calculates and integrate Sales budgets into BI models.
Support and Drive the SSD sales dataset with Sales and Marketing
- Perform Data validations according to set criteria based on SSD raw data sent to them.
- Using SQL/Power BI/Dev tools 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
Qlikview system management and maintenance
- Using SQL/Power BI/Dev tools identify, clarify, and resolve Qlikview SSD system and maintenance activity issues and risks, escalating them as needed
Reporting and data management
- Quality data reports delivered as per business expectations and validated by the business unit heads.
Oversee the development of automated, scalable, and thoroughly documented reporting solutions
- Reporting solutions are automated, scalable, and documented.
Ensure the work delivered is accurate, of high quality, delivered on time, and complies to SA Commercial’s IT and Data Governance rules
- Accurate, high-quality work delivered on time and in compliance to SA Commercial’s IT and Data Governance rules
Manage internal business/business partner relationships, expectations, and service levels
- Business/business partners are relatively satisfied
Adhoc data analysis requests
- 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.
Ensure that training and support is available for all users
- Users are able to use the applications independently
SA Commercial’s Data Governance
- Ensure the work delivered is accurate, of high quality, delivered on time, and complies to SA Commercial’s Data Governance rules.
Adding business value
- Support business KPI’s by identifying data needs and delivering value cases and in turning data to business value.
Requirements
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
- Have a complete and thorough understanding of the sales, marketing, and supply chain of the business
- Demonstrating strong proficiency in Microsoft Office programs, such as Excel and PowerPoint
- Demonstrated ability to effectively communicate verbally and in writing with diverse groups including business associates, technical associates, and leadership.
- Have the ability to understand all aspects of the business and work in partnership with other departments to achieve the company goals.
- Experience in working both with technical and business teams.
- Ability to work cohesively with the Information Technology department counterparts.
- Able to communicate positive and negative information when required.
- Superior critical thinking, analytical and problem-solving skills.
- Able to proactively identify business opportunities and translate it to key stakeholders
- Efficient prioritization of tasks for critical business deliverables
- 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)
- SQL & database management experience
- Data Warehouse design & Implementation
- Strong interest in predictive analytics
- Solid experience in using and developing in Qlikview, Qliksense, Power BI.
- Planning, Budgeting and Forecasting processes
- Data Governance
- 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
- Excellent technical leadership qualities
- Ability to anticipate and solve problems
EDUCATION & EXPERIENCE
- Matric/ Grade 12
- Degree/Diploma in Marketing/Business Analysis/Business Science
- 5+ years in pharmaceutical sales and/or marketing management.
- 5+ Years’ experience working in / with BI teams
- Data analytics experience in the Pharmaceutical Industry Sales and/or Marketing management environment.
- SQL & database management experience is essential
- Data Warehouse design & Implementation
- Qlikview - 3 to 4 years’ experience
- Strong interest in predictive analytics
- Solid experience in using and developing in Qlikview, Qliksense, Power BI.
Closing Date: 22nd, July 2022
Gmail
Yahoomail