Studio 29

VBA Developer & Statistical Analyst

  • Location Western Cape
  • Role Permanent Analyst
  • Salary 40000+
  • Years Experience 4+
  • Highest Qualification BSc. Mathematical Statistics Degree, Majority Cum Laude
  • Ref # 152
  • EE/AA Status White Male
  • Gender Male
  • Drivers Licence Yes
  • Reliable Transport Yes
  • Willing to Relocate Yes


  • Highly motivated, positive, energetic and innovative
  • Excellent communication, interpersonal and presentation skills.
  • Excellent client facing skills and able to build rapport with clients quickly and easily
  • Well accustomed to presenting clients with tailored solutions to meet their needs
  • Well versed in the arts of data science.
  • Passionate about numbers and data science and creation new visualizations to bring life and light to genuine business problems and finding the solutions to answer all the client’s needs
  • Thrives on intellectual stimulation in the world of data science.
  • Leadership and organisational skills
  • Experience training junior team members.
  • Self-disciplined and thrives on learning new programmes and programming languages.
  • Meticulous worker who pays attention to analytical data as well as the visual presentation of data analysis output and results. Presentations are clear and precise, containing only salient points relevant to the data analysis.


IT Skills and Technical Ability:


  • Mathematical and Statistical Modelling using VBA and Advanced Excel
  • Expert Automation Excel Development using VBA/XML
  • Expert Excel Add-In Developer. (I have developed and own a Blueprint for developing an Unlimited amount of customized Add-In’s for Excel, PowerPoint and other office applications)
  • Excellent working knowledge of Microsoft Office 365 Business Premium including PowerPoint, Word, Excel, Outlook, Access & Skype for business
  • VBA Expert, XML (advanced), SQL and SAS.
  • Excel & PowerPoint Ribbon Add-In Coding Expert.
  • Have had exposure to Tabelau, QlikView, R and MatLab
  • Excellent Web-Design skills using Microsoft Office Front Page/HTML
  • Excellent Computer hardware knowledge


Advanced Experience with risk and fraud systems:


  • Experian
  • Octagon Business Solutions
  • TransUnion
  • XDS –Expert Decision Systems
  • Maris-IT Credit Services




Data Management

  • Clarify data requests with stakeholders to ensure alignment and mutual understanding
  • Create templates to capture data consistently
  • Evaluate and analyse data to determine additional methods and approaches for capturing the data (i.e. online surveys)
  • Data review and cleansing submitted by stakeholders
  • Review data generated from reports to identify discrepancies
  • Ensure compliance with Data Privacy and Protection Guidelines
  • Data Analysis & Insights
  • Provide analytical support across the functions within Global team
  • Analyse and interpret both quantitative and qualitative data
  • Utilise multiple data sources to achieve the best possible output and ensure benefits from a joined-up approach
  • Develop reliable analysis and reports to the business which will be presented via dashboards, metrics and oral presentations in an unambiguous, user-friendly format
  • Perform all data analysis with relevant degree of confidentiality and sensitivity
  • Analytics Capability
  • Recommend methods for improving data manipulation and summarisation and visualisation techniques to effectively present results
  • Ability to identify and use the best systems and reporting tools to enhance business decision making
  • Coach and assist in development of team members
  • Collaborate with relevant departments (eg Business Services, IT etc) to develop and maintain a data approach that reflect best practices and latest thinking.





Enquire about Featured Candidate