Beatka Spence
@beatkaspence
Data & Systems Analyst specialising in data quality, reconciliation, migration, automation and reporting, with 40+ years’ experience.
South AfricaWhat I'm looking for
I am a Data & Systems Analyst with 40+ years’ experience helping organisations turn messy, disparate data into structured, reliable information and practical business insights.
I specialise in data analysis, data quality, reconciliation, gap analysis, remediation, data migration, process improvement and reporting. I develop practical solutions using Excel (including VBA/Macros and Power Query), Power BI and SQL.
My experience spans financial services, consulting and transformation projects across multiple industries, including financial and regulatory reconciliation, master data validation, data cleansing, reporting automation and business process improvement.
I thrive in project-based roles where I can identify what isn’t working, understand the underlying data, implement practical improvements and leave clients with sustainable processes and frameworks they can maintain.
Data Chaos → Structured Data → Business Insights
Experience
Work history, roles, and key accomplishments
Data Migration Analyst
Adept Advisory
Dec 2025 - Jul 2026 (7 months)
Coordinated end-to-end master data validation activities supporting the migration from SAP ECC to SAP S/4HANA across multiple validation cycles. Designed and developed automated Excel VBA validation frameworks and reporting tools to improve efficiency and consistency.
Professional Development & Innovation
Adept Advisory
Sep 2025 - Jan 2026 (4 months)
Designed Excel-based automation solutions for AI innovation submissions, focusing on streamlining reporting and improving data preparation. Built advanced Excel models and dashboards, prepared demonstration datasets, and engineered AI prompts.
Data Analyst
Adept Advisory
Apr 2025 - Aug 2025 (4 months)
Supported IFRS 9 exposure reconciliation, ensuring data integrity and audit readiness. Partnered with finance and risk teams to analyse master data, trace issues, and resolve variances.
Data Analyst
MAC Consulting
Aug 2024 - Mar 2025 (7 months)
Translated and aligned multilingual item descriptions across SAP, Masterpiece, and OpenText systems. Improved data consistency and usability across global systems.
Business Analyst
Alexander Forbes
May 2023 - Oct 2023 (5 months)
Contributed to the development of a new financial advisor online portal. Produced business requirements documentation and process/data mapping.
Data Solutions Consultant
MAC Consulting
Apr 2021 - Aug 2023 (2 years 4 months)
Restored and enhanced Excel-based workforce planning Toolkit. Delivered training, troubleshooting, and improved system functionality.
Data Quality & Remediation Analyst
Alexander Forbes
Dec 2022 - Apr 2023 (4 months)
Conducted gap analysis of client data for individuals, trusts, and companies. Optimised risk rating model during SA grey-listing to reflect updated scoring logic.
Excel & Data Solutions Developer
Adept Advisory
Jan 2021 - Dec 2022 (1 year 11 months)
Automated customs payment tracker for BP to prevent SARS penalties. Semi-automated timesheet template for BP HR Payroll. Optimised MTN IFRS 16 lease reconciliations using Excel and Leverton MRI system. Automated costing and recoveries process at Standard Bank using MS Forms, SharePoint, and Power Automate.
Data Analyst
ABSA
Sep 2022 - Nov 2022 (2 months)
Automated SARB BA900 form population, reconciling extracts against general ledger. Produced variance and gap analysis for data validation.
Built tools for SARS reporting, reconciliations, dashboards, and foreign company tax compliance. Delivered client data validation and cleansing for tax packs.
Semi-automated Tracking and Reporting
GLA Debt Collectors
Semi-automated tracking and reporting from call centre system.
AI Innovation Masterclass Facilitator
RCL Foods
Supported the delivery of AI and Excel innovation masterclasses by preparing demonstration workbooks, business datasets, and practical use cases. Demonstrated advanced Excel techniques alongside enterprise AI tools.
National Education Data System
Netcare Education
Reduced reporting turnaround from weeks to 1 day.
Lotus 1-2-3 Systems
MCG Industries
Developed Lotus 1-2-3 systems for plant efficiency and wages management.
Education
Degrees, certifications, and relevant coursework
Microsoft
Microsoft Certified: Power BI Data Analyst Associate, Data Analytics
Certified as a Power BI Data Analyst Associate; certification in progress.
The Complete Business Analysis Fundamentals
The Complete Business Analysis Fundamentals, Business Analysis
Course in business analysis fundamentals, currently in progress.
University of South Africa
Practical Bookkeeping (NQF Level 5), Bookkeeping
Completed Practical Bookkeeping at NQF Level 5.
Agile Project Management
Agile Project Management – Certificate of Completion, Project Management
Certificate of completion for Agile Project Management.
Microsoft
SQL Server 2008/2012 – Querying, Administering, Integration Services, Reporting Services, Database Administration
Completed training on SQL Server 2008/2012 covering querying, administering, integration services, and reporting services.
The Fundamentals of Statistics
The Fundamentals of Statistics – Certified, Statistics
Certified in the fundamentals of statistics.
Data to Dashboard with Power BI
Data to Dashboard with Power BI – Certificate of Completion, Data Visualization
Certificate of completion for the Data to Dashboard with Power BI course.
Microsoft
MOUS (Microsoft Office User Specialist) – Master Level, Microsoft Office
Achieved Master Level certification as a Microsoft Office User Specialist.
Microsoft
Implementing Data Models and Reports with SQL Server 2012, Data Modeling
Completed training on implementing data models and reports with SQL Server 2012.
Microsoft
Implementing a Data Warehouse with SQL Server 2012, Data Warehousing
Completed training on implementing a data warehouse with SQL Server 2012.
Microsoft
Designing BI Solutions with SQL Server 2012, Business Intelligence
Completed training on designing BI solutions with SQL Server 2012.
Tech stack
Software and tools used professionally
Availability
Location
South AfricaAuthorized to work in
Salary expectations
Social media
Job categories
Skills
Interested in hiring Beatka?
You can contact Beatka and 90k+ other talented remote workers on Himalayas.
Message BeatkaGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
