Ezgi Ozturk

Data analyst with 5 years of experience building SQL and Power BI reporting solutions for sales, procurement, and operations teams. Strongest in advanced T-SQL, DAX modeling, and ETL automation that replaces manual reporting cycles with maintained, self-service dashboards. Logistics and supply chain background supports translating ambiguous business questions into production reporting. Authorized to work in the U.S. without sponsorship.

BI Analyst at Caterpillar (2024-10 – Present)

• Build and tune advanced T-SQL — CTEs, window functions, stored procedures, and multi-table joins — against multisource transactional datasets to support sales reporting and business performance tracking.
• Own 5 Power BI dashboards with DAX-based KPI measures covering revenue trends, product performance, customer segmentation, and channel effectiveness for executive reporting.
• Design ETL workflows to extract, clean, and load data from SQL Server into reporting layers, improving data reliability and reducing manual reporting effort.
• Conduct Python-based analysis (Pandas, Matplotlib, Seaborn, Plotly) to surface sales trends, product profitability, and regional performance patterns across operational datasets.
• Partner with stakeholders to gather requirements, validate data models, and deliver ad hoc analyses supporting strategic planning and operational decisions.
• Automate recurring reports and KPI dashboards, reducing manual reporting time and improving consistency of business metrics delivered to leadership.

Junior Data Analyst at Airbnb (2022-08 – 2024-09)

• Developed Tableau dashboards analyzing 102K NYC listings to support pricing strategy, host performance monitoring, and market trend analysis across five boroughs.
• Wrote SQL queries to extract and transform listing, review, and availability data from internal databases for use in reporting and visualization layers.
• Delivered borough-level pricing and availability reports that informed internal market strategy discussions and host engagement initiatives.
• Analyzed host response time, identity verification, and review score data to identify quality improvement opportunities across room types and regions.
• Supported the analytics team with data cleaning, ad hoc reporting, and dashboard maintenance on a regular basis.

Data Analyst Intern at Alliance Tek (2021-10 – 2022-07)

• Assembled departmental KPI reporting in Power BI — including sub-reports, drilldown reports, summary reports, and parameterized reports — for marketing, finance, and product teams to support strategic decisions.
• Built Customer Dive dashboards analyzing customer buying patterns, helping the marketing team retain existing customers and bring in new ones.
• Created financial reports highlighting sales growth, sales trends, direct expenses, and profitability to support finance department decision-making.

Supply Chain Analyst Intern at Industrial Oilfield Procurement Services (2021-03 – 2021-09)

• Tracked and analyzed purchase orders, vendor performance, and delivery timelines using Excel and SQL to support procurement reporting.
• Contributed to dashboards monitoring supply chain KPIs, including on-time delivery rates, vendor compliance, and inventory turnover.
• Cleaned and validated procurement data from multiple sources, improving accuracy of monthly performance reports presented to management.

M.S. in Data Analytics – Alliant International University (2024-03 – 2025-12)

M.S. in Information Technology – Southern States University (2022-01 – 2023-12)

B.A. in International Logistics Management – Istanbul Kemerburgaz University (2011-01 – 2016-01)