Hector A.

I turn messy marketing and operational data into reliable pipelines, dashboards and decisions. 100% Job Success, 7,000+ hours on Upwork. For the past two years I've been the data analyst behind the client reporting of a Vancouver digital agency, working with 12+ clients in e-commerce, retail and restaurants. Some of what I built there: • A marketing data platform: HEVO pulls Meta, Google Ads, GA4, Shopify, Pinterest and LinkedIn data into a layered BigQuery warehouse that feeds Metabase dashboards. New clients are onboarded from a documented SOP. • A revenue deduplication pipeline in SQL/BigQuery, so purchases claimed by both Google Ads and Meta are counted once. • A CPA prediction model in Python. Gradient Boosting cut error by 75% compared with linear regression. • ~140 Power BI dashboards, later migrated to Metabase and Funnel What I can do for you: • Connect your ad platforms, GA4, Shopify or operational sources to BigQuery and model the data so it can be trusted • Build Power BI, Metabase or Looker Studio dashboards your team will actually use • Find out why a number moved: root-cause analysis, attribution, tracking checks • Budget scenarios, forecasting and ML models in Python Before data, I spent 20+ years as a mechanical engineer on oil & gas and energy projects. If your data comes from equipment, sensors or a BAS/SCADA system, I understand where it comes from and why it breaks. How I work: I ask questions before I build, I document everything, and I explain results in plain language. I'm in UTC−4 and overlap fully with US and Canadian working hours. I work in English and Spanish. Send me a message with what you're trying to measure, and I'll tell you how I'd approach it.