Marketing Analyst (George Onsite)

DataFin; Wes-Kaap; On-site; ZAR 400,000 - 600,000; Full time

Job summary

A marketing analytics firm in South Africa seeks a Marketing Analyst to develop actionable insights through data analysis and reporting. The ideal candidate will have proven experience with Power BI, strong skills in DAX and M-code, and be able to integrate multi-channel marketing data into comprehensive dashboards. You will collaborate in a fast-paced team to support marketing objectives and deliver clear data-driven recommendations.

Qualifications

• Proven experience with Power BI and advanced use of DAX and M-code.
• Strong competency in Excel for data manipulation and analysis.
• Working knowledge of Google Analytics 4 and data integration.

Responsibilities

• Develop and enhance marketing analytics dashboards using Power BI.
• Write and optimize DAX and M-code queries for data models.
• Integrate and analyze marketing data from various sources.
• Create acquisition models and performance reports.
• Communicate complex findings and recommendations to stakeholders.

Skills

Power BI

DAX

M-code

Excel

Google Analytics 4

Data analysis

Python

Tools

Power BI

Qlik

Job description

Overview

ENVIRONMENT: DELIVER actionable marketing insights through data analysis, reporting, and predictive modelling as the next Marketing Analyst sought by our client with a mission to redefine how insurance and technology work together. Utilising these insights, you should enable the business to optimise marketing channel mixes, reduce acquisition costs, and meet sales objectives across digital and operational areas. Applicants will require proven experience with Power BI, including advanced use of DAX and M-code for data modelling and reporting, strong competency in Excel for data manipulation and analysis & working knowledge of Google Analytics 4 and familiarity with integrating multi-channel marketing data into unified dashboards.

Duties

• Develop, maintain, and enhance marketing analytics and operational performance dashboards using Power BI, Qlik, and Excel.
• Write and optimise DAX and M-code queries to build robust data models and automate data transformations. Python proficiency is a plus for advanced analytics and automation. Or via other data analytics tools and languages, which will allow report/ dashboard distribution.
• Integrate and analyse marketing data from diverse sources, including Google Analytics 4, Facebook Ads, Google Ads, TikTok, Bing, HubSpot, internal CRM, and other third-party platforms.
• Create acquisition models and performance reports that measure marketing effectiveness, uncover trends and seasonality, and predict future outcomes.
• Ensure best practices in data analysis to deliver accurate, consistent, and reliable insights.
• Communicate complex analytical findings and data-driven recommendations clearly to Marketing teams and stakeholders.
• Collaborate effectively within a fast-paced, data-driven team culture focused on simplicity, delivering “soft landings” for customers and colleagues alike.
• Support the identification of optimal marketing channel mixes to achieve acquisition cost targets and sales objectives in digital and operational domains.
• Share daily reports/ dashboards with the relevant stakeholders.

Requirements

• Proven experience with Power BI, including advanced use of DAX and M-code for data modelling and reporting. Or another BI tool and language.
• Strong competency in Excel for data manipulation and analysis.
• Working knowledge of Google Analytics 4 and familiarity with integrating multi-channel marketing data into unified dashboards.
• Ability to handle and combine data from multiple third-party marketing sources confidently.
• Analytical thinker with experience building predictive models and identifying key trends in marketing data.

Highly Desirable –

• Experience with Qlik or similar BI platforms.

Attributes

• Excellent communication skills, with the ability to present data insights clearly and engage effectively within a collaborative team environment.
• Demonstrated alignment with a fast-paced, simplicity-focused, and data-driven company culture.