Description:
1. Data extraction
Perform daily, weekly and monthly data extraction using SQL and/or PowerBI to reconcile and report on activities relating to DIRECT processes and results.
Provide application analysis and data modeling design to collect data for centralized data warehouse.
Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.
Proficient in the use of query and reporting analysis tools.
Standardize data collection by developing methods for database design and validation reports.
2. Reporting
Compile daily, weekly and monthly reports
Develop new reports to address changing business needs
3. Analysis and recommendations
Analyse all reporting and provide insight into the results.
Conduct change impact analysis to assess the potential implications of changes to business functions
Conduct possible research relating to new processes, vendors and BI products
4. Ad Hoc
• Assist with all new business retention and management information ad hoc requests (admin and follow ups)
Requirements
FORMAL EDUCATION
BCom Economics and Risk Management; Statistics; Information Systems or
BSc Stats
Or alternatively with an IT related degree/diploma (BSc IT Degree)
TECHNICAL/LEGAL CERTIFICATION
PowerBI knowledge advantages
EXPERIENCE
3 to 5 years experiences
Graduate with extensive experience in BI advantages
Closing Date: 20 January 2023