Data Analyst

Yashar. Hired for outcomes, not job descriptions.

SQL-driven KPI reporting and executive-ready insights. Based in Messina, Italy — open to remote. 5 years across B2B SaaS (Jumbula, US) and consumer app marketplaces (Cafe Bazaar, 40M+ users).

12
SQL pipelines across 4 sources
8
Power BI dashboards (20+ KPIs)
60%
Prep-time reduction
35%
Reporting-error reduction

Profile

Data Analyst with 5 years of experience in SaaS and consumer app marketplace environments (Jumbula, Cafe Bazaar — 40M+ users). Specialist in SQL-driven KPI reporting, Power BI dashboarding, funnel + cohort analysis, and translating complex datasets into executive-ready insights. Built 12 Power BI dashboards replacing 5 weekly manual reports and cut reporting cycle from 3 days to 4 hours for a team of 20.

Capabilities

SQL & Databases
PostgreSQLMySQLBigQuerySnowflake (basics)
Python
pandasnumpymatplotlibseabornJupyter
BI & Visualization
Power BI (DAX)TableauLooker StudioGoogle Sheets
Other Tools
Excel (Power QueryVLOOKUPpivot tables)GitJiraConfluence
Analytics Techniques
Funnel analysiscohort analysisA/B testingKPI modelingtrend analysis

Experience

Data Analyst — Growth & Operations 2023 – 2025
Cafe Bazaar — Iran's largest Android app marketplace (40M+ users)
  • Built 12 SQL pipelines extracting data from 4 sources (GA4, product DB, CRM, ticketing), reducing manual prep time by 60% on weekly reporting.
  • Designed 8 Power BI dashboards tracking 20+ KPIs for a team of 20, replacing 5 recurring manual reports.
  • Ran funnel and cohort analysis on 6 months of behavioral data, identifying 4 drop-off points worth an estimated $180K/year in recovered revenue.
  • Implemented a data-validation framework that cut reporting errors by 35% across 6 recurring dashboards.
  • Delivered bi-weekly executive briefings to C-level stakeholders, translating SQL findings into 1-page summaries that drove 3 roadmap decisions.
  • Supported 24 A/B tests with statistical readouts, improving test-to-decision time from 10 days to 4.
Marketing Data Analyst 2020 – 2023
Jumbula — B2B SaaS for schools (US)
  • Built a 40-row campaign ROI dashboard in Power BI that let the team reallocate 25% of spend to top-performing channels.
  • Standardized 12 marketing KPIs across 6 teams, cutting reporting inconsistencies from 34% to 6%.
  • Wrote 80+ SQL queries against a 25K-subscriber HubSpot/CRM dataset to support segmentation and lifecycle campaigns.
  • Created a weekly self-serve reporting layer in Looker Studio, reducing ad-hoc data requests by 45%.
  • Collaborated with RevOps to audit 2K open opportunities, flagging 22% as stale and tightening forecast accuracy to 9%.

Selected Work

E-commerce Funnel Analysis

PostgreSQL, pandas, matplotlib

Wrote 14 SQL queries and 3 pandas notebooks on a Kaggle e-commerce dataset; surfaced 3 insights on checkout drop-off. Documented as a portfolio case study.

Public COVID Dashboard

Power BI, Tableau Public

Built a 5-page Tableau Public dashboard tracking 12 country-level metrics with drill-through and forecast bands.

Credentials

Google Data Analytics Certificate — Coursera, 2024
Microsoft Power BI Data Analyst (PL-300) — In Progress
StrataScratch SQL — 50+ problems completed, 2024

Education & Languages

DegreeBSc, Data Analysis (in progress) - Universita degli Studi di Messina, Italy
LanguagesEnglish — Professional working proficiency (C1) · Turkish — Native · Azerbaijani — Native

Contact

LocationMessina, Italy
AvailabilityOpen to remote and international opportunities
Emailyashaarheidari@gmail.com
LinkedInlinkedin.com/in/yheidari