Freelancer profile translated to English.
Back to original languageAbout Vame
Analytics Engineer & Power BI Expert — Performance & Reliability
I step in when BI becomes a **bottleneck for management**:
contested figures, unstable pipelines, dashboards too slow to make decisions.
My role:rebuild a reliable and performant analytical chainwith **Snowflake**, **dbt**, and **Power BI**, so that business teams can finally focus on decisions and not on the quality of the figures.
Recent Impact
Optimizationof a critical workflow:18h → 15 minof data loading time
Implementation ofSemantic Layer**: **Harmonizationandvalidationof KPIs → with indicators finally aligned between Tech and Business.
Creation ofDatavizualizationproducts: Development of personalizedPower BIreports and dashboards →+50 industrialized reports
What I do concretely
- **BI Performance**: query optimization and refresh times (Snowflake, BigQuery, SQL)
- **Architecture & Modeling**: redesign of analytical models (Star Schema) and ELT pipelines (dbt, Python)
- **Data Governance**: RLS, traceability, documentation, and validation of business rules
- **Decision-making Power BI**: clear, readable dashboards actually used by teams
Observed Results
- 30+ redesign and optimization projects delivered
- Reliable data and significant reduction in inconsistencies
- Accelerated business decisions thanks to actionable reporting
Environments
Tech, Media, Industry & Luxury — contexts with high data stakes
(Believe, Havas, Volvo, Safran)
📞 First discussion
I propose an exploratory 30-minute discussion to quickly diagnose the state of your BI and identify priority levers.
French
Native or bilingual
English
Fluent
Remote only
Primarily works remotely
Experience
- Pernod Ricard SAAnalytics Engineer & Power BI Expert – Power BI | Snowflake | dbtWINE AND SPIRITSFebruary 2026 - Today (4 months)Paris, FranceAnalytics Engineerfreelance integrated into Pernod Ricard's Consumer squad, I work on centralizing and modeling the marketing data ecosystem (digital & physical) using a **modern data stack**: dbt (SQL models, tests, DAG, SCD2), Snowflake (cloud data warehouse), and Power BI (reporting & decision-making dashboards). Version control and deployment via Git / GitHub.
- BelieveData Analyst & Analytics Engineer | Lead Power BI, Snowflake, SQLFILM AND AVDecember 2024 - January 2026 (1 year and 1 month)Paris, FranceIndustrialization of the BI chain for the Sales, Digital, and Marketing teams of a digital music leader. Environment with highdata volume(Big Data) requiring a shift from manual management to **a robust decision-making architecture**.
Challenges:
- Ensure data reliability (Single Source of Truth) against contested KPI calculation rules.
- Secure and automate Marketing and Media reporting.
Interventions & Technical Stack:
🚀 Analytics Engineering & Architecture (Snowflake / SQL):- **Redesign of ELT pipelines**: Design and orchestration of complex flows (Stored Procedures, Tasks, Tables) to transform raw data into usable models.
- **Data Modeling**: Creation of star schemas optimized for "Creator" campaign management and sales performance.
- **Data Quality**: Implementation of business rules to ensure data integrity across teams.
📊 Visualization & Business Intelligence (Power BI):- **C-Level Dashboard Design**: Creation of interactive, "action"-oriented dashboards for budget and royalty tracking.
- **UX/UI Optimization**: Structuring management tools for Digital Managers, reducing analysis complexity.
⚙️ Methodology:- Scoping business needs and coordinating stakeholders.
- Agile delivery.
✅ Results & Impact:
- **Productivity Gain**: Reduction of >50% in campaign management time for managers.
- **Governance**: Aligned and validated KPIs across Product, Sales, and Marketing departments (end of "figure wars").
- **Performance**: Industrialized processing chain, reducing loading times and manual interventions.
- Safran Electrical & PowerData Analyst & Analytics Engineer – BI Finance & Supply Chain | Power BI & RedshiftAVIATION AND AEROSPACESeptember 2023 - November 2024 (1 year and 2 months)Toulouse, FranceMission to rebuild and industrialize the decision-making system for the IT department (Finance & Supply Chain). Intervention in a complex environment requiring a shift from fragmented reporting to agoverned and auditable BI architecturewith **Power BI and RedShift**.
Challenges:
- Ensure the reliability of financial data (Single Source of Truth) to align IT and Business.
- Secure access to sensitive data and reduce technical debt (decommissioning of obsolete tools).
Interventions & Technical Stack:
🏗️ Data Modeling & Architecture (SQL Server / Redshift):- **Data Model Redesign**: Reconstruction of star schemas, optimization of primary keys and joins for performance.
- **Analytics Engineering**: Industrialization of business rules for critical KPIs (Gross Margin, COGS, P&L, ROS).
- **Technical Documentation**: Mapping of flows and data dictionary (Confluence) to ensure maintainability.
📊 Visualization & Reporting (Power BI / SSRS):*Dashboard Industrialization**: Development of **Power BI& SSRS reports connected to Redshift and on-premise.- **Advanced Security**: Implementation of dynamic row-level security (RLS) to compartmentalize sensitive data by entity/profile.
⚙️ Governance & Methodology:- Project management usingAgile/Scrummethods (Rituals, Backlog).
- Lifecycle management and versioning via **Azure DevOps**.
✅ Results & Impact:
- **Robustness**: Stabilized and maintainable BI system, drastic reduction in incident tickets.
- **Performance**: Significant time savings on maintenance and data refresh.
- **Adoption**: Increased autonomy for Finance & Supply Chain teams thanks to reliable and documented data.
Reviews
Recommendations
HD
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
- MBA Data Solution ArchitectÉSTIAMBig Data & Business Intelligence
Certifications
- Spark Python, developing applications for big dataORSYS2023
- Microsoft Certified: Power BI Data Analyst AssociateMICROSOFT2023