Freelancer profile translated to English.

Description

Data Engineer with over 9 years of experience in designing, developing, and optimizing business intelligence solutions in the pharmaceutical, banking, and insurance sectors. Specialized in Data Warehouse, Data Quality, and BI Reporting, with proven expertise in Snowflake, Informatica Cloud (IICS), and Power BI. Ability to lead technical projects in an agile environment and bridge the gap between business needs and scalable data architectures.

Industry field of expertise

Languages

English
Fluent
French
Native or bilingual

Workplace preferences

Can work on-site

Nevers (up to 50km), Paris (up to 40km)

Sanofi/Opella
Senior Data Engineer
PHARMACEUTICALS INDUSTRY
November 2021 - February 2026 (4 years and 3 months)
•Data Foundation (Global DWH – 15+ countries): Implementation of a Data Quality framework with automatic metric ingestion and rejection monitoring; development of a Power BI dashboard for quality monitoring.
•Drive 360 (Financial Dashboard): Datamart modeling in Snowflake, pipeline data quality control, and coordination.
•FEDO (Partner Contract Flows): Role of Tech Lead & PMO, definition of RACI, roadmap, and specifications. Development of CRM ingestion → Data Lake (IICS/Snowflake) and management of UAT up to Go Live.
•GBS KPI Reporting: Creation from scratch of a Corporate Data Warehouse and datamarts connected to SAP HANA and Power BI.
•FaCT Analytics (Industrial Performance): Deployment of a new DWH connected to AWS S3 data lake, replacement of existing systems, Power BI dashboards.
Tools: Snowflake, Informatica Cloud, SAP, Power BI, AWS S3.
Microsoft Power BI Snowflake informatica cloud AWS S3
Natixis Assurances
Data Engineer
BANKING AND INSURANCE
April 2019 - June 2020 (1 year and 2 months)
Paris, France
•Maintenance and evolution of the business intelligence system.
•SQL/ETL optimization and implementation of development and deployment standards.
•Delivery automation (C# + Power BI).
Tools: SSIS, Power BI, SQL Server, SSRS, Oracle, VTOM.
SSIS Power BI SQL Server Oracle V-TOM
Dexia
Data Engineer
BANKING AND INSURANCE
May 2018 - April 2019 (11 months)
Paris, France
•Design and development of the PRISME Data Warehouse (SSIS/SQL Server).
•Technical supervision and scoping of offshore teams (Paris & India).
Tools: SSIS, SQL Server, Control-M.
SSIS SQL Server Transact-SQL