Atefeh Mahdavi

Data Analyst | SQL · Python · Snowflake · Power BI | User Behavior & Business Intelligence

Greater Barcelona Metropolitan Area

About

I’m a data analyst with a background in e-commerce analytics and academic research. I spent two years at Digikala — Iran’s largest online retailer — where I built customer segmentation models, tracked campaign performance, and automated reporting that cut manual work. At Aberdeen I focused on experimental design: designing and running A/B tests, doing the statistical analysis, and making the results accessible to non-technical teams. More recently I’ve been working independently, building the data and reporting workflows in Snowflake and Python, creating dashboards, and applying analytics to real-world problems including user behavior analysis and engagement metrics. I’m comfortable with complex SQL, window functions, CTEs, and translating messy data into decisions that actually matter. Based in Barcelona, open to data analyst and BI roles in companies where data is central to how decisions get made.

Experience

  • Data Analyst at Independent Research
    Oct 2024 - Oct 2025 · 1 yr 1 mo

    Built and maintained the data and reporting workflows in Snowflake and Python. Designed dashboards tracking behavioral patterns and engagement metrics. Applied SQL window functions and CTEs for cohort analysis and user segmentation. Worked with a couple of external teams, making sense of their data and giving them clear, straightforward recommendations.

  • Research Assistant at University of Aberdeen
    Sep 2022 - Sep 2024 · 2 yrs 1 mo

    Ran A/B tests and built forecasting models for university research programs.Worked with large datasets, ran statistical analyses, and collaborated with different departments to make the results useful.

  • Data Analyst at Digikala
    Jul 2016 - May 2018 · 1 yr 11 mos

    Analyzed user behavior and purchase patterns across millions of transactions on Iran's largest e-commerce platform. Built customer segmentation models using SQL and Python. Created Power BI dashboards for campaign performance tracking. Automated the recurring reports, which cut out a lot of repetitive weekly work. Worked day to day with the marketing and product teams, helping them make calls on campaigns and product changes based on what the data showed.

  • Volunteer Data Analyst for Animal Care Initiatives at Vafa Animal Shelter
    Sep 2011 - Jan 2012 · 5 mos

    Helped analyze shelter data to improve animal care and resource planning. Early experience that got me interested in using data beyond just business.