BI/ Analytics Engineer

Ovations Technologies; Johannesburg; Hybrid; ZAR 550,000 - 900,000; Full time

Job summary

Ovations Technologies is seeking a BI / Analytics Engineer to design and build a scalable reporting layer for a new Sustainability Management System. You will translate raw platform data into decision-ready dashboards used by site operators and C-suite executives.

Key responsibilities include dashboards, executive scorecards, data modelling with canonical models, and governance to ensure repeatable, audit-ready reporting. The role supports remote/hybrid work and future Lakehouse portability.

Qualifications

• Experience building decision-ready dashboards for operators and executives.
• Strong SQL skills and ability to design canonical data models and star schemas.
• Proven capability to model data from SaaS APIs and flat exports with governance in mind.

Responsibilities

• Dashboard development of leading and lagging KPIs using Power BI or Tableau.
• Design executive scorecards and operational views for frontline teams.
• Collaborate with Data Engineers on data models, lineage, and refresh schedules.
• Structure reporting for portability toward a Lakehouse architecture.
• Partner with Health, Environment and Social Performance leads to resolve data issues and standardize KPIs.
• Maintain governance with documentation of logic and audit readiness.

Skills

Power BI

Tableau

SQL

Data modelling

Data governance

Executive reporting

Tools

Power BI

Tableau

Job description

Role Title: BI / Analytics Engineer — Sustainability Reporting

Engagement Type: Contract / Fixed-Term (6–12 months) | Location: Remote / Hybrid

About the Role

We are looking for a BI / Analytics Engineer to design and build an adaptable reporting layer for a new enterprise Sustainability Management System (SMS). You will convert raw platform data into decision-ready dashboards used by site operators and C-suite executives (ExCo/SteerCo).

Key Responsibilities

• Dashboard Development: Build leading-indicator (control verification, safety routines) and lagging-metric (TRIFR, LTIFR) dashboards using Power BI or Tableau.
• Executive & Site Views: Design concise, "at-a-glance" executive scorecards alongside detailed operational views for frontline site teams.
• Data Modelling & Governance: Work with Data Engineers to build canonical data models (lookups, mapping tables) and document report logic, data lineage, and refresh schedules.
• Portable Architecture: Structure the reporting layer for portability to support a future transition to a Lakehouse data platform.
• Stakeholder Support: Partner with Health, Environment, and Social Performance leads to resolve data discrepancies and standardize KPIs.
• BI Tooling: Advanced expertise in Power BI and/or Tableau.
• Data Modelling & SQL: Strong SQL skills with experience building canonical staging models and star schemas.
• SaaS Integration: Experience extracting and modelling data from SaaS platform APIs and flat exports.
• Audience Adaptability: Proven ability to tailor dashboard layouts for both operational teams and executive leadership.
• Governance Discipline: Strict habits around metric standardization, logic documentation, and audit readiness.