Clair Wyant

Built and maintained nine interactive Tableau dashboards across five brands (three from scratch), integrating data from MS SQL Server and GA4 data in BigQuery. Automated end-to-end reporting pipelines (SQL & BigQuery to Tableau), reducing manual prep from days to hours and improving data accuracy by 90%. Led GA4 migration across three brand ecosystems, designing event frameworks that improved tracking integrity from 80% to 98% and ensured consistent KPI measurement for executives. Led weekly analytics review meetings, translating datasets into actionable recommendations for site optimizations and campaign strategies.

Doubled enrollment for free monthly license exams in 6 months by optimizing site navigation, expanding the membership sales funnel, and doubling online membership transactions. Redesigned and rebuilt the club’s B2C and e-commerce website with an SEO-friendly, user-centric design, improving information findability, usability, and site performance.

Increased website visits by 48%, inquiries by 85%, and reduced bounce rate by 7% through mobile-first redesigns and advanced keyword research and implementation. Managed 100+ B2C websites, delivering analytics and BI for data-driven decision-making. Boosted apartment occupancy from 65% to 95% by advising stakeholders and executing Google PPC campaigns, content refreshes, and optimized photography. Improved SEO rankings and customer acquisition by 20% YoY through on-page/off-page optimization and migration to an SEO-friendly platform. Consolidated KPI & PPC reporting in-house using Google Looker Studio, reducing weekly report review time from 60 minutes to 15 minutes.