Commercial Analyst

The Legends Agency; Cape Town; On-site; ZAR 250,000 - 350,000; Full time

Job summary

Join a dynamic merchandising team in Cape Town as a Merchandising Administrator - Offsite. This exciting role focuses on optimizing email performance and employing data-driven strategies to enhance revenue while providing essential administrative support. Ideal candidates will possess strong analytical abilities and have the capacity to make impactful business decisions based on data insights.

Benefits

25 days holiday + 8 bank holidays

Free fruit

Weekly breakfast feasts

Wellness Wednesdays

Thirsty Thursdays

Games area

Perkbox access

Monthly social events

Cycle Scheme & Season Ticket Loan

Auto-enrolment pension scheme

Qualifications

• Proficiency in Microsoft tools, particularly Excel.
• Experience in SQL and Power BI is useful.
• Ability to analyze data sets and draw logical conclusions.

Responsibilities

• Assess deals launched on the website against KPIs.
• Plan daily email orders ensuring good mix of categories.
• Build exposure plans and ensure no clashes in email orders.

Skills

Analytical mindset

Attention to detail

Communication skills

Commercial acumen

Ability to prioritize and multitask

Education

Degree or relevant industry experience

Tools

Microsoft tools (Excel)

SQL

Power BI

Job description

Job Title:Merchandising Administrator - Offsite
' Reports to: Head of Merchandising
Team: Merchandising

"Century City Cape Town So only residence of Cape Town May Apply."

Salary Range: Competitive

Purpose of the Role

The Merchandising team at our client is responsible for compiling the business online shop window, using both qualitative and quantitative data to select the most appropriate deals to display on-site. By assessing which offerings deliver the most revenue for the company in the medium to long term, the Merchandising team provides insights to Sales teams and Management to meet changing consumer preferences and adapt to seasonal changes.

The Merchandising Administrator - Offsite plays a crucial role in ensuring email performance is optimised to maximise profit potential while supporting administrative responsibilities required to get a deal live from the point of signing.

Main Responsibilities and Duties

• Assesses deals launched on the website against set KPIs.
• Analyses location and tier performance of emails to make strategic decisions.
• Builds exposure strategies for different tiers and locations to maximise visitation and revenue on key deals.
• Plans daily email orders, ensuring a good mix of key categories, seasonal focuses, and avoiding deal fatigue.
• Builds exposure plans and schedules paid slots for generic deals to meet merchant requirements.
• ️ Balances deal exposure offsite, ensuring revenue is maximised while keeping content engaging.
• Ensures there are no clashes between email orders for different regions.
• Selects deals for web and app push notifications.
• Works with the Product team to automate and innovate to maximise email performance.
• Assesses subscriber base and makes recommendations on email strategy.
• Uses audience builder tools to target suitable customers for deals.
• Works closely with CRM using A/B testing to improve email performance.
• Provides feedback to Sales and Analysis teams for deal gaps.
• Monitors personalisation performance and suggests innovations.

Soft Skills Required

️ Ability to prioritise and multitask, managing ad-hoc data requests while handling ongoing tasks/projects.
️ Strong analytical mindset.
️ High attention to detail.
️ Excellent communication skills.
️ Strong commercial acumen.
️ Ability to work with diverse working styles and cultures.

Degree or relevant industry experience.
Proficiency in Microsoft tools (Excel, etc.).
Ability to analyse data sets and draw logical conclusions.
Experience in SQL and Power BI (useful but not essential).

Company Benefits

25 days holiday + 8 bank holidays (option to add 5 extra days)
Free fruit to fuel your day
Weekly breakfast feasts every Wednesday
️ Wellness Wednesdays activities
Thirsty Thursdays drinks and snack trolley!
Games area for some friendly competition
️ Perkbox access discounts and rewards across the UK
Monthly social events All Bar!
Legendary company parties twice a year
Cycle Scheme & Season Ticket Loan
Auto-enrolment pension scheme (up to 10% employer contribution)
Enhanced Employee Assistance Program for confidential support
Eye Care Vouchers
️ Store discounts across the website (including travel deals!)
Smart-casual dress code every day!

If you are looking for an exciting role in a dynamic merchandising team where you can make data-driven decisions and help shape marketing strategies, this could be the perfect opportunity for you! Join our client and become part of something amazing!