Data Analyst with a background in Finance/Accounting
Location | Woodmead, South Africa |
Date Posted | August 15, 2020 |
Category |
Data Entry
IT / Information Technology |
Job Type |
Full-time
|
Currency | ZAR |
Description
Duties & Responsibilities
- Manage, refine and upgrade the standard conversion process, policies and procedures.
- Provide assistance and training to internal consultants on the data conversion process.
- Provide assistance and training to internal consultants on SQL query writing.
- Check the quality and internal sign-off of conversions from other consultants.
- Spec and write exception reports for clients using customised Transact SQL scripts.
- Extract, analyse, troubleshoot and convert legacy data into their software.
- Assist with developing data extraction and migration tools.
- Build Excel templates to accompany customized Transact SQL scripts.
Desired Experience & Qualification
- In depth knowledge and understanding of accounting principles.
- In depth knowledge and understanding of accounting software focused on the composition and extraction of data.
- Skilled in data analysis and troubleshooting to be able to analyse, understand and convert data from one system into their system.
- Skilled in Transact SQL for writing of client reports
- Intermediate to advanced Microsoft Excel skills for data analysis and converting as well as report template creation.
- Delivery of high quality work in a timely manner.
- Personal commitment to delivering the project in the agreed timeframe.
- Skilled in Microsoft Excel Visual Basic Studio.
- Skilled in SQL programming to assist with writing and developing data extraction and migration tools required.
Package & Remuneration
R 300 000 - R 500 000 per annum
Medical Aid and Pension
Udemy Business Licence for continuous learning and development