Freelancer profile translated to English.
Back to original languageAbout Abdou
I transform raw data into business decisions and migrate Legacy systems onDataiku, Matillion, Snowflake, dbt, and Power BI.
Senior Data Analytics Engineer · 10+ years of Data & Actuarial experience in Banking-Insurance, Health-Welfare.
6 years as a pillar of an AWS-Redshift-Snowflake analytical platform at Malakoff Humanis, today a freelancer at HaskeData.
◎ What I do best
- Customer Modeling (Data Vault, dimensional datamarts, Medallion Bronze/Silver/Gold).
- Industrialized ELT Pipelines (Matillion, dbt, Airflow, Dataiku) - tested, documented, supervised.
- KPI & Power BI dashboards / Advanced DAX : from executive steering to operational reporting.
- Governance & GDPR : data catalog (DataGalaxy, Glue, DynamoDB), quality, anonymization, traceability.
- Applied GenAI : LangChain, RAG, agents, OpenAI, Streamlit to query data in natural language.
◎ Recent Achievements
- BPIJ - AWS + Snowflake ELT Pipeline (Bronze/Silver/Gold, Dataiku, Matillion, Airflow, Grafana): processing time reduced to less than 1 hour.
- AWS + Redshift ELT Pipeline and Power BI Dashboards for health-welfare services (claims, Eckert/Pacte deadlines) - business users made autonomous.
- 10+ Dataiku DSS pipelines and MicroStrategy → SQL Server migration for 3 BPCE-IARD departments.
- Analytics LLM POC: LangChain agent querying datamarts in natural language.
◎ Stack
- SQL (expert) · Python · PySpark · R · SAS
- dbt · Airflow · Matillion · Dataiku · LangChain · Streamlit
- Snowflake · Redshift · BigQuery · SQL Server · DynamoDB
- AWS (S3, Redshift, SageMaker, Athena, DynamoDB, Glue) · GCP · Azure
- Power BI (Advanced DAX) · Tableau · Grafana · DataGalaxy
- Agile Scrum/Kanban · Jira · Teams · Miro · Confluence · XWiki
◎ Sectors
Banking · Insurance (Property & Casualty, Health, Welfare) · Actuarial Science · Solvency 2 · GDPR
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km)
Experience
- BPCESenior Data Analyst, FreelanceBANKING AND INSURANCESeptember 2025 - March 2026 (6 months)Paris, FranceMigration and industrialization of SAS & MicroStrategy projects at the IARD Performance Data Department at BPCE.- Dataiku DSS pipeline design for 10+ projects : data prep, cleaning, structuring, customer data enrichment.- MicroStrategy → SQL Server migration for 10+ existing data flows.- Automation of Power BI dashboards and WebApps for 3 operational departments (Claims, Technical Department, Management Control).- Translating business issues into KPIs and steering indicators.- Implementation of quality and GDPR compliance controls.Stack: Dataiku · Power BI · SQL Server · Python · SQL · SAS · GCP · Agile Scrum/Kanban · Jira · Teams · Confluence
- HaskedataSenior Data Analytics Engineer, FreelanceBANKING AND INSURANCEFebruary 2025 - Today (1 year and 6 months)Paris, FranceFreelance Data & AI, I help large companies industrialize their analytical pipelines and explore GenAI on their data, via Dataiku, Matillion, Snowflake, dbt, and Power BI.- Design and optimization of ELT pipelines for large clients : simplification of existing flows, customer datamart modeling.- Exploration of LLM use cases applied to datamarts : LangChain agents for natural language querying, RAG on business documentation, automatic customer data classification.- Implementation of good governance practices : data catalog, data quality, documentation.- Business dashboarding and reporting for decision-making.Stack: Python · PySpark · SQL · Dataiku · Matillion · dbt · Airflow · LangChain · OpenAI · Streamlit · Snowflake · AWS S3 · Power BI
- Malakoff Humanis (MHTech)Senior Data Analytics Engineer, Permanent ContractBANKING AND INSURANCESeptember 2019 - January 2025 (5 years and 5 months)Paris, FranceDecommissioning and Cloud Migration of legacy SAS (Statistical Analysis System) and EPM (Enterprise Performance Management) systems.6 years as a technical pillar for the AWS-Redshift-Snowflake data analytics platform of the Malakoff Humanis group, in health / welfare.- Customer data modeling and structuring : design of the customer repository in Data Vault, cross-departmental consolidation (Development, DSO, DATA), segmentation, history, hierarchies.- End-to-end Medallion Architecture (Bronze / Silver / Gold) on AWS S3 + Redshift + Snowflake, via Matillion (dbt-like pattern) - one of the flagship BPIJ projects: processing time reduced to < 1 hour.- Airflow Orchestration : multi-frequency DAGs, Grafana monitoring + Teams Webhooks alerts.- Governance & GDPR : data quality guarantor, anonymization via DynamoDB, enrichment of the DataGalaxy tool, documentation.- Cloud controls and analyses via Athena and SageMaker; INSEE IRIS web-scraping (Selenium / BeautifulSoup) for population / housing / business / family datamarts.- Power BI Dashboarding for health-welfare benefits steering: claims, payment deadlines, case backlog, Eckert/Pacte penalties - autonomous business adoption.Stack: Python · PySpark · SQL · Snowflake · Redshift · Matillion · Airflow · dbt · Dataiku · Power BI · Grafana · DataGalaxy · AWS (S3, Redshift, DynamoDB, SageMaker, Athena, Glue) · Agile Scrum/Kanban · Jira · Teams · Miro · XWiki
Recommendations
Be the first to recommend Abdou
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
- Data ScientistENSAE-ENSAI2024Machine learning, Deep learning, Analyses Big Data, Apprentissage supervisé, Apprentissage automatique, Extraction de contenu web, Apprentissage statistique, Python, PySpark, R
- STATISTICS AND ACTUARIAL ENGINEERINGINSTITUT DES MATHÉMATIQUES APPLIQUÉES (IMA), UCO2015INGÉNIERIE STATISTIQUES ET ACTUARIAT
Certifications
- SQL for Data ScienceCoursera2020
- Intermediate Python for Data ScienceDataquest.io2020