Data Analyst - FTTH-JHB (Sandton) at Publicis Groupe

QUALIFICATIONS AND EXPERIENCE

• Minimum Matric
• Minimum 3 years related sales operations environment with reporting experience
• Must be able to work in a fast-paced environment, multi-task, and have good communication skills, both verbally
• Advanced Excel and Proficient in PowerPoint Outlook, Word
• Familiarity of VPP (Siebel) preferred
• Analytical thinking/skills required
• Excellent with Excel and Power Point Reports
• Ability to act independently on routine assignments or projects
• Ability to plan, organize and multi-task to complete assignments in an efficient manner
• Ability to communicate professionally, both oral and written
• Ability to pay attention to details and perform at a high-level accuracy
• Ability to work independently and with a team
• Strong mathematical skills to help collect, measure, organize and analyse data
• Proficiency in statistics and statistical packages (Excel)
• Problem-solving skills
• Accuracy and attention to detail
• Team-working skills
• Verbal and Written communication skills
• Proven working experience in data analysis
• Demonstrated skills and proven experience in administration and sales support preferable

BEHAVIOURAL COMPETENCIES

• Is passionate about their work, exudes a positive attitude that makes customers want to interact with them, and always is looking for solutions that consider the customer and the company to create win-win outcomes
• Sales driven giving excellent sales support to team members
• Acts in a manner consistent with the Company vision; behaves in a professional and ethical manner in all cases, and is a strong partner and team member seeking opportunities to contribute to overall team and Company success
• Is intrinsically motivated
• Team player

KEY PERFORMANCE AREAS:

OPERATIONAL EXCELLENCE             

• Working with Business Director, Sales Managers to identify process improvement opportunities, propose system modifications to reporting
• Preparing final analysis reports for internal client and external client to understand the data-analysis, enabling them to take important decisions based on various facts and trends of Sales and Activity in the regions
• Provide weekly status reports to the management team on all sales projects
• Monitor project progress and performance

FINANCIAL              

• Generate monthly commission cycle reports
• Ensure that all sales opportunities are swiftly closed – orders that are sitting on vetting referred, vetting declined, awaiting customer approval are converted to approved status
• Stock control & Asset control (uniforms, promotional material & devices)
• Ensure that sales cost per acquisition of all sales channels are maintained as per acceptable standard

PROCESSES          

• Preparing reports for management stating trends, patterns, and predictions using relevant output
• KPA- LOGISTICS
• Sales forecasting
• Follows company policies and practices as well as client HSE rules & regulations

ORGANISATION           

• Work with internal departments to optimise internal and external resource allocation and utilisation.
• Understands the Client corporate culture and vision

REPORTING

• Generate sales reports from sales data files received from the client (Microsoft Excel)
• Using statistical tools to identify, analyze, and interpret patterns and trends in data sets that could be helpful for the diagnosis and prediction for sales per region and sales team direction