Job: Data Analyst Internship

Company : Outsurance; Centurion; On-site; ZAR 56,000 - 112,000; Full time

Benefits offered by this job

Internship program

Job summary

Outsurance in Centurion, Gauteng, is seeking a data analytics student for an internship within Internal Audit. You will extract data from the data warehouse, profile data for key features, and perform scenario-based testing to support audit insights.

You will learn to assess data quality, review SQL for accuracy, and develop automated reporting and self-service data products. This internship focuses on building skills in analytics, visualization, and data governance within an insurance

Qualifications

• Undergraduate or postgraduate degree in relevant fields; willingness to learn SQL.
• Knowledge of Power BI or Tableau would be beneficial.
• Knowledge of Python, R, or SAS would be beneficial.

Responsibilities

• Extract data from the company’s data warehouse, profile the data to identify key features, patterns and outliers; and performing scenario-based testing
• Assess the quality of data extracted to understand potential limitations or issues
• Review SQL code to identify sources of data and the accuracy and completeness thereof
• Understand and provide guidance on the appropriateness of individual access to data
• Develop and maintain Management Information Systems in order to streamline and drive automated reporting
• Develop visualisation analytics and reporting to present scenarios from the data; both at a high level to highlight potential risks and at a detailed level to enable root cause analyses
• Assist the Internal Auditors by using hands-on analysis of company data and providing insights from this
• Help the Internal Audit team understand the data tools, approaches and infrastructure available to them
• Work with the Internal Audit team to build strategic self-service data products that enable the team to more efficiently and effectively work with company data and identify potential risks

Skills

Python

R

Data analysis

Communication skills

Education

Undergraduate or postgraduate degree in Mathematics, Statistics, Actuarial Science, Data Analytics, Computer Science, Information Engineering, Informatics or equivalent

Tools

Power BI

Tableau

SQL

Job description

Are you passionate about using data to challenge the norm? Internal Audit is looking for a strong data analytics individual to join the Internal Audit team. The Internal Audit team assists the organisation in maintaining effective controls by assessing the reliability of financial reports, monitoring the company’s compliance with laws and regulations, and advising management on developing smart control solutions. We’re looking for a detail-oriented team player who has an interest in Insurance products and wants to gain insight into the company’s operations and control processes.

Responsibilities

• Extract data from the company’s data warehouse, profile the data to identify key features, patterns and outliers; and performing scenario-based testing
• Assess the quality of data extracted to understand potential limitations or issues
• Review SQL code to identify sources of data and the accuracy and completeness thereof
• Understand and provide guidance on the appropriateness of individual access to data
• Develop and maintain Management Information Systems in order to streamline and drive automated reporting
• Develop visualisation analytics and reporting to present scenarios from the data; both at a high level to highlight potential risks and at a detailed level to enable root cause analyses
• Assist the Internal Auditors by using hands-on analysis of company data and providing insights from this
• Help the Internal Audit team understand the data tools, approaches and infrastructure available to them
• Work with the Internal Audit team to build strategic self-service data products that enable the team to more efficiently and effectively work with company data and identify potential risks

Qualifications

• Undergraduate or postgraduate degree in Mathematics, Statistics, Actuarial Science, Data Analytics, Computer Science, Information Engineering, Informatics or equivalentKnowledge of any programming language with a willingness to learn SQL programming
• Knowledge of visualisation tools such as Power BI or Tableau would be beneficial
• Knowledge of analytical/statistical programming such as Python, R, or SAS would be beneficial
• Excellent communication skills (written and oral)
• Ability to communicate what is relevant and important in a clear and concise manner
• Drive and Motivation
• Ability to handle multiple tasks and takes initiative to improve their own performance
• Ability to create new ways to improve current processes and develop solutions that are grounded in reality and have practical value

Hiring organization

Employment Type: internship

Job Location: Centurion, Gauteng, South Africa