Smart IT Frame LLC

Compensation

Full Description

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.