Back to Company jobs
Data Analyst
Cape Town, Western Cape
Permanent
Apply
Posted 18 November 2024

Job Details

Job Description

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 [email protected]

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.