Data Analyst InternSCOR

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.

SCOR supports inclusion and the diversity of talents, and all positions are open to people with disabilities.

Ready to dive into the heart of data innovation at SCOR? The P&C Product and Technology team, part of the P&C COO division, is looking for a Data Analyst Intern to help shape the future of our data ecosystem. From building analytical services in Python and SQL to enhancing our data warehouse and creating impactful visualizations in Tableau and Power BI, you'll be at the center of our transformation.

Starting in January/February for six months, this internship offers a unique opportunity to join the P&C Operations team-a strategic pillar driving operational excellence, data quality, and advanced analytics across SCOR's Property & Casualty business. Join us and help turn data into decisions that matter.

The P&C Product and Technology team within the P&C COO division is seeking a Data Analyst Intern who will help develop data analysis services using Python and SQL, contribute to the evolution of the data warehouse, and work on data visualization tools such as Tableau and Power BI.

This six-month internship aims to start in January/February.

The P&C Operations team plays a key role in supporting SCOR's Property & Casualty business by driving operational efficiency, data quality, and analytics capabilities across underwriting and support functions.



As a Data Analyst Intern within the P&C Operations team, you will contribute to the development and enhancement of data-driven solutions that support operational processes and decision-making.


* Participate in the design and evolution of the P&C data warehouse, collaborating with IT teams to integrate business data into platforms such as Databricks.
* Develop data analysis services using Python and create SQL queries for data extraction and reporting (e.g., benchmarking tools, operational monitoring dashboards).
* Work on data visualization projects using tools like Tableau and Power BI to deliver actionable insights to stakeholders.
* Support data quality checks, transformation, and validation to ensure accuracy and reliability.
* Collaborate with cross-functional teams to understand business requirements and translate them into analytical solutions.

This internship offers exposure to data engineering, analytics, and visualization within a global reinsurance environment, providing hands-on experience with modern tools and methodologies.



Responsibilities:

* Develop and maintain data analysis services using Python and SQL.
* Design and maintain queries for insurance data in the data lake, ensuring data integrity, scalability, and performance optimization.
* Design and build interactive dashboards and reports using Tableau and Power BI.
* Perform data cleaning, transformation, and validation for accurate insights.
* Automate recurring reports and workflows using Power Automate to improve efficiency.
* Document technical processes and methodologies for transparency and future reference.
* Support continuous improvement initiatives by optimizing existing tools and workflows.

Qualifications:

* 2nd Year of Engineering school or equivalent in IT, Computer Science, Data Science, or Mathematics-related sciences.
* Business Intelligence (BI) Tools: Power BI, Tableau
* Data Extraction & Querying: SQL
* Automation & Workflow: Power Automate, Microsoft Copilot for data and reporting tasks
* Programming Languages: Python
* Advanced Excel Skills: Formulas, Pivot Tables, Data Analysis
* Foundry (Good to Have)
* AI-Powered Productivity Tools: Familiarity with Copilot features in Microsoft 365 (Excel, Power BI, Teams) for enhanced data analysis and reporting