Lead Data Analyst, Experimentation & AI BI

HEEMA MANIAR

Lead Data Analyst Product & Growth Analytics · Experimentation SQL · dbt · AI-Augmented BI ***********@*****.*** · 650-***-**** · San Francisco Bay Area · US Citizen linkedin.com/in/heema-maniar · github.com/heemaniar · heemaniar.github.io SUMMARY

Lead data analyst with 10+ years turning messy, cross-functional data into metrics and dashboards leaders trust and act on. I define KPIs and the single source of truth, model data in SQL and dbt, build self-service BI, and design and analyze experiments across product, marketing, sales, and finance. I build AI-augmented analytics — agents and LLM workflows — to speed up analysis and scale decisions. PROFESSIONAL EXPERIENCE

Analytics Consultant · Let's Talk Communications Jun 2024 – Present

• Own channel-ROI and multi-channel attribution dashboards in Looker across 60+ brands, unifying order-level revenue with Meta, Google, and Pinterest spend into one source of truth.

• Define marketing KPIs and self-service reporting, partner cross-functionally, and use AI and LLM workflows to turn analysis into clear narratives leaders act on. Analytics & AI Engineer · Independent Jun 2024 – Present

• GoldenGate Retail AI — AI analytics co-pilot that routes plain-English questions to specialist agents over ~1.5M transactions across 13 sites, automates BigQuery ML (ARIMA_PLUS) forecasts on a Fivetran pipeline, and keeps every answer traceable to its SQL. Google ADK, Gemini, Fivetran MCP, Cloud Run.

• Revenue Intelligence (Olist) — Modeled 99K-order e-commerce data in BigQuery and dbt (staging to marts, tested and documented) into a live dashboard, with a semantic KPI dictionary as the single source of truth and Claude tagging sentiment across 1,500 reviews in Python. Senior BI Developer · Signal Advisors Jul 2022 – Nov 2023

• Broke the revenue funnel into stage-level conversion and advisor LTV to find the highest-leverage drivers, and sized the opportunities for leadership.

• Designed and analyzed A/B tests on sales workflows, starting from first principles on what decision each test would drive, and turned results into roadmap changes.

• Built the Looker/LookML semantic layer and self-service models, defining KPIs and a single source of truth that reduced ad-hoc requests.

• Built and maintained ELT pipelines with Fivetran and Airflow feeding dbt data models, writing complex SQL with version control, code review, and CI/CD.

• Modeled customer identity across Salesforce, Talkdesk, Segment, and FullStory into one trusted dataset, enabling retention, churn, and cohort analysis by segment.

• Delivered dashboards and clear data narratives that helped product, sales, marketing, and finance stakeholders act on the numbers.

• Instrumented product and marketing events in Segment and tracked engagement in Mixpanel, and mentored an analyst on SQL, Python, and dashboard design.

• Enforced data governance for regulated wealth-management data — role-based access, authorized views, and column/row-level security — keeping sensitive financial data out of BI. Business Insights Lead · Premise Jul 2019 – Jun 2022

• Built an automated dashboard system on a global marketplace — a shared partitioned incremental SQL data model with auto-generation and refresh shutoff — cutting build time 35% and turnaround 50%.

• Analyzed contributor cohorts, retention, and churn in Amplitude to inform investment and roadmap decisions.

• Ran regional funnel and demographic analysis to size opportunities for stakeholders, lifting marketing ROI 15% by reallocating spend to converting channels.

• Cut manual reporting 30% and lifted operational efficiency 20% with self-service dashboards and standardized KPIs as a single source of truth, partnering cross-functionally and turning findings into clear narratives.

• Applied a first-principles approach to build predictive fraud and LTV models, and mentored an analyst to own dashboard builds end to end.

Data Analyst (Contract) · Google (via Accenture)Mar 2019 – Jul 2019

• Automated scheduled reporting with Apps Script (timed triggers pulled, formatted, and delivered reports), freeing roughly a third of the team's reporting time.

• Built and standardized SQL dashboards and data pulls used by stakeholders across the team. Software Analyst · Yardi Software India May 2016 – Mar 2018

• Built SQL reporting and data models for property-management analytics and mentored junior analysts on data-quality practices.

TECHNICAL SKILLS

Analytics & Experimentation: funnel & conversion analysis, KPI definition & single source of truth, opportunity sizing, cohort & LTV analysis, retention & churn, A/B testing & experiment design, statistical analysis

SQL & Data Modeling: SQL (BigQuery/Google SQL, Snowflake, T-SQL, PL/SQL), dbt (models, tests, docs, lineage), dimensional modeling, SCD type-2, entity resolution, query cost & performance tuning Data Engineering & Governance: Fivetran & Airflow (ELT & orchestration), CI/CD, version control (Git), code review, data governance (IAM, row/column-level security) BI, Visualization & Product Analytics: Looker / LookML, Tableau, Looker Studio, Evidence, Amplitude, Mixpanel, Segment (event instrumentation), Connected Sheets Programming & AI: Python (Pandas, NumPy), R, Google Apps Script; AI agents (Google ADK, Gemini, Claude API, MCP), LLM analysis, eval & grounding (Arize Phoenix), prompt engineering, forecasting

(ARIMA_PLUS)

Cross-functional & Strategy: partnership with product, marketing, sales, finance, ops & HR; stakeholder prioritization, data storytelling & executive narratives EDUCATION & CERTIFICATIONS

• Certification in Database & Data Analytics — UC Santa Cruz Silicon Valley Extension (2018)

• B.E. Computer Engineering — University of Mumbai (2012)

• Certifications: dbt Fundamentals, Databricks Fundamentals, Google Introduction to Generative AI

Contact this candidate