Reporting & Optimisation Specialist (Supply Chain)

**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 Group’s 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**

The purpose of the Reporting & Optimisation Specialist (Supply Chain) is to leverage data analytics and business intelligence techniques to provide actionable insights that enhance supply chain processes. This position aims to support the supply chain team by analyzing and creating data reports related to procurement, sourcing, inventory management, logistics, and supply. The Reporting & Optimisation Specialist (Supply Chain) works to ensure that supply chain activities align with business goals, cost-saving initiatives, and customer satisfaction standards.

**KEY RESPONSIBILITIES**

**Data gathering, analytics, collaboration and continuous improvement**
- Develop and implement comprehensive reporting frameworks to monitor supply chain performance across the entire supply chain.
- Collaborate with IT and data analytics teams to enhance reporting tools and systems.
- Data Collection and Integration: Gathering data from various sources within the supply chain, including ERP systems, logistics databases, and other sources like sales data and trends and financial data.
- Data Cleaning and Validation: Ensuring data quality by identifying and rectifying errors, inconsistencies, and missing information in datasets.
- Reporting and Visualization: Presenting findings and insights to stakeholders through clear and actionable reports, dashboards, and data visualizations. This facilitates decision-making and strategic planning within the organization.
- Ensure that requirements are captured accurately, documented and signed off prior to implementation of new development or changes to existing reporting.

**Data reporting**
- Creation of Demand Forecasting Reports integrated through planning systems
- Creation of Inventory monitoring tools within the Supply Chain
- Creation of Dashboards for Supply Chain KPI’s and maintenance of existing Dashboards
- Creation and maintenance of Data Visualisation Dashboards for ease of business management across the Supply Chain

**Compliance and Risk Management**
- Risk Assessment Reports: Identification and assessment of risks within the supply chain, along with logical mitigation strategies.
- Compliance Reports: Ensuring supply chain practices adhere to relevant regulations and standards.
- ERP Systems: Utilization of ERP systems (e.g., SAP, Oracle) for data collection and reporting.
- Database Management: Efficient management and extraction of data from databases (e.g., SQL, NoSQL).

**EDUCATIONAL REQUIREMENTS**
- Matric
- Bachelor of Science/Technology degree in a quantitative field (Mathematics, Statistics, Engineering)
- SAPICS/ASCM/CIPS certifications advantageous (e.g. CPIM)

**KNOWLEDGE & EXPERIENCE REQUIREMENTS**
- 3-5 years of experience in a data scientist/analyst role, preference in a multinational office
- Experience with data visualisation tools to develop BI dashboards (e.g. Power BI or Tableau)
- Strong statistical analysis skills
- Pharmaceutical experience preferred; if no pharma experience must have FMCG, chemical manufacturing and or related industry experience.

**SOFT SKILLS REQUIREMENTS**

**Data Analytics**
- Experience with statistical analysis and predictive modelling.
- Experience with data visualization tools (e.g., Tableau, Power BI)
- Skills for database querying and management

**Business Intelligence**
- Ability to translate complex data into actionable insights
- Understanding of BI tools and methodologies
- Experience in creating dashboards and reports for decision-making

**Supply Chain Knowledge**
- Comprehensive understanding of end-to-end supply chain processes
- Familiarity with procurement, sourcing, inventory management, and planning
- Knowledge of supply chain optimization techniques and best practices

**Technical Skills**
- Capability to develop and use optimization models.
- Experience with ERP systems and supply chain management software

**Problem-Solving**
- Analytical mindset with strong critical thinking abilities
- Capacity to identify inefficiencies