Responsibilities

• Maintain and troubleshoot our existing Google Sheets-based reporting dashboards, data connectors, formulas, and calculations
• Investigate discrepancies across dashboards, advertising platforms, GA4, and other source systems, and resolve recurring issues at the system level
• Build and improve scalable reporting templates across paid media, SEO, organic social, and cross-channel performance
• Structure dashboards and reporting outputs so key KPIs and business outcomes are clear, prioritized, and easy for internal teams and clients to understand
• Configure, audit, and troubleshoot Google Analytics 4 and Google Tag Manager, including event tracking, conversions, QA, and documentation
• Help standardize tracking frameworks, conversion definitions, UTMs, naming conventions, and measurement methodologies across clients
• Improve measurement of business outcomes such as reservations, private-event leads, catering inquiries, ecommerce revenue, and other client-specific conversions
• Support the evaluation and implementation of Hudson Creative’s next-generation reporting infrastructure, including integrations with advertising platforms, analytics tools, CRM/POS/reservation systems, and other data sources
• Identify opportunities to automate recurring data and reporting workflows, improve QA, and reduce manual spreadsheet maintenance
• Partner with Performance, Accounts, Web/Development, and leadership teams to translate business and reporting needs into practical technical solutions

Requirements

• Hands-on experience with Google Analytics 4 and Google Tag Manager
• Advanced Google Sheets skills, including formulas, data manipulation, and troubleshooting
• Experience with marketing reporting and data connector tools such as Power My Analytics, Supermetrics, Porter Metrics, Looker Studio, or similar platforms
• Strong understanding of digital marketing data from platforms such as Google Ads, Meta Ads, Microsoft Ads, and other paid media platforms
• Knowledge of UTMs, event tracking, attribution, and conversion measurement
• Ability to diagnose discrepancies across multiple data sources and identify root causes
• Strong documentation and process-building skills
• Ability to explain technical analytics concepts to non-technical marketers
• Highly organized and comfortable managing multiple accounts or workstreams simultaneously

Preferred

• Experience working in a marketing agency or supporting reporting and analytics across multiple client accounts
• Experience with restaurant, hospitality, tourism, ecommerce, or lead-generation measurement
• SQL and/or BigQuery experience
• Experience with APIs, data pipelines, or custom marketing data integrations
• Python or other scripting experience
• Familiarity with CRM, POS, reservation, or ordering-system data such as Toast, OpenTable, or similar platforms
• Exposure to LLM APIs, AI-enabled analytics tools, agentic workflows, or MCP
• Familiarity with privacy, consent, and data collection considerations in digital analytics