The foundation of Munich Reinsurance Company in 1880 is largely due to the efforts of Carl Thieme. It is also Thieme who stated that: "By its nature, reinsurance needs to be international". He consistently follows his conviction by putting the company on an international footing from the very start. He establishes a business model whose essential f...
Read more about this company
The Data Analyst liaises with internal/external clients to understand their data and systems, analysing and reporting on its content and quality, ensuring it shows 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 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
Your 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:
Numerical and analytical skills
Communicate in a technical and non-technical manner
Work in-depth on complex topics
Must have Excellent Microsoft excel (can maintain complex spreadsheets) 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 reporting using SQL in Power BI
Experience working with multiple data sources in SQL
Our Benefits:
Work/Life balance.
Great working environment.
Great compensation.
12 months fixed term contract, with exposure to fulltime employment opportunities.
Gmail
Yahoomail