Data Analyst

**Data Analyst (12 Month Contract)**:
**Location**
Johannesburg, South Africa

**Munich Reinsurance Company of Africa Limited (MRoA) has been operating in South Africa for 50 years, although the Munich Re (Group) was active on the Continent via Munich Re in Munich for some years prior to commencing the Southern African operation in Johannesburg in 1968. The Head Office of MRoA is in Johannesburg, with a client service Life office situated in Cape Town.**

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.

Your job
- 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.

**Profile**:

- 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 related.
- Experience in data transformation and reporting for valuations purpose.
- Previous work experience with BI and working with multiple data sources

**Skills required**
- 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

About us

Find out Who we are, What we do, Our Strategy and How we can Support & Reward you

Our business model is based on the combination of primary insurance and reinsurance under one roof. We take on risks worldwide of every type and complexity, and our experience, financial strength, efficiency and first-class service make us the first choice for all matters relating to risk. Our client relationships are built on trust and cooperation. If you would be interested in helping shape the future as part of one of our teams, we look forward to hearing from you.-
At Munich Re, we embrace, and value, the interaction of diverse backgrounds, experiences, perspectives and thought. This interaction is our foundation. Of our open culture and spirit of partnership. Of how our teams are built and cultivated. Of how we are supported and developed. And at the centre of this interaction is each of us.