SUMMARY:
My client within the collections environment seeks a solid individual with strong SQL and Excel.
This is a Junior role with scope to grow into a Business Analyst in this fast paced, dynamic environment.
POSITION INFO:
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
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 Systems
- Intecon ALLPS
- Capitec CORS
- Revenue Red CAS
- Registered Communications
- Experian Data Services
- Managing a small team of staff
- Management of service providers
- 2-3 Years required experience in Debt Collection or Legal Environment.
Non-Negotiable Requirements:
- Have a keen ability to learn about systems and processes
- Be result driven
- Have own vehicle and driver’s license
- Work unattended and function well within a team
- At least a Matric certificate
- Strong understanding of financial ledgers and accounting
- Application training and on-site guidance will be provided to the applicant that demonstrates the necessary skills.