Job Summary
Hire Resolve's client is currently seeking a Data Analyst to join their team in manufacturing operations, based in Bellville. The candidate will provide teams with Sales Reporting (internal & external sales data), Market Intelligence (Category, Share & Competitor data) & Insights to leverage incremental growth opportunities, and to guide and influence strategic decision-making
Responsibilities:
Support the Regions through delivering meaningful & actionable Sales, Market and Business Intelligence- Establish automated specialist tools to extract key metrics and data to the business
- Deliver on ad-hoc, weekly, monthly and annual reporting & keep KPI Dashboards up to date whilst monitoring for notable changes
- Prepare, publish & highlight noteworthy trends
- Cross-reference data from the sales force, market studies (internal & external) and marketing in order to have a comprehensive overall understanding of the business
- Be the custodian of retailer supplier . Pull relevant sales data to inform performance and opportunities for growth
Be the Category Custodian & Deliver Category Insights
- Manage Category Data (e.g. Scanned Sales Data) - Be the domain expert for category data suppliers and tools
- Interrogate data to extract key insights to inform sales activities, marketing plans, production development and customer propositions
- Interrogate and communicate key competitor trends & NPD launches
- Ad-hoc analysis of sales out data
Provide support to Marketing and Sales with Key Account Sales Pitches and Marketing Trends/Categories
- Using Sales Intelligence & Category Insights to support Sales Teams and Marketing with sales pitches & provide NPD Trade Presenters/"Selling Stories" to facilitate sell-in
- Track sales performance & market share trends to establish traction in the marketplace, product performance, as well as understanding the impact of specific marketing activities
- Track sales and trends of new product launches to understand drivers to success or failure and rectify or build
- Respond to data-related queries and generate insights
Data ecosystem, Reporting and trends
- Data Quality and Integrity: Ensure data accuracy, consistency, and integrity throughout the analysis process. Identify and resolve data quality issues or inconsistencies.
- Data Collection and Cleaning: Gather data from various sources, including databases, spreadsheets, and APIs. Ensure the data is accurate, complete and properly formatted.
- Reporting and Presentation: Present analysis findings to stakeholders clearly and concisely using visualisations, dashboards and reports. Communicate data concepts in a way that is easily understandable to non-technical audiences.
- Continuous Learning and Development: Stay updated with industry trends, emerging technologies, and new analytical techniques.
Minimum Requirements:
- Experience in managing a SQL database and producing sales reports
- Data Analysis: Able to use statistical techniques and data visualisation tools to explore and analyse large datasets.
- Hands-on experience with data visualization tools and/or business intelligence tools such as Pivot, PowerPivot, Power BI, SSRS/SSAS.
- SQL coding skills
- Problem-Solver: Able to identify business problems or challenges and formulate data-driven solutions.
- Collaboration: Able to collaborate with cross-functional teams to understand requirements and provide analytical support.
- Degree or diploma a relevant field (like Engineering, Information Systems, Computer Science, or Science) Alternatively, a Higher Certificate with 6+ years of relevant experience.
- Enthusiastic, Hard-working, self-motivated, passionate, can-do-will-do worker who can work independently.
- Excellent business communication skills, good attention to detail, including a good command of English (both written & spoken).
- Excellent knowledge MS Office (Excel, Word, Powerpoint)
Salary: Market-related
If you meet the above requirements and want to make a career-changing move, apply today by emailing your CV to itcareers@hireresolve.za.com
You can also connect with Daniel, Carmen and Gaby on LinkedIn or contact Hire Resolve
If you meet the above requirements we will contact you within 3 working days.