Onur Gezer

BI Lead Associate @Bilyoner

Istanbul, Istanbul, Türkiye

About

As an İstanbul Teknik Üniversitesi Industrial Engineering graduate, I am a Senior Business Intelligence professional currently driving data-driven decision-making at Bilyoner. I specialize in bridging the gap between complex data architectures and strategic business insights, with extensive expertise in end-to-end BI solutions. My technical core revolves around architecting robust data pipelines, writing advanced data extraction scripts, and developing high-performance visualization ecosystems using both Tableau and Qlik Sense. From automating web data collection with Python and Scrapy to building reliable data sources using PostgreSQL and MySQL, I focus on creating scalable, enterprise-level reporting infrastructures. Passionate about optimization and continuous improvement, I thrive on turning raw data into interactive, impactful dashboards that empower teams to make confident, strategic choices.

Experience

  • Business Intelligence Lead Associate at Bilyoner
    Jul 2025 - Present · 1 yr

    ·      Designing, developing, and maintaining enterprise-level business intelligence applications and advanced data models using Qlik Sense. ·      Writing and optimizing complex SQL queries to extract and transform large datasets, ensuring high-performance reporting and efficient data processing. ·      Managing the end-to-end delivery of critical regulatory and compliance reports, ensuring strict adherence to legal frameworks and deadlines. ·      Taking full ownership of data accuracy, consistency, and integrity across all production reports and corporate dashboards. ·      Preparing, updating, and automating high-impact dashboards and analytical insights tailored for senior leadership and executive management to drive strategic decision-making.

  • Senior Data Analyst | BI Developer at EasyCep
    Sep 2023 - Jul 2025 · 1 yr 11 mos

    • integration of data from the ERP system into Tableau from scratch. • used Data Crawling via Scrapy for retrieving data from 3rd party sites. • used API for retrieving data and a regular source was created by Cron. • ERP data was transferred to SAP using Tableau Prep Builder platform. • created sources using Postgresql and Mysql and interactive dashboards were created in Tableau.

  • Getir (2 yrs 10 mos)
    • Data Analyst II
      Sep 2023 - Sep 2023 · 1 mo

      • prepared reports in PyCharm using Python for the all countries where Getir operates. • prepared new datasources in Tableau by writing SQL query in DataGrip. • created tables in Redshift using DBT to prepare the data sources.

    • Data Analyst I
      Sep 2022 - Sep 2023 · 1 yr 1 mo

    • Special Projects Data Analyst
      Dec 2020 - Sep 2022 · 1 yr 10 mos

      • prepared dashboards in Tableau so that the teams we collaborate with can benefit from. • optimized the areas where warehouses deliver orders by preparing dashboards with Maps in Tableau. • suggested improvements by analyzing KPIs in Tableau. • analyzed the operational problems and offered solutions. • determined the campaigns that should be activated according to the performance of the warehouses.

  • Pricing and Revenue Management Intern at METRO/MAKRO Cash and Carry
    Jul 2019 - Dec 2019 · 6 mos

    • made a competitive pricing analysis taking into account customer profiles and customer preferences. • researched how the product should be priced to reach the target customer considering customer perception. • analyzed the effect of products whose prices were changed on consumers.

  • Member at ITU Industrial Engineering Society
    Sep 2015 - Jun 2017 · 1 yr 10 mos