Data Analytics Engineer

Red & Yellow Creative School of Business is South Africa’s leading authority in marketing, communication and design education. We have the mission to unlock creative thinking, to build brilliant careers and organizations using Commercial Logic and Creative Magic. Our mandate, as educators, is to prepare students for career success in the future, not the past. This single-minded purpose is why we exist, and what continues to drive and inspire us 30+ years later.

We are looking for talented people who are fun, dynamic and passionate about all things education and that enjoy working with people – students, lecturers and staff to join various teams across our fast-growing company.

Job Summary:

We are looking for a data-driven professional who can design and optimise our data infrastructure, deliver actionable insights and leverage CRM data to drive smarter decision-making. The Data Analytics Engineer (CRM Integration) will manage and structure the institution’s data assets, build and maintain pipelines, and make data more accessible across the organisation. A key focus will be integrating Salesforce CRM data into our analytics environment to improve operational reporting, marketing effectiveness, and student success tracking. There will be a strong requirement to

collaborate across teams to ensure data is accurate, accessible, and actionable.

Key Responsibilities:

• Implement and manage a data catalogue (e.g., DBT or similar).
• Maintain an up-to-date inventory of datasets, metadata, and relationships.
• Establish and enforce data documentation standards.
• Create and maintain ERDs for internal systems, including CRM data models.
• Translate business processes into clear, efficient data structures.
• Develop and maintain ETL workflows (preferably with Apache NiFi).
• Connect and integrate multiple data sources: databases, APIs, third-party platforms, Salesforce CRM.
• Automate data flows for marketing, sales, and academic reporting.

CRM Data

• Extract, transform, and analyse Salesforce CRM data for operational and strategic use.
• Work closely with marketing and sales teams to optimise lead and enrolment tracking.
• Ensure CRM data is integrated into Power BI dashboards and organisational reporting.

Reporting & Analytics

• Build and maintain dashboards in Power BI for executives and operational teams.
• Ensure data quality, consistency, and accuracy across reports.
• Provide insights and recommendations based on data trends.

Qualifications and Experience:

• Bachelor’s degree in information systems, Data Science, Computer Science, or related field
• Minimum 3 years’ experience in data engineering, analytics, or BI.
• Experience integrating CRM data into analytics workflows