Let’s get started
Company Logo

Remote Jobs

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

10/2/2025

Somerset

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 https://www.smartitframe.com.

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.

Comments

No comments yet. Be the first to comment!