Mario G.
Power BI & BigQuery Data Engineer | AI-Powered Analytics & LLM Agents
I build the data layer behind decisions: BigQuery warehouses, Google Cloud pipelines that run every day without a human touching them, Power BI and Looker Studio reports that finance and ops actually agree on โ and, where it pays off, an AI layer on top: chat with your warehouse in plain English, automated weekly insight write-ups, anomaly alerts. Top Rated Plus ยท 100% Job Success ยท 2,100+ hours and 20+ projects on Upwork ยท Head of Data Analytics & Innovation (SOLVERIX) ยท retail, agencies and B2B teams. WHAT I DELIVER - BigQuery warehouse design: star schemas, partitioning/clustering for cost control, Dataform/dbt transformations, data-quality tests, documented metric definitions - Pipelines on GCP: Cloud Run / Cloud Functions + Scheduler + Pub/Sub, incremental loads with MERGE upserts, backfills, monitoring and alerts. Sources I've wired up: Meta Ads, Google Ads, LinkedIn Ads, Slack, Salesforce, SharePoint, payment systems, daily Excel/CSV email exports GA4, Shopify, HubSpot - Power BI: semantic models, DAX KPI libraries, drill-through, RLS, incremental refresh โ and fixing slow or inconsistent reports - Looker Studio for lightweight, client-facing sharing - AI on your data: conversational analytics (text-to-SQL over BigQuery with schema guardrails and row-level citations), LLM-written performance summaries delivered to Slack/email, agents built on OpenAI/Claude APIs Gemini in BigQuery RECENT PROJECTS - End-to-end data platform with AI chat over BigQuery โ answers come with citations back to source data โ including CRM-vs-SharePoint data reconciliation - Slack โ BigQuery ETL (Cloud Functions gen2, 15-minute schedule, watermark-based MERGE) feeding B2B Power BI dashboards - Daily Excel email exports โ BigQuery โ dashboard, zero manual steps - Multi-client agency reporting: Meta/Google/LinkedIn Ads โ BigQuery with per-client isolation and self-service connector onboarding - Automated retail sales pipeline on Google Cloud (repeat client, 5โ ) HOW I WORK Short discovery call โ KPI definitions in writing โ first working version within days โ iterate with clear updates. I write the SQL, DAX and Python myself and hand over documented, maintainable code โ no black boxes. Fixed-price packages in my Project Catalog, or hourly for ongoing work. English, Italian, Greek, Albanian. Send me your current report (or a screenshot of the problem) and I'll reply with a concrete plan and estimate.