IT Business Analyst SQL/ VBA - Sandton Verfied

R 43000 per month Sandton, Gauteng Sandton, Gauteng more than 14 days ago 15-02-2017 2:26:18 PM
15-03-2017 2:26:18 PM
Business Analyst – SQL/ VBA - Medical Insurance – R35 to R 43000.00 - Bryanston

We have a new opportunity for an experienced and experienced Business Analyst (SQL/ VBA) for our client a forward thinking and progressive medical aid organisation based in Bryanston. Excellent growth opportunities within this professional organisation

The successful candidate needs to meet the following criteria:
• A minimum of at least 5 years’ experience in a similar role as a business analyst at a medical aid/ insurance or financial institution
• Highly proficient in SQL, VBA and other programming languages
• Highly proficient with the entire Microsoft Office suite, i.e. Word, PowerPoint, Excel
• Strong database and Excel skills
• Ability to work with large volumes of data
• Proactive individual with strong analytical skills
• Working knowledge of financial analysis in relation to systems
• Healthcare / insurance or other relevant experience
• MIP software or similar experience

The job description is as follows:
• Report analyst duties, e.g. design, test and develop automated reports
• Data analysis duties, e.g. assist in research, analysis, and remediation of complex data issues that directly impacts reporting and analysis
• Premium reconciliations: track and review premium due and received versus receipts loaded on the system
• Develop and maintain premium bordereaux and outstanding premiums
• Create financial reports for premium, claim utilisation, third party expenses etc
• Summarise conclusions from business analytics on a pro-active basis and provide key takeaways to senior management
• Create and maintain business reports / ad-hoc statistical investigations
• Support the team with continuous process improvement
• Support current financial models and develop new models
• Develop and maintain standard operating procedures and business rules