Data Analyst With Agency POC, Media, Advanced SQL, Advance Excel Exp

Smart IT Frame LLC; New York (NY); On-site; USD 74,000 - 110,000; Part time

Job summary

A contracting company based in New York is searching for a Mid-Senior Level BI Marketing Analytics Sr Analyst. The role involves analyzing media performance, creating dashboards, and collaborating with agencies for data optimization. Candidates must possess strong SQL and Excel skills, along with an understanding of media marketing. This is a contract position that offers flexible working conditions.

Qualifications

• Strong skills in SQL and Excel are mandatory for this role.
• Experience with media marketing analytics is required.

Responsibilities

• Analyze marketing/media performance; provide actionable recommendations.
• Translate agency reports into internal insights; ensure consistent interpretation of performance data.
• Implement optimization strategies based on media mix model outputs.
• Create and maintain dashboards for internal teams and external agencies.
• Collaborate with data engineering to enhance marketing data pipelines.

Skills

Advance SQL Coding

Advanced Excel

Agency Media Marketing Terms

Job description

Overview

We have a contract role with one of our clients. Kindly find the below details and let me know if you are interested.

Role: BI Marketing Analytics Sr Analyst

Type: Contract

MUST NEED Skills: Advance SQL Coding, Advanced Excel and Agency, Media Marketing Terms

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.

Seniority & Employment

• Seniority level: Mid-Senior level
• Employment type: Contract

Job Function & Industries

• Job function: Information Technology
• Industries: Software Development

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.