Emrah Özögel

Emrah özögel

bookmark on deepenrich
location of Emrah ÖzögelBerlin, Berlin, Germany
Followers of Emrah Özögel868 followers
  • Timeline

  • About me

    Business Intelligence Engineer | Data Engineer | GIS Engineer

  • Education

    • Istanbul technical university

      -
      Master's degree
    • Yildiz technical university

      -
      Bachelor's degree
  • Experience

    • Geomobis mobile information system

      Jan 2014 - Jan 2016
      Geographic information systems engineer

      • Spatial Data Integration: Integrated street imagery and point cloud data into municipal databases using PostGIS and ArcGIS for enhanced data analytics.• GIS Dashboard Development: Created an interactive map-based website for municipal data visualization, leveraging SQL and GIS tools for user-centric insights.

    • Binbiriz

      Jan 2017 - Jan 2018
      Geographic information systems engineer

      • Data Analysis and Visualization: Analyzed remote sensing data to optimize crop yields and streamline agricultural decision-making processes.• End-to-End Project Ownership: Developed an integrated workflow in precision agriculture, from data collection to tailored reporting.• Technological Adaptation: Integrated the latest remote sensing technologies to ensure innovative, cutting-edge solutions for clients.

    • Istanbul metropolitan municipality

      Jan 2019 - Jan 2021
      Geographic information systems engineer

      • Data Visualization and Reporting: Utilized GIS software to design interactive maps and dashboards, effectively communicating complex spatial patterns and insights to both technical and non-technical stakeholders.• Advanced Analytical Techniques: Employed advanced geospatial statistics to optimize resource allocation and proactively address urban challenges.• Data Management and Integration: Harmonized diverse datasets from various municipal departments into a centralized GIS database, ensuring data integrity, consistency, and facilitating more seamless spatial analysis. Show less

    • Idea bilisim ve danismanlik

      Jan 2019 - Jan 2019
      Data analyst

      • Optimized Business Analytics: Streamlined analytics for supply chain, retail, HR, and marketing using SQL and Excel, delivering insights for Idea's CRM and Retail clients.• Enhanced Reporting & Tracking: Developed custom solutions for CRM, ERP, and Retail with SQL-backed dashboards, ensuring business continuity and performance management.

    • Getir

      Jan 2021 - Jan 2022
      Data analyst

      • Data Operations & Supply Chain Analytics: Utilized Python and SQL on Amazon Redshift to develop and manage supply chain data sources, optimizing the company's supply chain efficiency and visibility.• Tableau Dashboards & Visualization: Designed and delivered comprehensive Tableau dashboards derived from new data sources, providing actionable insights to internal stakeholders and supporting the company's rapid growth trajectory.• Stakeholder Collaboration & Time Management: Successfully navigated a fast-paced environment with multiple concurrent requests, ensuring timely deliveries by merging similar requirements and devising solutions that catered optimally to diverse business units' needs. Show less

    • Coachhub - the digital coaching platform

      Jan 2022 - Jan 2024
      Data analyst

      • Enhanced Data Integrity and Reporting: Collaborated with the Finance team to refine data accuracy in various reports and dashboards, leveraging SQL, Python, and DBT on Amazon Redshift.• Dashboard Development and Customization: Partnered with the Data Applications team to optimize and maintain the company's client-facing dashboard in Looker.• Cross-Functional Collaboration: Engaged with multiple teams, from finance to customer solutions, to drive data-driven decisions, streamline operations, and tailor dashboards, enabling better insights and more tailored client interactions. Show less

    • Lidl e-commerce

      Jan 2024 - now
      Business intelligence engineer

      • Supply Chain Data Optimization: Enhanced data structures using Ab Initio and Snowflake, improving data accessibility and decision-making accuracy in logistics.• SSBI and Data Literacy Leadership: Helped initiatives to elevate data literacy and SSBI adoption among business teams, teaching data manipulation and query writing with MicroStrategy.• Data Integration and Reporting: Collaborated across departments to refine logistics data integration and reporting, developing key MicroStrategy dashboards that drove operational efficiencies. Show less

  • Licenses & Certifications

    • Microsoft certified professional c#

      Microsoft
    • Data science & machine learning bootcamp

      Veri bilimi okulu
      View certificate certificate
  • Honors & Awards

    • Awarded to Emrah Özögel
      Best Poster Presentation Award - 2019 Chamber of Survey and Cadastre Engineers (UCTEA) - Harita ve Kadastro Mühendisleri Odası (HKMO) Apr 2019 An Investigation About Evaluation of Geoid Models Produced with Point Cloud Data From UAV and Airborne LIDAR