Freelancer profile translated to English.
Back to original languageAbout Sofiane
Senior BI Consultant & Power BI Expert — Governance, Audit & Applied AI to BI
I help companies design reliable, high-performing, and governed BI environments to transform their data into concrete decisions. From audit to industrialization, I work across the entire analytical value chain.
They trusted me:Suez, L'Oréal, a historic French luxury house, Viatris, Digicel, Allianz on Supply Chain, Finance, E-Commerce, and Commercial Excellence (luxury, pharma, telecom, energy, insurance) challenges.
WHY COLLABORATE WITH ME?
Over 8 years of experience, from strategic scoping to production.
Dual role as consultant and Product Owner:I define needs, structure the backlog, prioritize value, and communicate with both technical teams and business management.
Proactive:I challenge needs, make recommendations, and anticipate risks.
Business/Data Interface: I facilitate workshops and make data actionable.
Architect Vision:Robust semantic models (DAX, star schema, RLS).
MY SERVICES
BI Audit & Consulting:Diagnosis of reports, models, and practices (performance, reliability, security) and an actionable roadmap.
Governance & Industrialization:CI/CD GitLab, PBIP/TMDL, multi-environment deployments, RLS, usage monitoring.
Semantic Model Optimization:Optimized DAX, DirectQuery on Snowflake, fast and maintainable models.
UI/UX Design: User-friendly, action-oriented, and genuinely adopted reports.
AI & Agentic Systems:Agentic BI Development, MCP servers connected to Power BI, assisted DAX measures.
Reporting & Training: From source to decision, and upskilling teams.
STACK:
Power BI (DAX, Power Query/M, RLS, PBIP/TMDL, Tabular Editor, DAX Studio), Microsoft Fabric, Snowflake, dbt, SQL, Python, GitLab CI/CD, BigQuery.
Let's talk about your project.
S.B
English
Fluent
French
Native or bilingual
Arabic
Native or bilingual
Can work on-site
Paris (up to 50km)
Experience
- Xplore ConsultSenior Power BI/Data ConsultantCONSULTING AND AUDITSAugust 2021 - Today (5 years)Paris, FranceI help businesses turn data into insights that drive growth and success.From designing data models to creating comprehensive dashboards and reports, I use a range of analytical tools and techniques to identify trends, patterns, and opportunities that can be leveraged to improve business performance.I've worked with companies in different sectors with different teams like Suez, L'Oréal, Viatris, Allianz, Digicel, Algoé, DGFiP and Taiwan Trade Center in the past.
- SUEZ Digital Solutions
On Malt
Power BI Reporting Development Project | Environmental Digital Platform ProjectENERGY AND UTILITIESJuly 2025 - April 2026 (9 months)PARIS LA DÉFENSE, FranceSUEZ — Power BI & Piano Analytics Consultant | Environment & Public Services Sector | Environmental Digital Platform ProjectContext: Design of a web/app decision-making solution for managing a digital platform deployed with local authorities, in a multi-source and multi-contract environment.Achievements:- Architecture & Modeling: Multi-source Power BI model (Piano Analytics, GA4, Azure Logs, App Stores, APIs) in a star schema, with dynamic RLS by region and contract
- Advanced API Integration: REST connection (Piano, App Stores, Azure), OAuth2/token management, pagination, JSON stream transformation via Power Query (M)
- Piano Analytics Expertise: Design of advanced Data Queries, custom segments and calculations, utilization of Piano APIs and creation of complementary native dashboards
- DAX & Power Query Development: Advanced indicators (time intelligence, cohorts, engagement, web/app KPIs) optimized via DAX Studio
- Dynamic Dashboards for 50+ Users: Web/app KPIs, mapping, scope filters, drill-through, and bookmarks
- Workspace Deployment & Management: Dev/Testing/Production organization, Dataflows, gateways, refresh schedules, and access rights
- Cross-functional collaboration with business teams (needs, testing) and Data & Cloud (Azure streams, Fabric)
- Comprehensive technical and functional documentation
Environment: Power BI (Power Query, DAX, DAX Studio, M Code, Dataflows, Workspaces), Microsoft Fabric, Piano Analytics (Data Query, APIs), Azure (Logs, REST APIs, OAuth2). - SUEZ Digital SolutionsTMA Mission for Digtal Solutions Power BI ReportsENERGY AND UTILITIESJuly 2025 - December 2025 (6 months)PARIS LA DÉFENSE, FranceTMA Mission — Assistance, anomaly detection on Power BI reports, and evolution management
- RUN & support of Power BI reports for business teams and the Data Team
- Audit and anomaly detection: data consistency, model performance, DAX measures, Power Query queries
- Root cause analysis and incident resolution.
- Management of evolutions on complex reports: star schema, advanced DAX, time intelligence, RLS
- Deployment process via the Power BI service: Dev/Test/Prod pipelines, gateways, refresh schedules, access management
- Continuous interaction with business teams (gathering requirements, testing) and the Data Team (data flows, data model)
- Technical and functional documentation kept up to date
Technologies: Power BI Desktop & Service, DAX, Power Query (M), SQL, Power BI deployment pipelines, on-premise gateways, Azure Devops
Reviews
Recommendations
Be the first to recommend Sofiane
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
- International Master in Numerical computations EngineeringUniversity of Pau and Adour Country
- State Engineering DegreeNational Polytechnic School of Algiers
Certifications
- Deep Learning SpecializationCoursera by Deeplearning.ai2020