Freelancer profile translated to English.

Description

Coming from the data field and passionate, I support business units in transforming their needs into useful analytical solutions (dashboards, reporting, data exploitation, statistical and predictive analyses), while contributing to the diffusion of a data-driven culture. Convinced that collaboration between business and data is an essential driver of performance, I also attach great importance to lasting and benevolent human relationships.

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Remote only

Primarily works remotely

Assura (Caisse assurance maladie)
DATA ANALYST
HEALTH AND WELLNESS
March 2013 - January 2024 (10 years and 10 months)
Lausanne, Switzerland
Context
Swiss health insurance company managing large-scale customer data (800k insured). Data environment evolving in terms of data usage structuring.

Objective
To be the data referent for data availability and to promote a data-driven culture. Providing data and decision-making tools.

Responsibilities
• Design, develop, and maintain KPI reports/dashboards for management and business teams
• Gather and translate business needs into functional and usable data solutions
• Enable self-service analysis through SQL-based data extraction
• Build targeted datasets for marketing campaigns and cross-functional projects
• Measure campaign performance using control group methodologies
• Perform statistical and predictive analyses (churn analysis)
• Ensure data quality, consistency, and confidentiality in collaboration with backend teams
• Migrate reports from Excel to Tableau and support adoption by business teams
• Act as a data referent, promoting a data-driven culture

Key achievements
• Creation of over 35 reports/dashboards per year used by over 200 business users
• Provision of data (SQL queries, datasets) to business units for analysis purposes (100+ extractions/year).
• Sampling of insured persons and/or families for marketing, sales, and insured communication campaigns (800k insured / 500k families for 20+ campaigns/communications).
• Monitoring and improvement of marketing campaigns, impact of the campaign on sales, comparison with a control dataset.
• Internal audit and benefits fraud department, support and participation in various scenarios (10+ scenarios/year, SQL queries).
• Accelerated Tableau adoption and reduced reliance on Excel reports
Data visualisation Definition and monitoring of indicators (KPI) Statistical and predictive analyses, R Tableau Software, Excel SQL queries, "self-service" analytics
IPSOS (Société internationale de marketing d'opinion)
RESEARCH EXECUTIVE
January 2012 - January 2012
Geneva, Switzerland
Cost estimation (supplier requests and project cost estimation), questionnaire development, study management, data collection for analysis and reporting.
exploratory-data-analysis Project Management
NetwellCASALA (Centre de recherche, améliorer la qualité de vie des seniors)
DATA MANAGER
June 2011 - July 2011 (1 month)
Dundalk, Co. Louth, Ireland
• Collection and merging of multi-source data
• Respondent interviews (elderly people) and cognitive tests
• Training interns on basic SPSS statistics