Ayoub E.

Data Analyst / Data Engineer specializing in the design of data pipelines and the creation of decision-making dashboards with Power BI.

I assist companies in centralizing, transforming, and leveraging their data to facilitate decision-making.

During my last assignment at Cerfrance, I held the role of Data Analyst / Data Engineer and Power BI referent for 18 months, where I worked on several data projects in parallel: data integration, data warehouse construction, and business dashboard creation.

My main responsibilities consisted of:

• Designing and optimizing ETL pipelines with Dataiku

• Building and structuring Data Warehouses from various sources (CRM, API, PostgreSQL databases)

• Developing interactive dashboards with Power BI (Power Query, DAX)

• Collaborating with business teams (Finance, HR, Acquisition, Property) to translate their needs into concrete data solutions

• Implementing automated and reliable reporting solutions

I work across the entire data value chain:

collection → transformation → modeling → visualization → decision support.

I can support your teams on:

✔ Implementing ETL pipelines with Dataiku

✔ Creating Data Warehouses

✔ Developing Power BI dashboards

✔ Data analysis and automated reporting

✔ Optimizing data models

✔ Industrializing data flows

Integrated into an internal team of about 15 people, collaborating with external providers. Mission of several months on data integration projects, error monitoring, and dashboard creation for operational tracking.

Data Engineering & Automation

• Development of Talend On-Premise pipelines, then migration and automation via Talend Cloud (REST API)

• Design of processes to group, rename, and structure errors, facilitating tracking by project managers

• Implementation of DevOps best practices to ensure automatic data updates

• Correction and optimization of existing pipelines: analysis of error causes, performance improvement, robustness reinforcement

Reporting & Data Visualization

• Development of interactive Power BI dashboards for performance and incident monitoring

• Creation of a centralized Talend repository consolidating information from jobs executed in Dev, Staging, and Production environments

• Providing a clear view of active jobs, execution times, errors, and statuses for business teams

Strategic Support & Coordination

• Collaboration with the external team for the development of a standard multi-country data integration module

• Technical monitoring, validation of proposed solutions, and reporting of alert points to the Head of Data Integration

Maintenance & Documentation

• Complete documentation of pipelines, changes made, and identified error causes

• Traceability and maintainability of solutions for the internal team

I can support your teams on:

✔ Implementing ETL pipelines with Talend

✔ Creating centralized repositories and Data Warehouses

✔ Developing interactive Power BI dashboards

✔ Optimizing and ensuring the reliability of data flows

✔ Automating processes and error monitoring

✔ Data analysis and decision-making reporting