Data Analytics Intern

The Specialty Insurance division, and more specifically the Large Risks branch of SCOR P&C (SCOR Single-Risk), offers a comprehensive range of insurance solutions tailored to large industrial groups and major technological projects (Property, Casualty, Construction, Onshore/Offshore Energy, Mining Industry, Marine, Cyber, etc.).
 

Within the CTO team of Specialty Insurance, the intern will participate in the development of a data warehouse and data analysis services for SCOR’s Large Risks branch. You will develop innovative data analysis services using Python, as well as SQL queries for data extraction (benchmarking tool, ICS Monitoring , etc.). You will contribute to the evolution requests of the Specialty Insurance data warehouse in collaboration with IT teams (integration of business data into DataBricks). You may be required to work on data visualization tools (Tableau, PowerBI).

• Developing Benchmarking tools for underwriters to benchmark pricing of large insurance portfolios using Power BI dashboards.
• Developing and maintaining queries for insurance data in datalake to ensure data integrity, scalability, and performance optimization.
• Developing and maintaining Python scripts for analytical tools.
• Assisting with Tableau
• Conducting data validation and quality checks.

Required experience & competencies

•  Business Intelligence (BI) Tools – Power BI, Tableau
• Data extraction in SQL
• Programming language - Python
• Excel

Required Education
 

• 2nd Year of Engineering school or equivalent in IT, Computer Science, Data, or Mathematics
  related sciences.

As a leading global reinsurer, SCOR offers its clients a diversified and innovative range of reinsurance and insurance solutions and services to control and manage risk. Applying “The Art & Science of Risk,” SCOR uses its industry-recognized expertise and cutting-edge financial solutions to serve its clients and contribute to the welfare and resilience of society in around 160 countries worldwide.

Working at SCOR means engaging with some of the best minds in the industry – actuaries, data scientists, underwriters, risk modelers, engineers, and many others – as we work together to find solutions to pressing challenges facing societies.

As an international company, our common culture is defined by “The SCOR Way.” Serving both to build momentum that drives the Group forward and as a compass to guide our actions and choices, The SCOR Way is anchored by five core values, reflecting the input of employees at all levels of the Group. We care about clients, people, and societies. We perform with integrity. We act with courage. We encourage open minds. And we thrive through collaboration.