Cape Town: Data Analyst posted by Hire Resolve

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 *****@*****.co.za

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.