Data Analyst

Believe Resourcing; Johannesburg; On-site; ZAR 650 000 - 800 000; Full time

Job summary

A leading reinsurance company in Johannesburg seeks a Data Analyst for a 12-month contract. The role involves liaising with internal and external clients, analyzing data for compliance with treaty conditions, and ensuring data quality. Ideal candidates will have a degree in a quantitative field and at least 6 years of experience in the life insurance or reinsurance sectors, with strong SQL and Microsoft Excel skills.

Qualifications

• 6 years' experience in Life insurance industry (preferably reinsurance) working as a SQL data analyst.
• Experience in data transformation and reporting for valuations purpose.
• Previous work experience with BI and working with multiple data sources.

Responsibilities

• Liaising with clients to understand different data files and treaty rules.
• Set up regular processes of data receipt, cleaning, loading and reporting.
• Data analysis and feedback on quality of data files received with recommendations.

Skills

Excellent communication skills

Strong numerical and analytical skills

Ability to communicate effectively in a technical and non-technical manner

Excellent Microsoft Excel skills

More than 6 years working experience with MS SQL Server 2012 or later

Experience with SSIS at an intermediary to advanced level

Experience with reporting using SQL in Power BI

Experience working with multiple data sources in SQL

Education

Degree or equivalent in a numerate or analytical science

Job description

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 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

Skills

• 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