Junior Data/Business Analys

Junior Data / Business analyst. Experience in the following applications / languages: Microsoft SQL Server 2012 Non negotiable! The applicant needs to have a good understanding of Microsoft SQL Server that includes: Able to write ad-hoc SQL Queries Understand o Stored Procedures o Functions o Views o Tables o Microsoft SQL Server Management Studio Microsoft Reporting Service - Candidate should have a good understanding of Microsoft Reporting Service o Maintain existing Reports o Modify Existing Reports o Create new Reports Microsoft Excel - Advance Excel skills specifically for reporting development o Pivots o VLOOKUP, SUMIF(S), COUNTIF(S), IF(S) statements, etc. o SQL Queries within Excel (Excel Query Manager) Microsoft Word - Advanced Word skills for Reporting and Document Publication o Simple Mail Merge o Including formatting merge fields o Knowledge of Mail Merge Toolkit Advantageous Experience:Excalibur Collection SystemsIntecon ALLPSCapitec CORSRevenue Red CASRegistered CommunicationsExperian Data ServicesManaging a small team of staffManagement of service providers2-3 Years required experience in Debt Collection or Legal Environment. Non-Negotiable Requirements:Have a keen ability to learn about systems and processesBe result drivenHave own vehicle and drivers licenseWork unattended and function well within a teamAt least a Matric certificateStrong understanding of financial ledgers and accountingApplication training and on-site guidance will be provided to the applicant that demonstrates the necessary skills.