About

Junior Data Specialist with expertise in automation and process optimization. I work with Python, VBA, and SQL to process financial data, create Power BI dashboards, and extract insights from databases. I eliminate manual processes by building automated workflows that save time and improve accur...

Skills

  • Sql
    8
  • Python Programming Language
    7
  • HTML/CSS JavaScript
    6
  • VBA
    6
  • English
    10
  • isixhosa
    10

Recommendations

Provided a score of  
10
  for ASEMAHLE ZIDE

Experience

ASEMAHLE ZIDE

Work experience
  • As a Junior Data Specialist, I support the business intelligence and investment operations teams by managing, cleaning, and analyzing financial and client data. My work focuses on developing automated solutions, maintaining critical reporting infrastructure, and delivering accurate investment reports to clients and internal stakeholders.
  • ✅Key Responsibilities, Duties, and Tasks:
  • Database Management and SQL Development:
  • Work extensively with Microsoft SQL Server to query and update databases.
  • Execute complex SQL operations including data manipulation, joins, CTEs, and window functions.
  • Develop SQL functions and stored procedures to optimize data extraction processes.
  • Pull daily financial data from Morning Star and maintain monthly position data uploads.
  • Automation and Process Development:
  • Develop automated reporting tools using Excel VBA for task scheduling and process automation.
  • Leverage Python for data processing, wrangling, and visualization tasks.
  • Create automation flows using Power Automate to streamline workflows.
  • Progress from running existing scripts to writing original automation solutions.
  • Investment Reporting and Client Deliverables:
  • Prepare monthly and quarterly Fund and Client reporting, including Fund Fact Sheets
  • Design, develop, and maintain daily and monthly reports for internal teams and clients
  • BI and Visualization:
  • Maintain and update Power BI dashboards to reflect evolving business requirements
  • Perform Power BI report accuracy checks and data validation
  • Utilize Jaspersoft Studio for enterprise reporting solutions
  • Apply advanced Excel functions including PivotTables and Power Query

ASEMAHLE ZIDE

Work experience
  • Assisting in administrative duties and financial administration tasks using the SAMRC JDE system.
  • Supporting project management and data analysis activities within the department.
  • Giving experience in research capacity development funding processes and managing administrative tasks related to funding applications and reporting.
  • Collaborating with team members to ensure compliance with organizational policies and financial regulations.
  • Data management, sorting achieves files and Organizing meeting.

Related persons

njili ziziphoComputer literacy both Excell and word office , Basic Computer hardware and software operations.
Provided a score of  
10
  for ASEMAHLE ZIDE