Analyst

Built and maintained ETL pipelines using BigQuery and API integrations to extract and centralize raw transaction and marketing data from Shopify, MetaAds, GoogleAds, and TikTokAds into a unified data warehouse. Developed advanced SQL reconciliation models leveraging Window Functions and CTEs to automate cross-platform attribution, successfully identifying a 30% revenue discrepancy (~$27,000) for a client with ~$90,000 in monthly ad spend. Designed and maintained interactive client-facing dashboards in Power BI, automating KPI reporting (ROAS, CAC, LTV) and reducing manual data compilation time from 4 hours to under 15 minutes per client. Implemented automated data quality monitoring with anomaly detection alerts, enabling the team to catch reporting discrepancies within 24 hours instead of end-of-month reconciliation. Authored comprehensive technical documentation for internal database schemas and automated pipeline workflows.

Delivered SQL-based reporting and data cleaning for small e-commerce clients, analyzing transactional data from Shopify and Google Sheets to identify sales trends and optimize ad spend allocation. Built automated Excel and Google Sheets dashboards for revenue tracking — recurring client pain points with revenue discrepancies led directly to co-founding Calyxra. Consolidated data from multiple sources (ad platforms, payment processors, inventory systems) into unified reports, reducing manual reconciliation effort by 80%.