Analytics & BI Engineer: Dashboards, ETL & DW

Digital Planet; Sandton; Hybrid; ZAR 420,000 - 720,000; Full time

Job summary

Digital Planet is seeking an Analytics / BI Developer to deliver reporting and build the data layer underneath it. The role combines report and dashboard delivery with hands-on data engineering across the data warehouse and ETL estate, working within established design patterns.

Responsibilities include maintaining reports, validating data quality, and collaborating with stakeholders to derive insights from data.

Qualifications

• Degree or equivalent qualification in computer science, information systems, statistics, mathematics or similar.
• 2–3 years of experience across reporting, analytics and data engineering.
• Strong SQL, including complex queries, views, stored procedures and performance tuning.
• Hands-on experience with an ETL or orchestration tool, ideally Azure Data Factory.
• Hands-on experience building reports and dashboards in a mainstream BI tool.
• Understanding of data warehouse modelling concepts, including dimensional models.

Responsibilities

• Build, maintain and improve reports and dashboards for business stakeholders, delivering output that is accurate, consistent, and on time.
• Understand reporting requests properly before building, clarifying the underlying business question and challenging requirements where needed.
• Own the quality of the reporting delivered, including consistent definitions and metrics across reports.
• Develop and maintain the reporting layer of the data warehouse, including the views, data models and data preparation that reports depend on.
• Monitor ETL pipelines and warehouse loads, and troubleshoot and resolve pipeline failures and data issues, escalating where the cause falls outside established patterns.
• Make routine changes to ETL pipelines and the data warehouse, such as new fields, extended loads and new tables, following established design patterns and within the change authority granted.
• Identify data quality issues early, and resolve or elevate them before they reach the business.
• Document reports, data models, pipelines and changes as part of everyday work, reducing single-person dependency on the data estate.
• Provide day-to-day technical guidance and mentorship to the Junior Data Analyst.
• Engage directly with internal stakeholders on reporting needs, and with vendors and suppliers where a data or reporting requirement calls for it.
• Develop over time from report delivery into interpretation and insight: investigating why results move, identifying trends and raising findings.

Skills

SQL proficiency

Data engineering

Stakeholder communication

Education

Degree in computer science / information systems / statistics / mathematics or equivalent

Tools

Azure Data Factory

Exasol

Yellowfin BI

SQL Server

Azure Logic Apps

Job description

Digital Planet is seeking an Analytics / BI Developer to deliver reporting and build the data layer underneath it. The role combines report and dashboard delivery with hands-on data engineering across the data warehouse and ETL estate, working within established design patterns.

Responsibilities include maintaining reports, validating data quality, and collaborating with stakeholders to derive insights from data.