About Lilian
French
Native or bilingual
English
Fluent
Experience
- Crédit agricole SAData Analytics & Engineering Lead / Head of SI & Cybersecurity DashboardsBANKING AND INSURANCEJanuary 2025 - January 2026 (1 year)Paris, France• Gathering and formalizing business requirements in close collaboration with business teams, designing, and developing group-wide Cybersecurity and SI decision-making Power BI dashboards.• Designing high-performance data models (star schema) and transforming data using SQL and Python to ensure reliability and usability.• Developing fast, intuitive, and user-oriented Power BI dashboards with quick navigation and efficient filter management.• Continuous improvement of reporting ergonomics and structure (UI/UX, graphic charter) to facilitate their evolution while respecting business needs.• Analytical and technical referent: mentoring, dissemination of best practices in modeling and data quality.
- BNPPData Analyst / Analytics EngineerJuly 2022 - December 2024 (2 years and 5 months)Paris, France• Designing strategic analytical reporting and dashboards for the Group Legal department using Tableau to facilitate activity steering and key indicator monitoring.• Designing high-performance semantic models: star schema modeling (fact and dimension tables) to organize relationships between tables and integrate data in a readable and optimized way into reports.• Advanced use of Alteryx: designing high-performance workflows, integrating and joining multi-source data, developing reusable macros, and automating processes via task scheduling.• Leveraging the AWS ecosystem to industrialize the ingestion and processing of data from heterogeneous sources (on-premise, PostgreSQL databases), implementing robust and scalable pipelines.• Manipulating and transforming large volumes of data within analytical environments on Teradata and Snowflake.• Preparing optimized datasets to address RLS, historization, and performance challenges.• Implementing versioning best practices with GitLab (version management, collaboration, and tracking of data pipeline evolutions).
- Arquus DefenseData Analyst / Analytics EngineerDEFENSE AND MILITARYJanuary 2021 - June 2022 (1 year and 5 months)Paris, France• Supply Chain and inventory management reporting with Power BI.• Modeling and transforming data pipelines in a Cloud environment based on Google Cloud Platform, with structuring and industrialization of analytical transformations via DBT.• Migration of reports from Tableau to Power BI:➜ Reverse engineering of existing Tableau dashboards and adapting calculation logic to Power BI (rebuilding KPIs, translating Tableau formulas to DAX, optimizing data models)➜ User training and acculturation: presentation of new Power BI dashboards and key differences with Tableau (navigation, filters, KPI logic)➜ Operational support: assisting users, answering questions, and correcting misunderstandings during initial usage.• Designing interactive analytical applications with Streamlit to leverage AI model results and develop data application tools for business users.
Recommendations
Be the first to recommend Lilian
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Equivalence Bac +3, Formation analyse de donnéesWildCodeSchool2015Equivalence Bac +3, Formation analyse de données