Data Analyst (12 Month Contract)
Salary : 650,000 - R800,000
Location : Johannesburg , South Africa
About Client
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 / 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.
Responsibilities
- 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.
Experience and Qualifications
Degree or equivalent in a numerate or analytical science, e.g. Mathematics, Computer Science; actuarial science6 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 sourcesSkills
Excellent communication skillsStrong numerical and analytical skillsAbility to communicate effectively in a technical and non-technical mannerAbility to work in-depth on complex topicsMust have Excellent Microsoft Excel skillsMore than 6 years working experience with MS SQL Server 2012 ( or later)Experience in design, development and maintenance of database objectsExperience with SSIS at an intermediary to advanced levelExperience with reporting using SQL in Power BI would be an advantageExperience working with multiple data sources in SQL#J-18808-Ljbffr