Senior Data Analyst

Ignition Group; Cape Town; On-site; ZAR 300 000 - 500 000; Full time

Job summary

A leading technology firm in Cape Town seeks a Data Analyst to drive data-driven decision-making and optimize digital products. Responsibilities include analyzing complex data sets, developing dashboards, and collaborating with cross-functional teams to generate insights that enhance user experience. The ideal candidate has strong SQL skills and experience with tools like Google Analytics 4 and Microsoft Power BI.

Qualifications

• Strong understanding of data analysis methodologies.
• Experience with advanced SQL for data querying.
• Proficiency in web analytics tools for digital insights.

Responsibilities

• Analyse large volumes of clickstream and CRM data.
• Perform data wrangling, cleansing, and transformation.
• Utilize GA4 and GTM for tracking and analyzing performance.

Skills

SQL

Web analytics

Google Analytics 4

Data visualization

Data manipulation

Tools

Google Tag Manager

Microsoft Power BI

Looker Studio

Job description

Overview

Primary purpose : Drive data-driven decision-making processes, optimize digital products, and enhance the overall user experience through comprehensive data analysis. Leverage web analytics, GA4 event tracking, and SQL-based insights to optimize business performance. Implement analytics solutions, manipulate data for in-depth insights, and create compelling visualizations for reporting and decision support.

Responsibilities

Data Analysis and Insights Generation

• Analyse large volumes of clickstream, web, and CRM data using advanced SQL and web analytics tools to generate actionable insights for product, marketing, and commercial teams.
• Conduct deep-dive analysis on user behaviour, engagement trends, and conversion metrics across digital platforms.
• Present and analyse critical business metrics for the monthly EXCO report and engage regularly with management to drive data-informed decisions.

Data Engineering and Manipulation

• Perform data wrangling, cleansing, and transformation to ensure accuracy and reliability in reporting.
• Handle unstructured data and integrate information from various sources, including GA4, SQL databases, and third-party APIs.
• Develop advanced data models to support predictive analytics and segmentation strategies.
• Define Schema Requirement Definitions (SDR) for GA4 custom events to ensure accurate event tracking and measurement.

Web and Digital Analytics

• Utilize Google Analytics 4 (GA4), Google Tag Manager (GTM), and Looker Studio to track and analyze website and app performance.
• Monitor and optimize web conversion funnels, user journeys, and engagement metrics across digital platforms.
• Supporttoolsto optimize user experience and digital product performance.
• Ensure effective tagging and tracking strategies for new feature releases and marketing campaigns.

Data Visualization and Reporting

• Build and maintain business performance dashboards for automated reporting on key KPIs using Google Looker Studio and Microsoft Power BI.
• Enhance funnel reporting for both buyer and seller journeys, enabling detailed e-commerce performance insights at the product level.
• Develop real-time data reporting frameworks for operational and strategic decision-making.

Collaboration and Stakeholder Communication

• Work closely with cross-functional teams (Product, Marketing, Technology, and Commercial) to align analytics efforts with business objectives.
• Act as the primary point of contact for data analytics initiatives, translating complex findings into actionable business recommendations.
• Provide training and mentorship to junior analysts on best practices in data analysis, web analytics, and reporting automation.