Data Analyst

Hire Resolve; Cape Town; On-site; ZAR 350,000 - 500,000; Full time

Job summary

A recruitment consultancy is seeking a Data Analyst to join their team in Cape Town, focusing on manufacturing operations. The role involves providing sales reporting, market intelligence, and insights to drive growth. Candidates should have experience managing SQL databases and using data visualization tools like Power BI. A degree in a relevant field or extensive experience is required. Strong communication skills and attention to detail are essential, along with the ability to work independently in a team environment.

Qualifications

• Experience in managing a SQL database and producing sales reports.
• Able to use statistical techniques and data visualisation tools to explore and analyse large datasets.
• Hands-on experience with data visualisation tools such as Power BI and SSRS.
• SQL coding skills.
• Able to identify business problems and formulate data-driven solutions.
• Able to collaborate with cross-functional teams for analytical support.
• Degree or diploma in a relevant field or 6+ years of relevant experience.
• Enthusiastic, self-motivated, and able to work independently.
• Excellent business communication skills and attention to detail.

Responsibilities

• Deliver meaningful sales, market, and business intelligence.
• Establish automated tools to extract key metrics.
• Track sales performance and market share trends.
• Ensure data accuracy and integrity in analysis.
• Gather and clean data from multiple sources.
• Present analysis findings to stakeholders clearly.
• Interrogate data to extract insights for sales activities, marketing plans, and product propositions.
• Provide support to Marketing and Sales with key account pitches and trends.

Skills

SQL

Data analysis

Data visualization

Problem-solving

Collaboration

English communication

Education

Degree or diploma in a relevant field

Higher Certificate with 6+ years experience

Tools

Power BI

Pivot

SSRS/SSAS

Excel

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 & 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 visualisation 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 in a relevant field (like Engineering, Information Systems, Computer Science, or Science) or 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 [e-mail].

If you meet the above requirements we will contact you within 3 working days.