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)
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.
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.
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.
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.

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