You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Ali Ait El AlouiaAA

Ali Ait El Alouia

Data and Analytics Engineer - MSBI

€580/day
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Ali

✔MSBI (SSIS, SSAS, SSRS) ✔Microsoft Azure ✔Power BI ✔Tabular Cube ✔SQL Server ✔ETL ✔Data Modeling

Currently Data/BI Engineer at the Ministry of Labour, I contribute to the evolution of Business Intelligence systems and the optimization of data flows using technical solutions such as SQL and SSIS.

Graduated from IMT Atlantique and the National Institute of Posts and Telecommunications, I leverage solid technical expertise combined with a proven ability to translate business needs into concrete and operational solutions.

Through my experiences, I have:
✔ Developed and Optimized SSIS flows for data integration and preparation.
✔ Implemented automated alert mechanisms to ensure data quality and consistency.
✔ Developed tabular cubes (SSAS) adapted to constantly evolving needs.
✔ Designed interactive dashboards with Power BI.

My goal: to continue to enhance data by transforming it into strategic information, in service of innovative, collaborative, and high business impact projects.
  • Arabic

    Native or bilingual

  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Paris (up to 50km)

Experience

  • TALAN
    Business Intelligence Engineer / Data Analyst
    PUBLIC SECTOR
    October 2021 - Today (4 years and 10 months)
    Paris, France
    Contributed to the evolution of the AGORA decision-making system by implementing key performance indicators and conducting unit tests on ETL flows, ensuring reliable production deployment with a low error rate.
    Authored comprehensive technical documentation (technical specifications, test scenarios, deployment plan) facilitating the adoption of delivered solutions for PPROD / PROD.
    Implemented the Delta solution, transforming monthly flows into weekly flows, and set up automatic anomaly alerts to improve the responsiveness of steering teams.
    Designed and optimized SSAS tabular cubes (CEP, SOFFI), in collaboration with business teams, reducing data analysis time while integrating functional evolutions.
    Developed interactive Power BI dashboards for the FNE and SOFFI projects, enabling visualization of operational and financial KPIs.
    Optimized ETL processes (queries, SSIS treatments, job scheduling), reducing the execution time of nightly treatments and improving the overall reliability of flows.

    Main Client: DGEFP (Ministry of Labour)
    SQL Server Integration Services (SSIS) SQL Server Analysis Services (SSAS) Microsoft Power BI SQL SQL Server Management Studio (SSMS) Gitlab Microsoft Visual Studio Transact-SQL Jira
  • TALAN
    Data/BI Consultant
    PUBLIC SECTOR
    April 2021 - September 2021 (6 months)
    Paris, France
    Developed a GDPR-compliant secure repository for the AGORA system, integrating SSIS flows and stored procedures for NIR anonymization, ensuring regulatory compliance and security of sensitive data.
    Authored a complete technical specification covering functionalities and deployment steps.
    Performed unit tests for validation and production deployment.

    Main Client: DGEFP (Ministry of Labour)
    SSIS SSMS SQL Server Jira Microsoft Visual Studio Gitlab
  • DXC Technology
    BI Engineer
    DIGITAL AND IT
    February 2020 - July 2020 (6 months)
    Salé, RZ, Morocco
    Designed and deployed a decision-making system to measure corporate social performance, including the development of ETL flows under SSIS for data integration, the modeling of an SSAS tabular cube structuring key social dimensions, and the creation of interactive Power BI reports.

    Main Client: DXC
    SQL Server Management Studio (SSMS) SQL Server SQL Server Analysis Services (SSAS) SQL Server Integration Services (SSIS) Microsoft Power BI

Recommendations

Be the first to recommend Ali

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Specialized Master's Degree in Computer Science Applied to Banking and Actuarial Decision Making (IADBA).
    IMT Atlantique
    2021
    Master spécialisé , Informatique Appliqué à la Décision Bancaire et Actuarielle ( IADBA ).
  • Engineering Degree in Information Systems and Data Management (Specialization: BI & Big Data)
    National Institute of Posts and Telecommunications
    2020
    Diplôme d’ingénieur en systèmes d'information et Data Management (spécialisation : BI & Big Data)

Skill set

Categories