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.