Junior Data Analyst Microsoft SQL Server-Blaauwberg-R17, 000 to R22, 000 per month

Junior Data Analyst Microsoft SQL Server-Blaauwberg-R17, 000 to R22, 000 per month

Debt Collection and Legal Company seek a Junior Data Analyst.

Non-Negotiable Requirements:

Have a keen ability to learn about systems and processes

Be result-driven

Have your 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

Experience in the following applications/languages:

Microsoft SQL Server 2012 –Have a good understanding of Microsoft SQL Server including:

Able to write ad-hoc SQL Queries

Understand

Stored Procedures

Functions

Views

Tables

Microsoft SQL Server Management Studio

Microsoft Reporting Service - Have a good understanding of Microsoft Reporting Service

Maintain existing Reports

Modify Existing Reports

Create new Reports

Microsoft Excel - Advanced Excel skills specifically for reporting development

Pivots

VLOOKUP, SUMIF(S), COUNTIF(S), IF(S) statements, etc.

SQL Queries within Excel (Excel Query Manager)

Microsoft Word - Advanced Word skills for Reporting and Document Publication

Simple Mail Merge

Including formatting merge fields

Knowledge of Mail Merge Toolkit

2-3 Years required experience in Debt Collection or Legal Environment

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

Good growth potential, salary earnings can easily exceed R35k after 3 years of employment and hence I am looking for someone that wants to grow with the business.

Mail