Freelancer profile translated to English.
Back to original languageAbout Oussama
Senior Analytics Engineer | Expert Microsoft Fabric, Azure Data Factory, dbt & Power BI
(Microsoft Certified DP-600, DP-700 & PL-300)
I support CIOs and business departments (Finance, Banking, Insurance, Industry) in building modern Data Platforms on Microsoft Fabric and modernizing their data flows with dbt.
With over 6 years of experience, I design scalable Lakehouse architectures (Medallion), robust data models (Star Schema, Data Vault), and optimized Power BI reports in Direct Lake mode.
Microsoft Fabric Expertise : Mastery of the ecosystem for your migrations to Lakehouse and/or Data Warehouses and the implementation of the Medallion architecture, ensuring certified data and optimized Power BI reports in Direct Lake mode.
Power BI Expertise : Design of robust data models (Star Schema, Data Vault) ensuring reliable, scalable, and error-free reports and dashboards.
DataOps Culture : Industrialization of your data flows through automation (CI/CD), Git versioning, and code quality with dbt.
🛠️ MASTERED TECHNICAL STACK
📌 MICROSOFT FABRIC
Microsoft Fabric Ecosystem : OneLake, Lakehouse (Spark), Data Warehouse (T-SQL).
Ingestion & Orchestration : Data Factory (Pipelines), Dataflows Gen2, Mirroring, Shortcuts.
Admin & Governance : P-SKU to F Fabric Migration, Security & RLS.
Transformation : dbt (dbt-fabric), SQL, Python (Notebooks).
DevOps : Azure DevOps, Git Integration, CI/CD Deployment Pipelines.
📌 MICROSOFT POWER BI
Modeling : Star Schema, Data Vault 2.0.
Performance : Direct Lake Mode, Complex DAX, Semantic Models.
Design : UX/UI for financial dashboards, Data Storytelling.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km), Marseille (up to 50km), Lyon (up to 50km), Lille (up to 50km), Nantes (up to 50km)
Experience
- Orange GroupeAnalytics Engineer || Microsoft Fabric | DBT | BigQuery | Power BI | FinanceTELECOMMUNICATIONSMay 2025 - Today (1 year and 1 month)Paris, FranceProject carried out as part of a technical debt reduction program on a large-scale decision-making project, covering dozens of complex reports related to Corporate Finance processes.Functional scope - non-exhaustive listCFO Reporting (strategic steering indicators)Tracking of committed expenses (CAPEX / OPEX)Workforce and headcount analysisMulti-system financial reconciliation: EPM (IBM Analytics) | Financial Consolidation (SAP BFC / ex-Magnitude)ObjectivesImprove the maintainability and readability of Power BI reportsReduce calculation redundancies and inconsistenciesRapid transition to industrializationOptimize query and processing performanceEnsure reliability of inter-system reconciliationsStandardize data models and development practicesAs an Analytics Engineer, my tasks are as follows:- Gathering and scoping requirements with business stakeholders- Data transformations with DBT within a medallion architecture (bronze, silver, and gold)- Best practices for dbt and Power BI data modeling- Semantic model design (star schema data model)- Deployment and GITLAB integration- Internal PoCs around Microsoft Fabric (Shortcuts, pipelines, Dataflow Gen2, lakehouse, warehouse, semantic model).Technical Environment: Microsoft Fabric, Power BI, DBT, Jira, BigQuery, Data Warehouse, Lakehouse, GCP, GitLab
- Orange BankAnalytics & Data Engineer Azure | AWS | MSBI | Microsoft Power BIBANKING AND INSURANCEJanuary 2022 - April 2025 (3 years and 3 months)Paris, FranceProject carried out within a digital bank operating in a highly competitive environment, with a major focus on optimizing the decision-making chain and improving the availability of strategic data.Context & ChallengesStrengthening operational efficiencyEnsuring reliability and accelerating decision-making data flowsImproving the responsiveness of business reportingSupport for banking and post-banking activitiesInvolvement in several strategic projects:Ozark: anti-money laundering (compliance)Oscamps: regulatory reporting for the French central bankHello Bank (divestiture): customer data management and valuationAs an Analytics Engineer, my main achievements are below:- Gathering and scoping business requirements- Design, development, and optimization of multi-source ETL flows: Databases (PostgreSQL, SQL Server), Flat files, Excel, third-party applications (SAB, Salesforce, Service Layer)- Development of T-SQL scripts, stored procedures, and views for automation and analysis- Creation of Power BI reports and dashboards for customer tracking and business indicators- Performance of unit tests (DTA) and participation in production deployments- Application RUN management (ETL, reporting, files)- Implementation of CI/CD pipelines via TFS and Azure DevOps- Writing technical documentation- Incident management and level 2/3 support- Ad hoc analysis on data quality and consistencyEnvironment: AWS Cloud, Azure Cloud, Data Warehouse, ETL (Azure Data Factory, SSIS), Airflow, Data Lake, Data Warehouse, Data Architecture, Azure DevOps
- Malakoff HumanisAnalytics Engineer Power BI | MSBI | FinanceBANKING AND INSURANCEJanuary 2019 - January 2021 (2 years)Paris, FranceProject carried out as part of the redesign of the supplementary health insurance offer to meet new policyholder expectations: access to care, prevention, proximity, and social responsibility.Context & ChallengesStructuring and managing a new health insurance offeringOptimizing data flows and ensuring data reliabilityProviding key indicators for business departmentsMain AchievementsDesign and modeling of a DataMart for the new offeringDevelopment of SSIS packages for data integration from Excel filesAnalysis and control of functional data quality using T-SQLDesign and development of a tabular SSAS cubePopulating and automating DataMart loadsDevelopment and maintenance of Power BI reportsAnalysis of sales data and anomaly trackingSupport for user acceptance testing and production deploymentTechnical Environment: MSBI: SSIS, SSAS, T-SQL, MSBI, Microsoft Power BI
Recommendations
Be the first to recommend Oussama
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
- Finance and Information SystemsIAE Tours2018Double compétence Data science et Management
Certifications
- DP-700 Microsoft Fabric Data EngineerMicrosoft
- DP-600 Microsoft Analytics EngineerMicrosoft