Marketing Data Analyst: SQL & Power BI for Campaigns

Confluent; Cape Town; On-site; ZAR 350,000 - 520,000; Full time

Benefits offered by this job

Medical aid and retirement annuity

Half day off on your birthday

Funded further study

Wellness campaigns

Internal mobility

Office in Pinelands

Job summary

Confluent, South Africa's leading debt management group, is seeking a Data Analyst in Marketing Operations. You’ll turn campaign data into actionable insights, build dashboards, and influence campaign decisions to drive high-quality leads.

You’ll collaborate with Data Eng and Data Science teams to optimise data platforms, while supporting cross-channel reporting and automation initiatives. This role is rooted in Direct Marketing performance with tangible business impact.

Qualifications

• 1–2 years in BI/Marketing/Data Analytics with direct marketing exposure.
• Proficient in SQL: write, optimise, and debug queries.
• Experience building dashboards in Power BI; Tableau/Looker is a plus.

Responsibilities

• Build and maintain Power BI dashboards tracking conversion rates, CPS, CPL, and quality tiers across channels.
• Track monthly spend vs plan; highlight variances with clear implications for channel leads.
• Incorporate risk and income band quality into performance views to prioritise lead quality.
• Write and optimise SQL-powered reporting pipelines powering recurring reports and ad-hoc requests.
• Collaborate with Data Eng, Data Science and business partners to translate analytics into decisions.
• Assist with campaign management and automate repetitive processes to improve efficiency.

Skills

Strong SQL

Analytical thinking

Attention to detail

Education

Numerate degree (Math/Stats/Data Science/IS)

Tools

Power BI

Tableau/Looker

DAX

Job description

Confluent, South Africa's leading debt management group, is seeking a Data Analyst in Marketing Operations. You’ll turn campaign data into actionable insights, build dashboards, and influence campaign decisions to drive high-quality leads.

You’ll collaborate with Data Eng and Data Science teams to optimise data platforms, while supporting cross-channel reporting and automation initiatives. This role is rooted in Direct Marketing performance with tangible business impact.