Perform marketing analytics using SQL and dbt to measure channel performance, attribution, CAC/ROAS, and campaign lift. Build and maintain Looker dashboards and data models, automate reporting, support CRM targeting, and partner cross-functionally to inform marketing and finance decisions while ensuring data quality.

Execute and optimize SEM campaigns across Google Ads, Microsoft Ads, and Apple Search Ads. Launch and QA campaigns, conduct keyword research, analyze performance, manage testing roadmaps, monitor budgets and tracking, and present actionable reports. Collaborate with Sales, Finance, and Analytics teams to improve measurement and campaign initiatives. Document processes, improve workflows, and support junior SEM specialists when applicable.

Execute affiliate marketing programs across publisher, card-linked offer, and event channels. Develop and validate affiliate links, coordinate content and creative assets, implement third-party event partnerships, track campaigns, and manage partner communications and outreach. The role requires strong organization, spreadsheet and data-analysis skills, cross-functional collaboration, and hands-on affiliate marketing experience.