Freelancer profile translated to English.

Description

Data analyst / engineer focused on Power BI with the implementation of Dashboards and Reports for Data analysis by identifying and implementing KPIs in DAX.

Advanced experience in SQL data engineering, SSIS, Databricks, Azure and AWS.

Strong experience in the Retail sector.

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent
Arabic
Native or bilingual

Workplace preferences

Can work on-site

Lille (up to 15km), Paris (up to 15km)

Celio
Data Engineer SSIS | Database administrator
RETAIL (LARGE RETAILERS)
October 2024 - Today (1 year and 8 months)
Paris, France
ETL Management:
Supervise and maintain existing ETL flows with SSIS for ingesting data from various sources.
Report updates to SSIS flows to integrate new data sources.
Modernized and optimized ETL processes to improve efficiency and reduce processing costs.
Participate in workshops with business stakeholders to integrate new requirements into ETL.
Participate in workshops for migrating SSIS flows to GCP.
Use VTOM for orchestrating SSIS package launches and ensure proper package execution.
Database Administration on SQL Server on premises:
Create and administer SQL Server databases for critical applications.
Optimize SQL queries and indexes, reducing application response times.
Automate database backup and restore processes, ensuring fast and reliable recovery when needed, allowing for restorations as required.
Performed data restores from snapshots and backup points for test and production environments.
Monitor database performance using a Power BI report connected to tables populated by data collection scripts.
Microsoft SSIS Extract, transform, load (ETL) SAP HANA SAP BW SQL Server
Total Energies (Mobility Business) | Waykonect
Data Analyst | Database adminis
TECH
January 2023 - September 2024 (1 year and 9 months)
Lille, France
Data Analysis:
Created interactive reports and dashboards with Power BI to provide decision-making insights to business teams.
Regular exchanges with key stakeholders to identify data sources and define needs, analysis areas, and KPIs.
Modeling of Business DataSets in Power BI (design of star schemas, data cleaning…)
Data extraction from databases.
Developed advanced data models to improve the quality and relevance of analyses.
Integrated Power BI with Databricks on AWS to analyze massive data volumes.
Participated in SSIS to Databricks migration workshops.
Database Administration (maintenance plan, partitioning.)
ETL Management:
Supervised and maintained existing ETL flows with SSIS and Azure Data Factory for ingesting data from various sources.
Migration of the infrastructure to a new version.
Modernized and optimized ETL processes to improve efficiency and reduce processing costs.
Created and administered SQL Server and PostgreSQL databases for critical applications on AWS and Azure.
Implemented Multi-AZ instances on AWS and geo-distributed replicas on Azure to ensure high availability.
Optimized SQL queries and indexes, reducing application response times.
Automated database backup and restore processes, ensuring fast and reliable recovery when needed with point-in-time restores, allowing for restorations as required.
Performed data restores from snapshots and backup points for test and production environments.
Monitored database performance using CloudWatch and Azure Monitor.
Microsoft Power BI AWS RDS AWS Microsoft Azure SQL Server PostgreSQL Python Databricks Data analysis ETL Microsoft SSIS
Celio
Data Analyst Power BI
RETAIL (LARGE RETAILERS)
August 2022 - December 2022 (5 months)
Paris, France
Regular exchanges with key stakeholders to identify data sources and define needs, analysis areas, and KPIs.
Model Business DataSets in Power BI (design of star schemas, data cleaning…)
Creation of Dataflows on Power BI services to feed all data sources and perform necessary transformations.
Define appropriate KPIs and optimize calculation rules based on available data: Profit margin, Churn rate, Cumulative sales…
Creation of DAX formulas and measures with Tabular Editor.
Optimize the number of measures using Calculation Groups with Tabular Editor.
Deployment and Management of Shared Datasets and Workspaces on Power BI service.
Creation of interactive and informative Power BI reports using advanced DAX functions.
Perform data analysis and generate insights based on business needs.
Ensure continuous maintenance and development of bug fixes for existing and new Power BI reports.
DBA
Participation in the implementation of a hardware architecture.
Design of SSIS data flows (parameterization, parallelism, redesign, infrastructure).
Creation and maintenance of T-SQL scripts to query SQL Server databases.
Development of stored procedures to automate data processing tasks.
Optimization of T-SQL query and stored procedure performance (execution plan analysis, use of Database Engine Tuning Advisor, implementation of partitioning and Maintenance Plan).
Participate in testing, implementation, and documentation of ETL solutions.
Ensure data quality and integrity throughout the ETL process.
Database Administration (maintenance plan, partitioning)
Provide technical support and troubleshooting for existing ETL solutions.
Microsoft Power BI Tabular Editor SQL Server SSIS Python ETL Data analysis