CorporateOpen until filled

Marketing Analyst (Sql Requirement)

South Africa, NationalPermanentICT

About this role

About the Role

Confluent is South Africa's largest multi-award-winning debt management company.
We're looking for a Data Analyst in the Marketing Operations space who gets under the hood of campaign data Utilise SQL and other analytical tools to turn raw data into clear insights on response and conversion rates.

This role is specifically focused on Direct Marketing performance where our goal is driving high-quality leads.
You won’t just be building and maintaining reports, you’ll be able to drive decisions, give ideas for new campaigns/target audiences and actually see the impact of your data-driven decisions.

What You'll Do
  • Channel reporting: build and maintain Power BI dashboards tracking conversion rate (conv%), CPS, CPL, and quality tiers across several channels.
  • Budget vs actuals: track monthly spend and output against plan; identify variances early and frame the 'so what' clearly for channel leads and Marketing Ops leadership.
  • Risk and quality scoring: incorporate risk score bands and income band quality tiers into performance views to ensure lead quality, not just volume, sits at the heart of channel decisions.
  • SQL-powered reporting pipelines: write and optimise queries against our data warehouse that power recurring reports and answer ad-hoc questions from channel owners at speed.
  • Cross-functional collaboration: work closely with Data Engineering, Data Science, and business partners to build on our data platform and translate analytical output into decisions people can act on.
  • Manage campaigns: adjust sending strategies; or target criteria to optimise campaign spend and improve profitability.
  • Automate processes: reduce manual and tedious operational functions through clever automation.
What We're Looking For
  • 1-2 years' experience as a BI Analyst, Marketing Analyst, Data Analyst, or similar, ideally with direct marketing or acquisition channel exposure.
  • Strong SQL, you can write, optimise, and debug complex queries.
  • Solid Power BI experience building dashboards and reports people rely on daily (Tableau or Looker also considered).
  • Strong attention to detail.
  • A numerate degree, Mathematics, Statistics, Data Science, Information Systems, or similar.
  • Sharp analytical thinking with the ability to frame ambiguous problems, structure an analysis, and give clear recommendations.
Nice to Have
  • Experience in financial services, lending, or a comparable regulated acquisition environment.
  • DAX experience and Power BI data modelling beyond drag-and-drop visuals.
  • Familiarity with campaign attribution, contact strategy, or response modelling in a direct marketing context.
  • Exposure to Microsoft Fabric
Why Confluent
  • Work that matters, we help South Africans get out of difficult financial situations.
  • Leaders who are experts and actually share what they know. Good ideas get heard regardless of rank.
  • Medical aid and retirement annuity.
  • Half day off on your birthday.
  • Funded further study, where it fits the role.
  • Healthy Together wellness campaigns through the year.
  • Real internal mobility, sideways and upwards, if you want it.
  • A vibrant Pinelands office with easy access to the surrounding area.

Other roles you might like