The successful candidate will be required to work with monthly data extracts from the business's line of business system. This line of business system is not an accounting system but, contains journal level detail which is normally housed in a General Ledger. These extracts (12 files per financial year) will be in Excel and will contain several rows ranging between 250k and 300k lines per file, depending on the level of transactional activity in any given month.
These files will have to be analysed, unpacked, and summarised for data integrity, which may include a reconciliation between the transactional data and the general ledger/trial balance. Data anomalies will have to be isolated. System calculations will have to be reperformed and any system errors reported. The transactional result of input errors will also have to be identified and separately reported.
Skills/Personal Attributes Required
- Qualified CA (SA) with between 5-to-7-year post articles experience.
- Big-data experience and knowledge of Power Query will be beneficial.
- Ability to analyse transactional data and identify anomalies and errors.
- Knowledge of systems-accounting.
- Advanced Excel skills including usage of pivot tables and formulas such as but not limited to countif() and sumif().
- Must be able to work well under pressure and meet strict deadlines
- Must be able to work independently and be a team player
Market related Cost to Company, based on qualification and experience
Interested applicants can forward their CV to [Email Address Removed] by no later than15 September 2023. Shortlisted applicants will be required to undergo employment checks.
- Please consider your application unsuccessful if you have not received a response within two weeks of submission.
- Charted Accountant
- Recons
- Bank Reconciliation
- Forex
- Power Query
- PowerBI
- 2 to 5 years Banking
- 5 to 10 years Financial / Project Accounting
- Degree
- South African Institute of Chartered Accountant
Sasfin was listed on the JSE in 1987 and is a bank-controlling company that comprises three business pillars: Asset Finance, Bank and Wealth. The Group has regional offices in four South African provinces and eight cities. Sasfin is a B-BBEE 1 contributor.
We enable entrepreneurs and investors to grow their businesses and global wealth, supporting job creation and sustainable socio-economic development.
