Aarthi K.

Looker Studio & Google Analytics specialist who builds the whole stack and not just the front end. I pipe GA4, ad-platform and database data into BigQuery using Windsor.ai, Airbyte and dbt, then build clean, reliable Looker Studio and Metabase dashboards your marketing and e-commerce teams actually use. I build AI ready data pipelines designed from the start so AI agents and MCPs can run on top of them reliably. That means clean schemas, dbt documented metadata, and context engineering: structuring what Claude or any LLM knows about your data so it answers business questions correctly, not just quickly. Claude MCP integrations connect AI directly to live databases. Architecture and QA on every project is overseen by a BI Veteran with 12 years of experience. Work that used to take 2 to 3 weeks delivered in 3 to 5 days — not by cutting corners, but by validating continuously as we build. 🎯 My focus is simple like clean data models, reliable KPIs, and dashboards people actually open. 🛠️ What I build (end to end): ✅ Marketing & web data pipelines: automated ingestion from GA4, Google Ads, Meta or Facebook, Shopify, databases and APIs into BigQuery using Windsor.ai, Airbyte and dbt for staging, intermediate and fact models, GitHub version control, and monitoring or alerts so the data stays reliable. ✅ Google Analytics reporting: GA4 and web data exported into BigQuery for complete historical data, then modeled into decision-ready Looker Studio dashboards. ✅ Looker Studio & Metabase dashboards: interactive marketing, web and e-commerce reporting calculated fields, period comparisons (MoM, YoY, growth %), running totals, filters, permissions and governance. ✅ Automated reporting: scheduled, hands-off pipelines that build and deliver client reports on a daily cadence, so your team stops rebuilding spreadsheets. ✅ BigQuery & SQL: advanced SQL (PostgreSQL, MySQL, BigQuery), query optimization, complex joins and CTEs, and clean star-schema models. 📌 Recent work: ✅ An automated marketing reporting pipeline that produces and delivers per client dashboards every day, unattended. ✅ Multi clinic lead and performance analytics for a 30 location network (GoHighLevel to Cloud Run to BigQuery to Looker Studio). ✅ GA/GA4 web analytics dashboards for global and EU e-commerce sites. ✅ Amazon Selling Partner sales, profit, margin and returns analytics in Metabase on a dbt and BigQuery pipeline. 💡 How I add value: ✅ I own the whole flow from raw source to the dashboard, so nothing breaks between the pipeline and the report. ✅ I translate business and marketing questions into structured data and clear KPIs. ✅ I build scalable models and pipelines so reporting stays reliable as you grow. ✅ I keep data accurate, consistent and governed. I don't just build dashboards; I build the pipeline and the dashboard, so your numbers are trustworthy end to end. 🤝 Why clients work with me: ✅ Strong SQL and data modeling foundation ✅ Clean, structured, well documented development ✅ Business focused mindset, not just technical ✅ Clear communication and reliable long term collaboration 📩 If you need a marketing or web analytics stack built right from BigQuery pipelines to Looker Studio and Metabase dashboards, send me a message and let's turn your data into clarity.