[Remote] Data Analyst with SQL query writing, Advance Excel and Agency experience

Note: The job is a remote job and is open to candidates in USA. Smart IT Frame LLC is a company offering a 100% remote opportunity for a Data Analyst. The role focuses on analyzing marketing and media performance, providing actionable recommendations, and supporting ad hoc analysis while collaborating with internal teams and external agencies. 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. Skills • 7 to 11 Years of experience • SQL -> Complex Queries • Advanced Excel • Media domain platform experience • Agency experience Company Overview • Smart IT Frame stands as a leading NMSDC-certified IT Solutions and Servicing company, founded in 2012 with headquarters in Somerset, New Jersey. It was founded in 2012, and is headquartered in Somerset, New Jersey, USA, with a workforce of 501-1000 employees. Its website is Company H1B Sponsorship • Smart IT Frame LLC has a track record of offering H1B sponsorships, with 5 in 2025, 9 in 2024, 11 in 2023, 8 in 2022, 9 in 2021, 9 in 2020. Please note that this does not guarantee sponsorship for this specific role. Apply tot his job