Summary
Overview
Work History
Education
Skills
Interests
Timeline
Generic
Aubrey Baloi

Aubrey Baloi

Senior Tech Engineer
Meyerton

Summary

Highly motivated Data and Business Intelligence professional with over 6 years of experience in various banking segments within leading South African banks. Possessing a solid foundation in Finance, combined with strong analytical and problem-solving skills that facilitate effective collaboration with business stakeholders to define requirements, design data models, and deliver executive-level reporting in Cloud services. Demonstrated success in migrating on-premise reporting to cloud-based platforms, rewriting legacy stored procedures, and creating comprehensive documentation to support development teams for seamless project execution. Passionate about data analytics and engineering, particularly within banking credit, thriving in environments focused on optimizing processes, enhancing data reliability, and empowering decision-making through high-quality data solutions.

Overview

7
7
years of professional experience

Work History

Senior Tech Engineer

Monocle Solutions
01.2025 - Current
  • Partnered with business stakeholders to define requirements and translate them into data models and executive-level reporting metrics within AWS Redshift.
  • Designed and documented business requirements and data specifications, ensuring alignment with strategic objectives.
  • Developed and optimized stored procedures and SQL scripts to build and maintain data metrics for senior executive dashboards.
  • Led post-deployment processes, including data quality validation, testing, and ongoing monitoring, to ensure accuracy and reliability.
  • Utilized a range of tools, including AWS Redshift, SQL, GitHub, Control-M, Apache Airflow, and OpenDI, to deliver scalable and efficient data solutions.

Manager

Monocle Solutions
01.2024 - Current
  • Led the migration of downstream reports from on-premise servers to AWS cloud services, ensuring scalability, reliability, and improved performance.
  • Analyzed and rewrote legacy stored procedures by mapping them to new cloud-based data assets (schemas, tables, and fields).
  • Created detailed Business Requirement Documents (BRDs) and source-to-target mapping documents to guide development and ensure accuracy.
  • Collaborated closely with data engineers to support development and deployment, providing clear documentation and technical guidance.
  • Conducted post-deployment testing and validation to confirm data accuracy, functionality, and compliance with business requirements.

Consultant

Monocle Solutions
07.2023 - 12.2023
  • WeBuyCars Leads Report Large, Capitec Bank
  • Role: Business Intelligence Business Analyst (BIBA)
  • Business Knowledge: Data Analysis, BA Reporting
  • Technical Skills: Microsoft Excel, Microsoft SQL Server, AWS Redshift

Consultant

Monocle Solutions
04.2023 - 06.2023
  • Daily Purpose Report Migration, Capitec Bank
  • Role: Business Intelligence Business Analyst (BIBA)
  • Business Knowledge: Data Analysis, BA Reporting
  • Technical Skills: Microsoft Excel, Microsoft SQL Server, AWS Redshift

Consultant

Monocle Solutions
07.2022 - 03.2023
  • Access Facility Behaviour Score, Capitec Bank
  • Role: Business Intelligence Business Analyst (BIBA)
  • Business Knowledge: Data Analysis, Credit Scoring
  • Technical Skills: Microsoft Excel, Microsoft SQL Server, AWS Redshift, PySpark

Consultant

Monocle Solutions
01.2022 - 06.2022
  • Group RDARR Compliance, Capitec Bank
  • Role: Business Intelligence Business Analyst (BIBA)
  • Business Knowledge: BCBS 239 - RDARR
  • Technical Skills: Microsoft Excel, Microsoft SQL Server

Consultant

Monocle Solutions
09.2021 - 12.2021
  • RDARR Governance and FRTB, ABSA Group
  • Role: Business Analyst
  • Business Knowledge: Data Lineage Enhancement
  • Technical Skills: Voltron, Microsoft Excel

Analyst

Monocle Solutions
04.2021 - 09.2021
  • Strategic Assurance, ABSA Group
  • Role: Data Analyst
  • Business Knowledge: Data Migration
  • Technical Skills: Microsoft Excel, Highond

Analyst

Monocle Solutions
12.2020 - 03.2021
  • Data Inventory, ABSA Group
  • Role: Data Analyst
  • Business Knowledge: Data Lineage Enhancement
  • Technical Skills: Voltron, Microsoft Excel

Analyst

Monocle Solutions
01.2019 - 11.2020
  • Integrated Risk Management, ABSA Group
  • Role: Data Analyst
  • Business Knowledge: Data Migration
  • Technical Skills: Microsoft Excel, SQL, Teradata, SAS

Financial Administrator

Wesbank
05.2018 - 12.2018
  • Client Operations
  • Role: Financial Administrator
  • Business Knowledge: Customer Information Systems
  • Technical Skills: Microsoft Excel, Hogan Banking System

Education

Bachelor of Business Science - Finance

University of Cape Town
04-2018

Skills

DevOps practices

Interests

Running, Carpentry, Music (Guitarist), Golf, Hiking, Farming

Timeline

Senior Tech Engineer

Monocle Solutions
01.2025 - Current

Manager

Monocle Solutions
01.2024 - Current

Consultant

Monocle Solutions
07.2023 - 12.2023

Consultant

Monocle Solutions
04.2023 - 06.2023

Consultant

Monocle Solutions
07.2022 - 03.2023

Consultant

Monocle Solutions
01.2022 - 06.2022

Consultant

Monocle Solutions
09.2021 - 12.2021

Analyst

Monocle Solutions
04.2021 - 09.2021

Analyst

Monocle Solutions
12.2020 - 03.2021

Analyst

Monocle Solutions
01.2019 - 11.2020

Financial Administrator

Wesbank
05.2018 - 12.2018

Bachelor of Business Science - Finance

University of Cape Town
Aubrey BaloiSenior Tech Engineer