• Play a key role in the transition from Looker to Power BI, recreating essential dashboards and ensuring reporting accuracy across platforms. • Perform data validation between Looker and Power BI to ensure that metrics, logic, and filters remain consistent and accurate. • Assist in developing and maintaining dbt tests (schema and data tests) to catch upstream data quality issues before they reach the reporting layer. • Provide ad-hoc support for existing dashboards, troubleshooting data discrepancies and fulfilling custom visualization requests. • Build clean, documented data models and optimize SQL queries to improve dashboard performance and reduce refresh times.

• Build Gold layer dbt models, including metric-level aggregations, KPI tables, and denormalized summary tables optimized for BI consumption in Sigma. • Author dbt Semantic Layer metric definitions using MetricFlow, including sell-through, out-of-stock (OOS) rate, conversion rate, average order value (AOV), weeks cover, and other metrics defined in the business metric register. • Populate and maintain the business glossary for each completed dataset, including metric definitions, calculation notes, known caveats, ownership, and data lineage. • Participate in business validation sessions with the onshore team and business stakeholders to ensure Gold metrics align with agreed metric register definitions prior to handover to Run operations. • Author and maintain dbt Explorer documentation, including model descriptions, column descriptions, and metric definitions to ensure the semantic layer remains fully self-documenting. • Support ongoing Run operations by managing metric change requests, implementing new Gold model additions, monitoring Cortex ML models, maintaining Claude NLQ context updates, and tracking AI agent uptime and performance. • Collaborate with stakeholders and cross-functional teams to validate business requirements, clarify KPI logic, and ensure consistent metric governance across the platform.

• Develop high-impact reporting and analytics providing visibility into business operations, lead efforts to scale reporting through automation • Partner with internal stakeholders (Sales, Product, Marketing, Finance, etc.) to increase the understanding, visibility and use of business metrics, encourage self-service analytics • Perform ad hoc data exploration and analysis to answer immediate business needs. • Identify opportunities to improve data quality, performance, and observability • Help develop standards for analytics engineering best practices

• Design and implement a multi-tier SaaS reporting infrastructure to support diverse client levels and brand campaign requirements. • Lead the GA4 and Google Tag Manager strategy, overseeing implementation, QA, and the definition of event tracking standards for QR scans, lead captures, and promo engagement. • Architect and manage GA4 data exports into BigQuery, building robust models that join event data with account, venue, and subscription datasets. • Integrate data from diverse sources including Sanity CMS, Mailchimp, SMS platforms, and POS systems to create a unified view of the consumer journey. • Develop reusable reporting templates and automated dashboards for client recaps, monthly summaries, and real-time campaign performance. • Evaluate and deploy reporting automation tools such as Looker Studio Pro, AgencyAnalytics, or Whatagraph to enhance scalability. • Establish data governance and access control protocols to ensure secure, account-specific reporting views. • Partner with product and engineering teams to ensure tracking requirements are seamlessly integrated into the development lifecycle. • Translate complex analytics into actionable business insights for internal stakeholders, venues, and brand partners. • Maintain comprehensive documentation including tracking plans, data dictionaries, and architectural workflows.