Summary
Overview
Work History
Skills
Languages
Websites, Portfolios and Profiles
Projects
Custom Section
Timeline
Generic

Nikki Mackillican

Benoni

Summary

Business Intelligence Developer and Team Lead with 23+ years of experience designing and implementing enterprise data solutions. Proven expertise in Microsoft BI stack, Azure Data Factory, Power BI, Microsoft Fabric and data warehouse architecture. Skilled in leading teams, mentoring graduates, and delivering innovative analytics solutions across industries including mining, healthcare, government, and finance.

Overview

8
8
years of professional experience

Work History

Business Intelligence Consultant

Openbox Software
Cape Town
09.2025 - 03.2026
  • Worked with data team members to guarantee consistency in metrics definitions, implementation of analysis best practices and use of data pipelines.
  • Communicated with clients to discuss project details, review deliverables and receive sign-off before implementation.
  • Supported user training sessions, simplifying complex technical information into clear and understandable advice.
  • Established a feedback loop with end-users to refine BI solutions, enhancing user satisfaction and tool effectiveness.
  • Created business intelligence models to identify opportunities for growth.
  • Optimised dashboards for senior management, offering clear visualisations of complex data sets for strategic planning.
  • Corresponded with stakeholders during project lifecycle, providing regular status updates and milestones.
  • Facilitated data-driven decision-making by presenting insightful reports and recommendations to executive leadership.
  • Customised BI solutions to meet specific client needs, enhancing customer satisfaction.

Principal BI Developer & Team Lead

NTT Data
Sandton
07.2019 - 08.2025
  • Led technical projects for clients including RCL, Rainbow Chickens, Rio Tinto, and Sanlam.
  • Designed and implemented enterprise data warehouses and BI systems on Azure.
  • Delivered staff and client training on Kimball methodology and Power BI.
  • Mentored new employees and graduates, fostering technical growth.
  • Formerly Dimension Data

Senior BI Developer Team Lead

Dimension Data
09.2018 - 06.2019
  • Directed BI projects for IMF, Tenke Mining, Botswana Housing Corporation, and Department of Tourism.
  • Designed and implemented enterprise data warehouses using Microsoft stack.
  • Provided training and mentorship on BI methodologies and tools.

Skills

  • Enterprise Data Warehouse Design & Implementation
  • Microsoft BI Stack (SQL Server, SSIS, SSAS, SSRS, Power BI, DAX, M Query)
  • Microsoft Fabric , Sematic Models, Pipelines, medallion architecture
  • Azure Data Factory & Cloud Migration
  • OLAP & Tabular Cube Development
  • ETL/ELT Processes & Data Modeling
  • Team Leadership, Mentorship & Training
  • Stakeholder Engagement & Business Analysis

Languages

English

Websites, Portfolios and Profiles

LinkedIn.com/in/nikki

Projects

  • Power BI Tenant Migration, Technical Lead, Global Analytics Company, 2023
  • Group Risk BI Development, Technical Lead, Insurance Business, 2022-2023
  • Mining Data Warehouse, Architect, Global Mining Company, 2021-2022
  • Government BI Solutions, Technical Lead, Department of Tourism & Botswana Government, 2019-2020

Custom Section

  • DAMA Practitioner in Data Management, 2024
  • AZ900 Azure Fundamentals, 2023
  • Analysing & Visualizing Data with Power BI, 2018
  • Microsoft Certified Professional, G859‑5332

Timeline

Business Intelligence Consultant

Openbox Software
09.2025 - 03.2026

Principal BI Developer & Team Lead

NTT Data
07.2019 - 08.2025

Senior BI Developer Team Lead

Dimension Data
09.2018 - 06.2019
Nikki Mackillican