

Smart IT Frame LLC
Data Analyst with SQL Query Writing, Advance Excel and Agency Experience
β - Featured Role | Apply direct with Data Freelance Hub
This role is a Data Analyst position requiring 7-11 years of experience, focusing on SQL complex queries, advanced Excel, and media domain agency experience. It is a 100% remote opportunity with a contract length and pay rate unspecified.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
Unknown
-
ποΈ - Date
September 25, 2025
π - Duration
Unknown
-
ποΈ - Location
Remote
-
π - Contract
Unknown
-
π - Security
Unknown
-
π - Location detailed
New York, NY
-
π§ - Skills detailed
#Data Pipeline #Data Engineering #Data Analysis #SQL (Structured Query Language) #Complex Queries
Role description
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.
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.