Data Analyst – Internal Audit

As a member of the Data Analytics team, you will apply your programming and advanced analytics skills to work closely with internal auditors to develop analytics and testing strategies that drive insights and help the internal audit team better understand business processes and controls. Proposed improvements to processes and controls will flow from the various assessments

Qualifications, skills and experience

  • Minimum of 2 years of experience in the field of data analysis, including 2 years of experience in the non-life insurance sector.
  • Relevant degree in Statistics, mathematics, actuarial sciences and data science.
  • Hands-on experience with SQL programming.
  • Excellent understanding of database concepts such as views, materialized views, primary keys, table joins
  • Experience with visualization tools (Power BI) would be a plus.
  • Experience in analytical/statistical programming would be an asset.
  • Excellent communication skills (written and oral). Ability to communicate what is
  • relevant and important in a clear and concise manner.
  • Ability to multi-task and take initiative to improve performance.
  • Ability to create new ways to improve current processes and develop practical solutions.

Responsibilities

  • Extract data from the enterprise data warehouse, identifying key features, patterns and exceptions.
  • Assess the quality of the extracted data to understand any limitations or potential issues. Provide advice on resolving data quality issues.
  • Generate exception reports from the data warehouse based on defined parameters.
  • Perform large-scale recalculations and comparisons of results against data extracts/reports.
  • Perform scenario-based testing on data extracts/reports.
  • Review SQL code to identify data sources and their accuracy and completeness.
  • Understand and provide guidance on the suitability of individual data access.
  • Develop and maintain MIS to streamline and generate automated reports.
  • Develop visualization analyzes and reports 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.
  • Help internal auditors by using hands-on analysis of business data and providing insights from it.
  • Help the internal audit team understand the tools, approaches, and data infrastructure available to them.
  • Work with the internal audit team to create strategic self-service data products that enable the team to work more effectively with enterprise data and identify potential risks.

Desired skills:

  • Degree in Statistics
  • Math
  • Actuarial sciences
  • and data science.
  • SQL
  • Power BI

Desired work experience:

  • 2 to 5 years Investments, Insurance & Insurance
  • 2 to 5 years Data Analysis / Data Warehousing

Desired level of qualification:

Find out more/Apply to this position

Sean N. Ayres