About Lilian
French
Native or bilingual
English
Fluent
Experience
- Crédit agricole SAData Analytics & Engineering Lead / Head of SI & Cybersecurity DashboardsBANKING AND INSURANCEJanuary 2025 - April 2026 (1 year and 3 months)Paris, France• Gathering and formalizing business requirements in close collaboration with business teams, designing, and developing group Cybersecurity and IT 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.• Continuously improving reporting ergonomics and structure (UI/UX, graphic charter) to facilitate their evolution while respecting business needs.• Analytical and technical referent: mentoring, disseminating best practices for modeling and data quality.
- BNPPData Analyst / Analytics EngineerJuly 2022 - February 2026 (3 years and 7 months)Paris, France• Designing analytical reports and strategic dashboards for the Group Legal department via Tableau Software to facilitate activity monitoring and key indicator tracking.• Designing high-performance semantic models (Azure Analysis Services tabular models): star schema modeling / data vault modeling to organize relationships between tables and integrate data in an optimized and clear manner into reports.• Advanced use of Azure Data Factory: designing high-performance pipelines, integrating and joining multi-source data, developing reusable components (datasets, linked services, parameterized pipelines), and automating processes via scheduled triggers.• Leveraging the Microsoft Azure ecosystem (Azure Data Lake Storage, Azure Data Factory) to industrialize the ingestion and processing of data from heterogeneous sources (on-premise, PostgreSQL databases), implementing robust and scalable pipelines.• Advanced use of Alteryx and Dataiku: designing high-performance workflows, integrating and joining multi-source data, developing reusable macros, and automating processes via task scheduling.• Preparing optimized datasets to meet RLS, historization, and performance challenges. Implementing good versioning 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.• 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 adaptation of calculation logic to Power BI (reconstruction of KPIs, transposition of Tableau formulas to DAX, optimization of data models)➜ User training and acculturation: presentation of new Power BI dashboards and key differences with Tableau (navigation, filters, KPI logic)➜ Operational support: user assistance, answering questions, and clarifying misunderstandings during initial use.• 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