Marketing Analyst (Sql Requirement)

Confluent; Wes-Kaap; On-site; ZAR 350,000 - 550,000; Full time

Benefits offered by this job

Medical aid

Retirement annuity

Half-day off on your birthday

Funded study

Wellness campaigns

Job summary

Confluent in Pinelands, South Africa, is hiring a Data Analyst in Marketing Operations to turn campaign data into clear insights using SQL and BI dashboards. You’ll influence direct marketing decisions and drive high-quality leads.

You’ll build and maintain Power BI reports, collaborate with Data Engineering and Data Science, and help optimise campaigns by translating analytics into actions with impact.

Qualifications

• 1–2 years experience as a BI/Marketing/Data Analyst or similar.
• Strong SQL: write, optimise and debug complex queries.
• Solid Power BI experience building dashboards/reports.
• Numerate degree in Mathematics/Statistics/Data Science/IS.
• Analytical thinking with ability to frame problems and provide clear recommendations.

Responsibilities

• Channel reporting: build/maintain Power BI dashboards tracking conv rate, CPS, CPL, and quality tiers across channels.
• Budget vs actuals: track monthly spend vs plan and flag variances for leads/leadership.
• Incorporate risk bands and income band quality into performance views to prioritise lead quality.
• Write/optimise SQL queries powering recurring reports and ad-hoc questions from channel owners.
• Collaborate with Data Engineering/Science and business partners to enhance data platform and translate analytics into decisions.
• Manage campaigns: adjust sending strategies and targeting to optimise spend and profitability.
• Automate processes to reduce manual/tedious operations.

Skills

Strong SQL

Education

Bachelor's degree in a numerate field (Math/Stats/Data Science/IS)

Tools

Power BI

Tableau

Looker

Job description

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.