Pamela LEKPA
FR EN

Data Engineer · Paris region

Pamela LEKPA,
from raw data to a reliable indicator

Data Engineer and SQL Server DBA. I design pipelines, data warehouses and Power BI dashboards for large enterprise clients.

Azure Data Factory SQL Server Power BI Databricks DBT SSAS
Get in touch See my projects

From source to decision

The data lifecycle

Every project follows the same thread: raw data is collected, filtered, transformed, stored, then visualised to become a reliable indicator.

1Collection2Filtering3Processing4Storage5Visualisation6Operations
  1. 1

    Collection

    Ingesting data from source systems into the platform.

    • Azure Data Factory

    Projects: Pernod Ricard · King Jouet · Chanel

  2. 2

    Filtering

    Quality control, cleaning and purging: keep only useful, accurate data.

    • SQL Server

    Projects: Bolloré · Chanel

  3. 3

    Processing

    Transformation and modelling: joins, aggregations and business rules.

    • Databricks
    • dbt

    Projects: Pernod Ricard

  4. 4 Data WarehouseDatamart

    Storage

    Data warehouse, datamarts and a semantic model ready for analysis.

    • SQL Server

    Projects: Candriam · Chanel (SSAS)

  5. 5

    Visualisation

    Power BI reports and dashboards to inform decisions.

    • Power BI

    Projects: Pernod Ricard · King Jouet · Chanel

  6. 6

    Operations

    Monitoring, database optimisation and CI/CD pipelines.

    • Azure DevOps
    • SQL Server

    Projects: Airbus

Visualisation

Making data readable

Sample business-intelligence report, in the spirit of those I build with Power BI. Illustrative data.

Rows ingested12.4M
Rejection rate0.8 %
Pipeline duration18 min
Freshness< 1 h
Sales by region (M€)
Europe84Americas66Asia72Africa38Oceania24
Product mix
100 %
  • Product A 42 %
  • Product B 28 %
  • Product C 18 %
  • Others 12 %
Monthly trend
JFMAMJJASOND
Quality score by source
Pernod
94
King
81
Chanel
76
Airbus
63
Candriam
55

Tools

My tech stack

Expertise

Skills

Expertise level

SQL Server DBA75 %
Azure Data Engineer50 %

Technologies by number of projects

SQL Server
5
Power BI
3
ADF
3
Databricks
1
DBT
1
SSAS
1
Azure DevOps
1
Across the 6 projects listed below.

Pernod Ricard

May – Jul 2023

Tech lead data engineer

Setting up a Power BI report on goods shipping.

ADFDatabricksDBTPower BI

King Jouet

Feb – May 2023

Tech lead data engineer

Adding indicators to an existing Power BI dashboard.

ADFSQL ServerPower BI

Chanel

Nov 2022 – Jan 2023

Data engineer

Adding indicators to a Power BI dashboard and handling customer tickets about KPI accuracy.

ADFSSASSQL ServerPower BI

Airbus

Feb 2021 – Mar 2022

SQL Server DBA

Monitoring and optimising databases, setting up CI/CD pipelines.

SQL ServerAzure DevOps

Bolloré

Oct – Dec 2020

SQL Server Developer

Developing a data purge framework.

SQL Server

Candriam

Jan 2019 – Feb 2020

SQL Server Developer

Setting up a data warehouse and a datamart.

SQL Server

Education

Education

  • Université de Versailles Saint-Quentin-en-Yvelines
    Master's degree (M2) in Data Management in a Digital World    2016 – 2017
  • ENSIIE
    Engineering degree in computer science    2014 – 2017
  • Université d'Évry
    Bachelor's degree (L3) in mathematics    2014 – 2015
  • Lycée Marcelin Berthelot
    Scientific preparatory classes (years 1 and 2)    2012 – 2014

Let's talk data

Contact

A data project, a Power BI or SQL Server need? Drop me a line.

pamela@lekpa.fr 07 52 24 31 71