> about

Ahmet Can Öztürk

I'm Ahmet. I'm a Data Engineer and Business Intelligence professional with 5+ years of experience in analytics, reporting, and data warehousing — I currently consult at Trendyol via Global Maksimum.

I care about systems that work in production, not just in notebooks. The difference matters — a report that looks clean in a demo can destroy trust at scale when sales and invoices don't reconcile. Latency that's acceptable for a one-off query becomes expensive when 216 clients depend on it every day.

I have a strong background in BigQuery, SQL, Python, Looker, Apache Airflow, and Google Cloud Platform. I am known for improving data quality, simplifying reporting, and turning business needs into practical data solutions.

I also create educational content on BigQuery, Looker Studio, and analytics through Udemy and Medium.

I'm based in Istanbul, Türkiye.

> experience

Data Warehouse Analyst (Consultant)

Apr 2025 – Present
Global Maksimum — Trendyol · Istanbul, Türkiye
  • I analyze large-scale datasets across Customer Experience, Fraud, Finance, and Dolap teams.
  • I review and improve financial reports by reconciling sales and invoice data.
  • I support POS and payment-provider reporting for partners including PayPal, Adyen, and Tamara.
  • I maintain and improve reporting workflows using BigQuery, Airflow, Looker, n8n, GitLab, and Jira.
  • I contribute to data warehouse design, data quality practices, and data contract implementation.
BigQueryAirflowLookern8nData QualityFinance

Senior Business Intelligence Specialist

Feb 2024 – Apr 2025
AloTech · Istanbul, Türkiye
  • I built Business Intelligence and AI-enabled reporting solutions with Python, BigQuery, Pandas, PySpark, BigQuery ML, and LLMs.
  • I delivered around 450 Business Intelligence reports for 216 clients using Google Cloud services.
  • I developed 5 LLM-based reporting solutions to improve access to insights and reporting speed.
  • I completed 3,939 Jira tasks across 381.5 person-days of delivery effort.
  • I automated recurring workflows using Cloud Functions and Cloud Scheduler.
BigQueryPythonPySparkBigQuery MLLLMsCloud Functions

Business Intelligence Specialist

May 2022 – Feb 2024
AloTech · Istanbul, Türkiye
  • I developed client-specific analytics and reporting solutions using BigQuery and Looker Studio.
  • I supported internal teams with reliable access to warehouse data and reporting assets.
  • I optimized BigQuery performance and costs using Standard SQL, materialized views, and CTEs.
  • I implemented ETL workflows with Cloud Data Fusion.
BigQueryLooker StudioSQLCloud Data FusionETL
> teaching & content
Course Instructor — Udemy
Aug 2023 – Present

I published courses on Google Looker Studio and Google Cloud Platform BigQuery SQL.

Content Creator — Medium
Sep 2024 – Present

I publish practical content on data, analytics, cloud technologies, and Business Intelligence.

> education
B.Sc., Mechanical Engineering
2014 – 2020

Manisa Celal Bayar University

M.Sc. Studies, Data Science (incomplete)
2021 – 2022

Ondokuz Mayıs University

> certifications & development