Smart IT Frame LLC

Analyze marketing/media performance, translate agency reports into insights, implement optimization strategies and incrementality testing, create dashboards, and collaborate with internal and external teams. | 7 to 11 years experience with strong SQL and Excel skills, media domain and agency experience, ability to manage analytics communications and improve data governance. | Note: 100% remote opportunity Experience Level: 7 to 11 Years Skills: 1.SQL -> Complex Queries 2.Advanced Excel 3.Media domain platform experience 4.Agency experience Responsibilities: • Analyze marketing/media performance; provide actionable recommendations; support ad hoc analysis. • Translate agency reports into internal insights; ensure consistent interpretation of performance data. • Implement optimization strategies based on media mix model outputs and experimentation. • Implement incrementality testing roadmap with agencies; lead optimization discussions with partners. • Create and maintain dashboards for internal teams and external agencies. • Integrate agency data into business-specific reporting frameworks. • Support experimentation and testing to improve marketing effectiveness. • Manage incrementality testing with agency partners. • Work with internal marketing, data engineering, and external agencies. • Serve as primary liaison for all analytics-related communications with agencies. • Collaborate with data engineering to enhance marketing data pipelines and ensure integrity. • Improve governance and consistency in data handling with agencies.

Analyze media performance, optimize marketing strategies, create dashboards, support experimentation, and manage agency analytics communications. | Strong skills in SQL and Advanced Excel, experience with media domain platforms and agencies, and ability to manage agency relationships and data integrity. | Note: 200% remote. Need a candidate who is strong experience in SQL queris, Advanced Excel, Media domain and agencies form. Skills: 1.SQL -> Complex Queries 2.Advanced Excel 3.Media domain platform experience 4.Agency experience Core: • Analyze marketing/media performance; provide actionable recommendations; support ad hoc analysis. • Implement optimization strategies based on media mix model outputs and experimentation. • Create and maintain dashboards for internal teams and external agencies. • Support experimentation and testing to improve marketing effectiveness. • Work with internal marketing, data engineering, and external agencies. • Collaborate with data engineering to enhance marketing data pipelines and ensure integrity. Agency POC: • Translate agency reports into internal insights; ensure consistent interpretation of performance data. • Implement incrementality testing roadmap with agencies; lead optimization discussions with partners. • Integrate agency data into business-specific reporting frameworks. • Manage incrementality testing with agency partners. • Serve as primary liaison for all analytics-related communications with agencies. • Improve governance and consistency in data handling with agencies.