Reporting
Purpose of the Post
The Reporting Analyst will manage data extraction, analysis, and report generation for the Pricing Intelligence department. This role focuses on maintaining and updating complex pricing models and performance reports. The ideal candidate possesses advanced Excel capabilities and translates raw data into actionable insights. They must effectively communicate findings to internal teams and address client inquiries directly. This is a permanent position based in Craighall, JHB. Start as soon as possible.
Roles & Responsibilities
Data Analysis & Reporting
- Generate daily, weekly, and monthly pricing performance reports.
- Maintain and audit existing Excel-based reporting templates for accuracy.
- Identify pricing trends and variances within promotional print campaigns.
- Ensure data integrity by reconciling multiple internal data sources.
Stakeholder & Client Communication
- Collaborate with internal team leaders to understand reporting requirements.
- Resolve client queries regarding report metrics, methodologies, and outcomes.
- Provide clear, professional explanations of complex data to non-technical clients.
Operations & Deadline Management
- Deliver all standard and ad-hoc reports within strict, tight deadlines.
- Prioritize multiple competing requests in a fast-paced environment.
- Streamline existing reporting workflows to improve turnaround times.
Eligibility Criteria
Technical Skills (Non-Negotiable)
- Advanced Excel proficiency Master nested logical statements, VLOOKUP/XLOOKUP, Index/Match, Pivot Tables, IF statements, Conditional Formatting etc.
- Experience handling large datasets and building functional data models in Excel.
- Familiarity with data visualization best practices.
- Knowledge of VBA/Macros or Power Query is an advantage but not required.
Soft Skills & Competencies
- Strong time management skills to consistently meet rigid deadlines.
- Excellent verbal and written communication skills for client-facing tasks.
- High attention to detail to spot errors before reports are distributed.
- Interpersonal skills to build strong relationships with internal team leaders.
Education & Experience
- Degree/Diploma in Finance, Economics, Statistics, Data Analytics, or a related field.
- 1-2 years of experience
