Freelancer profile translated to English.

Description

+10 years of experience in Data Engineering and BI. Specialist in cloud migration and modernization of legacy BI environments.

MY EXPERTISE

Data Migration & Modernization

- Takeover of MSBI environments (SQL Server, SSIS, SSAS, SSRS) → Cloud (Snowflake, BigQuery)

- Redesign of data architectures: data warehouse, ETL/ELT pipelines (DBT, ADF, Airflow)

- Migration of Excel/SSRS reports → Power BI

Power BI Expert

- Complex dashboards: advanced DAX modeling, Power Query

- Automation of reporting and KPI monitoring

- Business user training

Cloud Data Engineering

- Snowflake / BigQuery architecture and optimization

- Modern analytics pipelines (DBT, Airflow, ADF)

- Data governance and FinOps (cloud cost optimization)

Evolutionary and Corrective Maintenance (MSBI)

- Ensure evolutionary and corrective maintenance of the Microsoft BI decision-making environment (SQL Server, SSIS, SSAS, SSRS), guaranteeing the reliability and performance of BI solutions

CLIENT RESULTS

- 40% reduction in Snowflake costs through architecture optimization (modeling, clustering, query optimization)

- Redesign of the BI system (data warehouse + reporting), ensuring data reliability and alignment of business reporting

- Deployment of data solutions fostering business adoption > 70%

- Optimization of ETL / ELT pipelines with processing time divided by 4

WHY ME

→ End-to-end vision: from data architecture to business dashboards

→ Pragmatic approach: measurable results, no over-engineering

→ Legacy + cloud expertise: I speak to historical AND modern IT teams

Available to discuss your data challenges.

Industry field of expertise

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km)

Lazeo
Analytics Engineer Snowflake & Power BI
HEALTH AND WELLNESS
May 2025 - Today (1 year and 1 month)
Courbevoie, France
In a context of strong European growth, Lazeo needed to strengthen its steering system to have reliable, secure, and consistent Power BI reporting for shareholders and business teams (HR and operations).

**Objectives**:

- Ensure the reliability of existing flows and restructure the analytical models serving the Power BI reports used by management and managers.
- Design and deploy new Power BI reports for shareholders to provide them with a clear and reliable vision of the group's performance.

KEY MISSIONS

Restructuring of analytical models
- Audit of existing flows and models (HR and operational)
- Centralization and normalization of multi-source data
- Industrialization and reliability of ELT flows (Streams, Tasks, Dynamic Tables)
- Redesign and optimization of Data Marts for analytical uses

BI & Analytical Performance
- Redesign of Power BI models and dashboards (HR: headcount, absences; Operational: performance)
- Performance optimization (tabular model, DAX, RLS)
- Harmonization and documentation of business rules and KPIs

Project Management & Data Quality
- Requirements gathering and scoping
- Definition and validation of decision-making indicators
- Functional acceptance testing and data quality control

Results:
- Provision of a consolidated and homogeneous vision of HR and operational performance across Europe
- Strengthening the reliability of strategic indicators for shareholders

TECHNICAL ENVIRONMENT:
Power BI (Desktop, Service, DAX, Power Query, RLS), Snowflake, T-SQL, Azure DevOps, Azure Data Factory
Microsoft Power BI Snowflake Azure Data Factory Analytics Engineer Data Modeling
Karavel -Promovacances & Fram
Data Engineer | Snowflake | Power BI Expert
TRAVEL AND TOURISM
January 2020 - December 2024 (4 years and 11 months)
Paris, France
**FLAGSHIP PROJECT**: Complete modernization of the group's data ecosystem on Snowflake & Power BI

CONTEXT
Fragmented legacy data environment (SQL Server, Excel, scattered reporting).
Need to centralize and validate data to provide a consolidated view to business teams.

MISSION
Transformation of the group's BI ecosystem: design of a data warehouse on Snowflake and development of unified reports on Power BI for all departments.

ACHIEVEMENTS

Data Architecture – Snowflake
- Design and modeling of the group data warehouse, aligned with business needs
- Development of high-performance ELT pipelines
- Data transformation and optimization in SQL
- Industrialization of flows and dissemination of data best practices

Strategic Reporting – Power BI
- Creation of strategic dashboards for Marketing, CRM, Finance, Operations, General Management, and Quality teams
- Advanced DAX modeling: complex KPIs and specific business rules
- Automation of refreshes and implementation of BI governance
- Implementation of security via multi-level RLS

Project Management & Adoption
- Facilitation of business workshops: gathering needs and formalizing business rules
- Functional validation of KPIs with key users
- Training of business teams and change management support
- Coordination between IT, business, and external partners

COMPLEMENTARY ANALYTICS PROJECT – GCP / BigQuery
- Implementation of price historization in BigQuery for competitive analysis
- Centralization and exploitation of traffic data to optimize marketing campaigns

IMPACT
- Unified and reliable data view for all departments
- Implementation of a modern and scalable architecture

TECHNICAL STACK
Snowflake • Power BI (DAX, Power Query, RLS) • Azure Data Factory • SSIS • SQL Server • BigQuery • GCP
Snowflake Microsoft Power BI Data Engineer Data Analyst BigQuery
Karavel -Promovacances
BI Engineer
TRAVEL AND TOURISM
July 2014 - December 2019 (5 years and 5 months)
Paris, France
Evolutionary & Corrective Maintenance – Legacy BI Environment (SSIS, SSAS, SSRS, SQLSERVER)

TECHNICAL SCOPE
Daily monitoring of a critical environment:
+100 ETL flows under SSIS, 10 SSAS cubes (multidimensional and tabular), as well as SSRS and Power BI reports covering Finance, Marketing, Operations, and Quality domains.

ACHIEVEMENTS

Reliability & Performance
- Diagnosis and resolution of technical anomalies: bugs, slowdowns, data inconsistencies
- Optimization of SQL queries and ETL processes
- Incident recovery management and proactive monitoring implementation
- Automation of data quality checks (SQL / Python scripts)

Functional Evolutions
- Enrichment of SSAS cubes: addition of dimensions, calculated measures, and business KPIs
- Integration of new data sources (APIs, flat files, third-party databases)
- Adaptation of models to meet GDPR requirements and financial audits
- Development of custom SSRS reports

Business Collaboration
- Gathering requirements and translating them into technical specifications
- User support and incident resolution related to reports
- Training business teams on the use of SSAS cubes and SSRS/Power BI reports

TECHNICAL STACK: SQL Server • SSIS (ETL) • SSAS (multidimensional & tabular cubes) • SSRS (reporting) • Power BI • T-SQL • Python • Azure DevOps
SSIS MSBI Business Intelligence Data Analyst SSAS