Data Analyst

Job description

Salary: 650,000 - R800,000

Location:

Johannesburg , South Africa

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 Data Analyst is responsible for liaising with internal/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 system to ensure its accuracy and quality before use by accounting, business and actuarial departments in making business decisions ensuring effective treaty management.

• Liaising with internal/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 system.
• Set up regular processes of data receipt, cleaning, loading and reporting.
• Data analysis and feedback on 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 delivering 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 suggesting improvements.
• Facilitate changes as user requirements change.
• Knowledge transfer and automation as far as possible.

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

• Excellent communication 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