Sql Data Administrator
Leading Company based in Rondebosch are looking for a Junior SQL Data Administrator to join their team. Assist with reconciliation between Bank Statements to Collector Settlement data Assist with reconciliation between Municipal/Electricity Providers files to Settlement data. Running ad-hoc queries to support the Prepaid Electricity department in investigating discrepancy results between Collector or Receiver reconciliations Compile SQL queries for ad-hoc requests and daily reconciliations. Compile macros in Excel to streamline and automate functions within the Prepaid Electricity department. Reconciliation of transactions in Prepaid Electricity Reconciliation of daily settlements for various clients. Compiling macros or SQL queries to match transactions and assist Senior Team Leader and team members with the execution of their daily duties. Manual Recons, by assisting with: Setting up recons for new clients Updating recons on a daily basis for various clients Investigate any discrepancies Month end reconciliation of cash book, may be required. Qualifications • Matric, relevant tertiary SQL and Excel qualifications Specific Skills (Technical): Minimum of two years’ experience Excel proficient at an advanced level – ability to compile Macros advantageous. SQL knowledge – compiling and running SQL queries. gill.mullerpersonnel@vodamail.co.za