Data Analyst

As the world's leading reinsurance company with 40,000 employees at over 50 locations in all parts of the world, and operating within South Africa for over 50 years, our Client introduces a paradigm shift in the way you think about insurance. By turning uncertainty into manageable risk, we enable fundamental change.

The Role

The Data Analyst is responsible for liaising with internal and external clients to understand their data and systems, analysing and reporting on its content and quality, ensuring it demonstrates compliance with reinsurance treaty conditions and that it is fit for purpose for data users in other departments. Data is assessed, cleansed and loaded to life systems to ensure its accuracy and quality before use by accounting, business and actuarial departments in making business decisions ensuring effective treaty management.

Responsibilities

• Liaising with internal and external clients to understand different data files and treaty rules.
• Strong understanding of local Life systems including business knowledge.
• Technical set up of business rules and treaty conditions in the system.
• Set up regular processes of data receipt, cleaning, loading and reporting.
• Data analysis and feedback on the quality of data files received, with recommendations to improve.
• Put in place consistent layout and mappings of data sources into the standard format.
• Upload and deliver data to relevant Life systems in a standard, quality assured format.
• Close liaison with local stakeholders to resolve issues resulting from loading errors.
• Understand existing business processes and suggest improvements.
• Facilitate changes as user requirements change.
• Knowledge transfer and automation as far as possible.

Experience and Qualifications

• Degree or equivalent in a numerate or analytical science, e.g., Mathematics, Computer Science, or Actuarial Science.
• 6 years’ experience in the Life insurance industry (preferably reinsurance) working as a SQL data analyst, BI or related.
• Experience in data transformation and reporting for valuation purposes.
• Previous work experience with BI and working with multiple data sources.

Skills

• Strong numerical and analytical skills.
• Ability to communicate effectively in a technical and non-technical manner.
• Ability to work in-depth on complex topics.
• Must have excellent Microsoft Excel skills.
• More than 6 years working experience with MS SQL Server 2012 (or later).
• Experience in design, development, and maintenance of database objects.
• Experience with SSIS at an intermediary to advanced level.
• Experience with reporting using SQL in Power BI would be an advantage.
• Experience working with multiple data sources in SQL.