Clair Wyant Resume

The approach is audit-first, most reporting problems trace back to the data layer, not the dashboard. I find where the foundation breaks down before anything gets built on top of it.

Available for project or retainer engagements. San Diego, US clients across all time zones.

SELECTED IMPACT HIGHLIGHTS

• Built 9 enterprise-grade dashboards adopted by executives across 5 brands, improving reporting efficiency and accuracy by 90%.
• Automated SQL and BigQuery pipelines, reducing manual prep time from days to hours and accelerating analytics delivery.
• Improved web tracking integrity from 80% to 98% through GA4 migration and event-architecture standardization.
• Consolidated PPC reporting and KPI tracking, reducing weekly meeting time by 75% and allowing discussions to focus on strategy, not explanation.

• Developed 5 interactive analytics dashboards analyzing demographic trends, consumer behavior patterns, and real-time event data; all projects publicly available at clairwyant.com
• Created real-time sports schedule dashboard with dynamic filtering and time-zone conversion (processes live sporting events ranging from 80+ daily in off-season to 200+ during peak periods), demonstrating consumer-facing UX design expertise
• Conducted multi-year EU demographic analysis examining internet connectivity, migration patterns, and citizenship trends across 27+ nations using Eurostat datasets with 50,000+ records
• Built geopolitical analysis dashboard mapping 750+ locations across 80 countries with strategic clustering and density analysis
• Integrated AI tools (ChatGPT, Claude, Gemini) to accelerate data cleaning workflows, optimize SQL queries, and enhance analytical efficiency
• Developed enterprise-scale dashboard analyzing 74,000+ records; withheld from publication upon identifying potential GDPR compliance considerations
• Technologies: Tableau, Excel, AI-Assisted Analytics (ChatGPT, Claude, Gemini)

Built a comprehensive analytics infrastructure and interactive Tableau dashboards supporting digital marketing operations across 5 brands, integrating data from MS SQL Server and GA4 via BigQuery. Dashboards were used weekly by 4 executive stakeholders for performance review.

• Developed 9 enterprise level Tableau dashboards, automating end-to-end reporting pipelines that reduced manual data prep from days to hours and improved accuracy by 90%
• Led GA4 migration across 3 brand ecosystems, designing event frameworks that improved tracking integrity from 50% to 98%
• Optimized SQL and BigQuery queries processing 500,000+ rows with advanced filtering, joins, and blends across multiple data sources
• Expanded site tracking to 95% of key pages and 50+ GA4 events per brand, transforming decision latency from “no visibility” to actionable insights within hours
• Partnered with A/B testing leads to deliver comprehensive posttest analytics via realtime Tableau dashboards, shortening validation cycles by 75%
• Technologies: Tableau, Tableau Server, SQL, BigQuery, GA4, Microsoft SQL Server, MS Teams

Spearheaded digital marketing operations and analytics for 100+ B2C websites across real estate and property management verticals.

• Increased website visits by 48% and inquiries by 85% while reducing bounce rate by 7% through mobile redesigns and keyword optimization
• Boosted apartment occupancy from 65% to 95% through targeted Google PPC campaigns, content refreshes, and optimized visual assets
• Generated 400+ monthly leads for new build community through integrated Google/Facebook ads, SEO, and traditional channels
• Built custom dashboards in Google Data Studio and Tableau, consolidating cross-channel marketing data into actionable visualizations
• Consolidated PPC reporting and KPI tracking, reducing weekly meeting time by 75% and shifting discussions from explanation to strategy & reducing weekly review time from 60 to 15 minutes
• Improved SEO rankings and customer acquisition by 20% YoY through comprehensive optimization and platform migration
• Achieved 900% site traffic increase over a multiyear period through continuous SEO optimization, sustaining 13K+ monthly page views
• Technologies: Google Analytics, Google Ads, Google Data Studio, Tableau, Google Sheets, Facebook Ads Manager, Google Meet