Freelancer profile translated to English.
Back to original languageAbout Rafik
Senior Power BI & Analytics Engineer, I work on the entire data chain, from modeling and transformation (Snowflake, BigQuery, Databricks, SQL) to the design of complex tabular models under Power BI Premium (star schema, SCD, DAX optimization). I industrialize high-performance, governed business intelligence solutions in high-volume environments, integrating a UX approach focused on readability, business adoption, and visual performance.
French
Native or bilingual
English
Native or bilingual
Can work on-site
Paris (up to 50km)
Experience
- EquansLead Analytics Engineer - Cyber Data PlatformENERGY AND UTILITIESFebruary 2025 - Today (1 year and 4 months)Paris, FranceDesign and deployment of a Snowflake + Power BI Premium data cloud architecture to centralize multi-source cybersecurity data (Ivanti, CrowdStrike, AD, etc.).Implementation of an AWS data warehouse (S3) structured in Raw / Staging / Analytics layers with IAM governance and DEV/PROD separation.Development of Snowflake + dbt pipelines: schema standardization, historization (SCD), SQL optimization (CTE, window functions), and transformation industrialization.Implementation of Azure DevOps CI/CD for Power BI models and analytical artifacts (versioning, traceability, secure deployment to Premium capacity).Automation of ingestion flows (API, UiPath) with error management, monitoring, availability checks, and BI refresh orchestration.Integration of automated data quality controls (completeness, consistency, uniqueness) into Snowflake/dbt pipelines.Advanced cybersecurity analysis: anomaly detection, multi-source correlations, incident segmentation, time-series analysis.Implementation of statistical methods and criticality scoring integrated into Power BI models to produce business intelligence indicators.Performance optimization: Snowflake tuning (warehouses), DAX optimization, technical debt reduction, monitoring via logs and usage metrics.Integration of AI / MCP components into secure pipelines, with separation of business rules, automations, and compliance requirements.
- LynxeoTech Lead Data Power BIENERGY AND UTILITIESJanuary 2024 - February 2025 (1 year and 1 month)Paris, France• Leading the implementation of group BI governance following the Lynxeo / Nexans carve-out: definition of standards, structuring of environments (DEV / TEST / PROD), securing deployments, and industrializing development practices.• Strategic migration of the Business Objects ecosystem to Power BI, including refactoring semantic models, rationalizing existing reports, and aligning with business objectives (finance, supply chain, sales, legal, cyber).• Transition from a Power BI Pro capacity to Microsoft Fabric / Premium, optimizing capacity consumption, improving performance (advanced DAX, query folding, technical debt reduction), and monitoring via Log Analytics.• Definition and deployment of an international access security and governance framework (RLS, Azure AD, IAM), ensuring compliance and separation of entity/business scopes.• Design and implementation of an AWS data lake dedicated to cybersecurity data, centralizing heterogeneous sources (Ivanti, CrowdStrike, etc.), with automated ingestion via API (UiPath), structured S3 storage, and flow traceability.• Implementation of transformation pipelines under Snowflake and dbt to standardize, historize, and model data before exposure in Power BI analytical layers.• Deployment of automated data quality mechanisms (consistency, completeness, uniqueness checks) integrated into BI processes and pilot indicators.• Integration of AI / MCP components into governed analytical pipelines, ensuring separation of business rules, automation mechanisms, and regulatory compliance requirements.Technical environment:Power BI (Desktop, Service, DAX, Tabular Editor), Microsoft Fabric / Premium, AWS (S3, IAM), Snowflake, dbt, UiPath (API), Azure (AD, Log Analytics, DevOps), SAP, Oracle, Business Objects, Power Automate.
- TF1Data Engineer: Audience Measurement and Quality Control PlatformsPRESS AND MEDIAFebruary 2023 - February 2024 (1 year)Boulogne-Billancourt, FranceDevelopment of Power BI semantic models and reports with a deployment pipeline in premium capacity for the analysis of audience measurement waves and data for marketing and sales/advertising teams.• Creation of a quality control report (consistency, uniqueness, etc.) for tables used in the BI department's data engineering.• Performance analysis and optimization of processes and DAX measures for minimum report response time.• Collection and formalization of technical specifications and data set modeling to minimize premium server processing time.• Facilitation of business workshops and proactive proposals for data visualization solutions for each identified need.• Implementation of a design and UX following TF1's graphic charter.• Implementation of documentation on Confluence.• Migration of Qlik reports to PowerBITechnical environment: Power BI desktop/service (DAX, Power Query, Tabular Editor…), Microsoft Fabric, Log Analytics, Power Automate, Azure DevOpps, QlikView, Figma, Azure Databricks, SQL Server
Reviews
Recommendations
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
- Master of Management, MIS (Management of Information Systems) track, Business Administration and Management, GeneralIÉSEG School of Management2019Master of Management, MIS (Management of Information Systems) track, Business Administration and Management, General
- Executive Certificate, Artificial Intelligence: Implications for Business StrategyMassachusetts Institute of Technology - Sloan School of Management2018Executive Certificate, Artificial Intelligence: Implications for Business Strategy
Certifications
- PL300Microsoft2022
- AZ900Microsoft2020