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