AI Data Analyst (GCP, Looker, BI)

Job Title: AI Data Analyst Location: Santa Ana, CA - Day 1 Onsite Type: Long Term Contract Role Overview: The AI Data Analyst will be responsible for data understanding, validation, KPI verification, and ensuring reporting outputs meet business expectations on the GCP platform. This position requires close collaboration with business stakeholders and offshore teams to ensure dashboards, data models, and pipelines deliver accurate, consistent, and trusted insights. Key Responsibilities Collaborate with business teams to define metrics, KPIs, and reporting logic. Conduct data profiling, validation, and reconciliation against source systems. Perform KPI validation to ensure accurate metric definitions and calculations. Execute report/dashboard QA, including both visual and functional testing. Lead and support UAT cycles for analytics deliverables. Validate BigQuery data models, pipeline outputs, and semantic layer consistency. Document data mappings, transformation rules, data quality issues, and resolution steps. Act as the onsite liaison between business teams and offshore development teams. Required Skills & Qualifications Strong SQL expertise (BigQuery SQL preferred) with hands-on data analysis. Experience in data validation, KPI verification, and BI report QA. Working knowledge of GCP analytics stack: BigQuery, Data Catalog, Looker, Cloud Storage. Understanding of semantic modeling, metadata, and data lineage concepts. Familiarity with UAT planning, execution, and stakeholder sign-off. Ability to collaborate effectively in an onsite-offshore delivery model. Excellent analytical, communication, and documentation abilities. Preferred Skills Experience with anomaly detection or statistical analysis. Exposure to LookML (nice-to-have).