Senior Data Analyst

Ignition Group; Cape Town; On-site; ZAR 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Senior Data Analyst to drive data-driven decision-making processes. In this pivotal role, you will leverage advanced SQL, Google Analytics 4, and data visualization tools to optimize digital products and enhance user experiences. Collaborating with cross-functional teams, you will analyze large volumes of data, generate actionable insights, and present critical business metrics to stakeholders. This position offers a dynamic environment where your analytical skills will directly impact business performance and user engagement. If you are passionate about data and eager to make a difference, this opportunity is perfect for you.

Qualifications

• 5-8 years of experience in data, digital, and business analytics.
• Expertise in advanced SQL and Google Analytics 4 for data insights.
• Strong analytical skills to translate data into actionable insights.

Responsibilities

• Analyze web and CRM data to generate actionable insights for marketing.
• Build and maintain dashboards for automated reporting on key KPIs.
• Collaborate with cross-functional teams to align analytics with business goals.

Skills

Advanced SQL

Google Analytics 4 (GA4)

Google Tag Manager (GTM)

Looker Studio

Microsoft Power BI

Data Visualization

A/B Testing

Data Wrangling

Python/R

Education

Bachelor's degree in Computer Science

Bachelor's degree in Statistics

Bachelor's degree in Mathematics

Bachelor's degree in Economics

Tools

Google Analytics 4 (GA4)

Google Tag Manager (GTM)

Looker Studio

Microsoft Power BI

Firebase

Optimizely

Snowflake

Azure Databricks

Job description

Drive data-driven decision-making processes to 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.

Key roles and responsibilities:

1. Data Analysis and Insights Generation:

• Analyze 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 analyses on user behavior, engagement trends, and conversion metrics across digital platforms.
• Present and analyze 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.
• Support tools to 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.

Requirements:

Knowledge, Skills, and Attributes:

• Expertise in advanced SQL for data extraction, transformation, and performance optimization.
• Strong proficiency in Google Analytics 4 (GA4), GTM, Looker Studio, and Microsoft Power BI.
• Hands-on experience with schema design for GA4 custom events and data layer implementation.
• Knowledge of A/B testing methodologies and platforms such as Firebase, Optimizely, or similar.
• Familiarity with Snowflake, Azure Databricks, and Python/R for advanced analytics is a plus.
• Proficiency in Microsoft Excel, Google Sheets, and data visualization tools.
• Excellent analytical skills with a proven ability to translate complex data sets into meaningful insights.
• Strong business acumen and ability to communicate findings to both technical and non-technical stakeholders.

Education:

• Bachelor's degree in Computer Science, Statistics, Mathematics, Economics, or a related field.

Experience:

• 5-8 years of proven experience in data, digital, and business analytics.
• Experience in website and mobile app analytics, including GA4 custom event tracking and reporting.
• Experience writing Schema Requirement Definitions (SDR) for GA4 events.
• Advantageous: Experience with Snowflake, Azure Databricks, Firebase, A/B testing, Optimizely, GTM, and Python/R.

Position Details:

• Senior IC
• Permanent, Market Related, EE Position
• Location: Cape Town CBD