Freelancer profile translated to English.

Description

Senior Data Analyst with 14 years of experience in data analysis, data visualization, dataset modeling, datamart, and its feeding via ETL (Talend, MyReport, SSIS). Expertise in using advanced data analysis tools (SQL, MyReport, Power BI, Qlikview) and in managing data-driven projects. Passionate about data transformation to optimize business performance.

Languages

French
Native or bilingual

Workplace preferences

Can work on-site

Paris (up to 50km)

Groupe Gagneraud BTP
Data Analyst / Data Engineer
CIVIL ENGINEERING
May 2024 - Today (2 years and 3 months)
Paris, France
• Migration of interface flows between different business tools. This migration consists of developing Talend Cloud jobs corresponding to existing flows on Blueway software.
• Writing functional and technical specifications and developing new flows following the change of the financial and treasury management tool.
• Automate the execution of Jobs from the TMC (Talend Management Console)
• Transfer of skills on the different developed flows
• Develop dashboards in Excel (MyReport Builder) and interactive dashboards (Power BI and MyReport Center) to track key KPIs and present results to business units.
• Automate monthly reports, thus reducing business processing time by 30%.
Talend Data Integration Talend Administration Center Talend Cloud Microsoft Excel Microsoft SQL Server
SOFIDY Investissement immobilier–
Senior Data Analyst
November 2023 - April 2024 (5 months)
1 Évry, Dravegny, France
• Optimization of existing models to implement interactive dashboards (Power BI)
• Creation of impactful Excel dashboards and data visualization (Power BI)
• Technical environment: Power Bi Desktop, Power Bi Service, SQL Server, Batch Script, Microsoft SSIS, DAX and M
SOGARIS – Gestion et Investissement
Senior Data Analyst
July 2022 - October 2023 (1 year and 3 months)
Paris, France
• Modeling of the rental management part and the management of shares and subscriptions
• Implementation of rental KPIs (Collection, Disbursement, Reversion, Relocation, Defaults, WALB and WALT...)
• Implementation of share management KPIs (Number of shares in bare ownership, usufruct, and full ownership, Share amount, Assets per salesperson...)
• Transfer of skills and training of key users
• Technical environment: SQL Server, MyReport, Excel, VBA, Microsoft SSIS
• Software environment: PREMIANCE, UNICIA, ALTAIX, EVEN and SEIITRA