Job Summary The Marketing Analytics Associate is a strategic analytical partner who synthesizes data from multiple marketing sources to establish standardized measurement frameworks, deliver actionable insights, and bridge advertising execution with technology teams through dashboard development, testing design, and consistent analytical methodologies across the digital omni-channel landscape.
Responsibilities
- Build advanced dashboards with LOD expressions, custom visualizations, security controls, and reusable templates aligned with brand standards.
- Design star/snowflake schemas integrating customer, campaign, and performance data with conformed dimensions and ETL transformations for key marketing metrics.
- Write complex queries using joins, window functions, and CTEs to extract data, calculate CAC and attributed revenue, and perform cohort analysis and attribution modeling.
- Extract and analyze data from Google Analytics/Adobe Analytics, validate tracking implementation, ensure privacy compliance, and analyze conversion and session behavior.
- Automate API data extraction, perform statistical testing, integrate with Tableau via TabPy, create automated workflows, and maintain Git version control.
- Optimize dashboard performance, design scalable frameworks, document data lineage, and adhere to enterprise data standards.