AI & Data · RP-AI-0003

Salma Othman

SeniorAnalytics Engineer

Analytics engineer and BI lead modernising enterprise warehouses on Databricks, AWS, dbt and SAP Datasphere

  • Identity verified
  • Remote Pro Ai team member · under contract

Availability on request

  • 6yearsprofessional experience
  • SeniorSeniority level
  • SQLPrimary stack
  • CairoBased in · Egypt · GMT+2

Salma Othman

Profile summary

Analytics engineer with 6 years of experience designing data warehouses, lakehouses and semantic models for banking, retail and FMCG enterprises. Currently leads the migration of Coca-Cola Hellenic finance dashboards from SAP BW to a Data Mesh architecture on Azure Databricks. Previously built dbt Core models and Power BI reporting at b-labs, delivered SAP Datasphere and SAP Analytics Cloud warehouses at SDG Group, and engineered MIS pipelines at National Bank of Egypt. Combines hands-on modelling with an MBA and a record of mentoring early-career data talent.

  • Languages

    • ArabicNative
    • EnglishProfessional (TOEFL 640/670)
  • Sectors

    • Banking
    • Retail
    • Fintech
    • Healthcare

Salma Othman

5 roles

Experience

Most recent role first, with outcomes as stated in the CV.

  1. Senior BI Developer

    Coca-Cola Hellenic

    – PresentCairo, Egypt

    • Leads the migration of finance dashboards from the legacy EDGE platform (SAP BW) to a new Data Mesh architecture on Azure Databricks.
    • Redesigns data models and visualisations for consistency, scalability and performance in the new environment.
    • Develops new finance dashboards that strengthen reporting and decision-making.
  2. Lead BI Developer

    b-labs

    – Cairo, Egypt

    • Led the mylo data-warehouse implementation, designing a dbt Core data model that integrates distributed systems (PostgreSQL on Amazon RDS, PostHog, SQL Server).
    • Delivered business-aligned reporting in Power BI and Metabase.
  3. Senior BI Developer

    b-labs

    – Cairo, Egypt

    • Built and maintained the B.TECH Data Lakehouse, integrating DB2 data into Amazon S3 for a scalable, analytics-ready architecture.
    • Re-engineered data infrastructure and automated manual workflows with Amazon S3 and Amazon Athena for the Order Management System and Sales rebuild projects.
    • Mentored a cohort of 20 candidates in the b-Next early-career data programme, teaching dimensional modelling, SSIS and Power BI through hands-on case studies.
    • Built Power BI dashboards delivering actionable insights to customer and business teams.
  4. Data Analytics Consultant

    SDG Group Middle East

    – Cairo, Egypt

    • Built the Magrabi data warehouse on SAP Datasphere and S/4HANA, with SAP Analytics Cloud reporting for executive, product and data teams.
    • Revamped and validated the H-S-A data warehouse, reverse-engineering financial data from ERP systems and building SAP ERP extraction pipelines.
    • Enhanced the B.TECH data warehouse with SQL, SSIS and SSAS pipelines across a wide variety of sources.
  5. Specialist (B) – Data Engineer

    National Bank of Egypt

    – Cairo, Egypt

    • Built ETL infrastructure and reporting for the Central Bank Initiatives Analytics MIS, supporting analytics teams on reporting requirements.
    • Evaluated source-system changes, tested new software releases and trained end users on new reports and dashboards.

Salma Othman

4 projects

Selected projects

Shipped titles and products, with the role played on each.

  • Coca-Cola Hellenic – Finance Dashboards Migration

    Migration lead

    Migration of finance dashboards from SAP BW to a Data Mesh architecture, with remodelled data models and new dashboards.

    Built with

    • Azure Databricks
    • SAP BW
    • Data Mesh
  • mylo – Data Warehouse Implementation

    Lead BI developer

    Unified data model over distributed systems with dbt Core, feeding Power BI and Metabase reporting.

    Built with

    • dbt Core
    • PostgreSQL
    • Amazon RDS
    • Power BI
    • Metabase
  • B.TECH Data Lakehouse

    Senior BI developer

    Analytics-ready lakehouse integrating DB2 data into Amazon S3, powering Order Management System and sales dashboards.

    Built with

    • Amazon S3
    • Amazon Athena
    • IBM Db2
    • Power BI
  • Magrabi – DWH Build

    Data analytics consultant

    Data-warehouse build with SAP Datasphere pipelines and SAP Analytics Cloud reporting.

    Built with

    • SAP Datasphere
    • S/4HANA
    • SAP Analytics Cloud

Salma Othman

8 core skills

Skills

Core skills first, then the full toolkit by theme.

Core skills

  • SQL
  • Power BI (DAX, Tabular)
  • Dimensional Data Modelling
  • dbt Core
  • Azure Databricks
  • AWS (Glue, S3, Athena)
  • SAP Datasphere
  • SSIS / SSAS
  • Data warehousing & modelling

    • Dimensional modelling
    • Data Mesh
    • Lakehouse architecture
    • dbt Core
    • SSIS
    • SSAS (Tabular, MDX)
  • Cloud data platforms

    • Azure Databricks
    • AWS Glue
    • Amazon S3
    • Amazon Athena
  • SAP analytics

    • SAP Datasphere
    • SAP Analytics Cloud
    • SAP HANA
    • S/4HANA
    • SAP BW
  • BI & reporting

    • Power BI
    • DAX
    • Metabase
    • Jasper Reports
  • Databases & languages

    • SQL Server
    • PostgreSQL
    • IBM Db2
    • SQL
    • Python

Salma Othman

Education, certifications and awards

Degrees, certifications and awards on record.

Education

  • Master of Business Administration (MBA)Arab Academy for Management, Banking and Financial Sciences · 2022
  • B.Sc. Business Information SystemsSadat Academy for Management Sciences · 2020

Certifications

  • Exploring SAP Datasphere (badge)SAP · 2023
  • Data Analyst NanodegreeUdacity · 2022
  • Analyzing and Visualizing Data with Power BI (certificate of attendance)Microsoft · 2022

Awards and recognition

  • Graduated fourth in class with a cumulative GPA of 3.75 (Excellent)

Salma Othman

Usually works with

Roles this profile is usually paired with in a squad.

AI & Data

Bring this profile into your squad

Add the role and level to the Squad Builder; availability is confirmed with your quote.

Availability on request