Hi, I'm Ali Farroukh, a data-driven professional based in Beirut with a passion for turning numbers into actionable insights. I specialize in building end-to-end BI solutions, leveraging Python, SQL, and Power BI to empower cross-functional teams in retail and marketing.

Ali Farroukh

Hi, I'm Ali Farroukh, a data-driven professional based in Beirut with a passion for turning numbers into actionable insights. I specialize in building end-to-end BI solutions, leveraging Python, SQL, and Power BI to empower cross-functional teams in retail and marketing.

Available to hire

Hi, I’m Ali Farroukh, a data-driven professional based in Beirut with a passion for turning numbers into actionable insights. I specialize in building end-to-end BI solutions, leveraging Python, SQL, and Power BI to empower cross-functional teams in retail and marketing.

See more

Language

Arabic
Fluent
English
Fluent
French
Intermediate

Work Experience

BI Developer at Gray Mackenzie Retail Lebanon GMRL (Spinneys | Happy | Grab & Go| NOKNOK)
May 1, 2024 - Present
Developed BI solutions by extracting data from NAV and building data engineering pipelines using Python and Dagster for ETL; created dynamic Power BI dashboards with advanced measures, KPIs, parameters, and incremental refresh to deliver insightful and performance-optimized reporting solutions; utilized SQL, Power Automate, and GitHub for querying, automation, version control, and integration within the BI lifecycle; collaborated with cross-functional departments to gather requirements and deliver dashboards using Power BI, Power BI Report Builder, and Excel.
BI Developer at Gray Mackenzie Retail Lebanon (GMRL)
May 1, 2024 - Present
Developed BI solutions by extracting data from NAV; built data engineering pipelines using Python and Dagster for ETL; created dynamic Power BI dashboards with advanced measures, KPIs, parameters, and incremental refresh; utilized SQL, Power Automate, and GitHub for querying, automation, and version control; collaborated with cross-functional teams to deliver dashboards using Power BI, Power BI Report Builder, and Excel.
Project Coordinator at Facilitate International
September 1, 2023 - April 1, 2024
Coordinated facility management projects across the USA, focusing on construction, maintenance, and residential services; streamlined project organization using CRM systems; managed third-party administration and consultancy to ensure projects were on time and within budget; fostered collaboration with contractors, vendors, and clients to achieve project goals.
Small Business Owner at False9.lb
November 1, 2021 - Present
Established and managed a small business selling football jerseys via Instagram marketing; developed and executed marketing campaigns to boost sales and customer engagement; analyzed sales data and customer feedback to identify trends and opportunities; leveraged Excel for sales tracking and financial analysis; built and maintained relationships with suppliers, customers, and other stakeholders.
Marketing Analyst Intern at Areeba
June 1, 2021 - December 1, 2021
Transcribed SQL-based data transformations, including aggregating, joining, and filtering datasets to enable insightful analysis; analyzed marketing performance and presented findings to senior management; identified and evaluated new products, services, and advertising opportunities.

Education

Master in Business Analytics and Data Science at EU Business School
October 1, 2022 - June 1, 2023
Bachelor’s Degree in Business, Concentration in Business Information and Decision System at American University of Beirut (AUB)
September 1, 2019 - June 1, 2022
Lebanese Baccalaureate Diploma at Saint Mary’s Orthodox College (SMOC)
September 1, 2005 - June 1, 2019
Master in Business Analytics and Data Science – Coursework Completed at EU Business School, Barcelona
October 1, 2022 - June 1, 2023
Bachelor’s Degree in Business, Concentration in Business Information and Decision System at American University of Beirut (AUB)
September 1, 2019 - June 1, 2022
Lebanese Baccalaureate Diploma at Saint Mary’s Orthodox College (SMOC)
September 1, 2005 - June 1, 2019

Qualifications

Sales by Tender Type - Paginated Report ( Power BI Report Builder & Power Automate)
August 1, 2024 - September 1, 2024
Active Promotions Report - Power BI
December 1, 2024 - February 1, 2025
Sales by Tender Type - Paginated Report ( Power BI Report Builder & Power Automate)
August 1, 2024 - September 1, 2024
Active Promotions Report - Power BI
December 1, 2024 - February 1, 2025

Industry Experience

Retail, Financial Services, Professional Services, Software & Internet, Education, Media & Entertainment, Other