Reporting & Optimisation Specialist (Supply Chain) (JHB North) at Aspen Pharma Group

OBJECTIVE OF ROLE:

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

Requirements
EDUCATIONAL REQUIREMENTS

• Matric
• Bachelor of Science/Technology degree in a quantitative field (Mathematics, Statistics, Engineering)

KNOWLEDGE & EXPERIENCE REQUIREMENTS

• SAPICS/ASCM/CIPS certifications advantageous (e.g. CPIM)
• 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
• Strong ERP system skills (e.g. SAP), including advanced proficiency with Excel modelling required.
• Pharmaceutical experience preferred; if no pharma experience must have FMCG, chemical manufacturing and or related industry experience. 

SOFT SKILLS AND COMPETENCY 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 and propose innovative solutions
• Ability to balance multiple variables in complex scenarios 

Communication:

• Excellent verbal and written communication skills
• Ability to present technical information to non-technical audiences

Collaboration:

• Strong interpersonal skills for cross-functional teamwork
• Ability to work effectively with diverse stakeholders

Business Acumen:

• Understanding of business goals and financial implications
• Ability to align supply chain strategies with overall business objectives

Continuous Improvement:

• Creative mindset to develop innovative solutions for supply chain challenges.

Attention to Detail:

• High level of accuracy in data analysis and reporting
• Meticulous approach to quality control and data integrity
• Ability to manage and prioritize multiple tasks effectively 

Adaptability:

• Flexibility to work in a fast-paced, changing environment
• Openness to new ideas and approaches in supply chain management
• Ability to quickly learn and apply new technologies and methodologies   

SOFT SKILLS AND COMPETENCY REQUIREMENTS

• Strategic Thinking: Ability to see the big picture and align reports with business goals.
• Leadership: Capable of working with cross-functional teams and driving reports and deliverables to success.
• Detail-Oriented: Strong attention to detail to ensure report deliverables meet high standards and are sustainable.
• Adaptability: Flexibility to adapt to changing priorities and business needs.
• Problem-Solving: Proactive approach to identifying issues and implementing solutions.