Home
Jobs
Smart IT Frame LLC
Digital Marketing Analytics - SQL query writing, Pivot tables and media domain experience

Digital Marketing Analytics - SQL query writing, Pivot tables and media domain experience

On site

New york, United states

Junior

Freelance

24-11-2025

Share this job:

Score my CV

Skills

Communication Python Tableau Data Analysis SQL Presentation Skills Marketing Agile Analytics Google Analytics

Job Specifications

Job Title: Specialist Campaign Analytics

Location: Los Angeles, CA / NYC, NY (Onsite – Hybrid)

Employment Type: Contract

About Smart IT Frame:

At Smart IT Frame, we connect top talent with leading organizations across the USA. With over a decade of staffing excellence, we specialize in IT, healthcare, and professional roles, empowering both clients and candidates to grow together.

Key Responsibilities:

2-3 years of direct experience at a brand agency or related vendor in digital media field or role
Experience within the digital media industry in marketing advertising or advertising technology analytics with Entertainment Streaming space a huge plus
Direct digital media buying and activating also a plus
Strong understanding of digital paid media attribution metrics eg CPM CPA and performance benchmarks
Experience with ad servers eg CM360 Innovid and paid ad tracking platforms eg Google Ads Facebook Business Manager
Proficiency in web analytics tools eg Adobe Analytics Google Analytics
Advanced data analysis skills using Excel Tableau Data Studio experience building dashboards and visualizations from multiple data sources
Familiarity with SQL and understanding of Python andor R is a plus
Strong storytelling and presentation skills using Google Slides PowerPoint or Keynote
Detailoriented with strong documentation and QA skills to ensure data accuracy and consistency
Proactive selfmotivated and able to manage multiple projects independently
Strong verbal and written communication skills ability to explain technical concepts to nontechnical audiences
Comfort with agile workflows and ability to pivot quickly when priorities shift
Building reports and dashboards
Supporting campaign analysis and optimization
Proactive Communication needed with the planning team and other stakeholders
Technical Skills Tableau Looker Studio and other data analysis platforms
Familiarity with site analytics and media platform metrics
Technical proficiency in using data analysis tools and understanding audience management processes

Nice to Haves

Familiarity with thirdparty tools like Nielsen and Comscore is also beneficial

Education & Experience:

Bachelor’s degree.
2–3 years of experience in digital media analytics, marketing, or advertising (brand, agency, or vendor).

Technical Skills:

Advanced Excel (Pivot tables, data analysis).
Experience with Tableau, Looker Studio, or Google Data Studio for dashboards and reporting.
Familiarity with ad servers (e.g., CM360, Innovid) and paid ad tracking platforms (Google Ads, Facebook Business Manager).
Proficiency in web analytics tools (Adobe Analytics, Google Analytics).

Apply today or share profiles at rex@smartitframe.com

About the Company

Smart IT Frame stands as a leading NMSDC-certified IT Solutions and Servicing company, founded in 2012 with headquarters in Somerset, New Jersey. Our commitment to promoting Diversity, Equality, and Inclusion (DEI) values is unwavering. With our expertise, we support client initiatives by offering innovative IT solutions and services to leading System Integrators in the private and public sectors. Specializing in a comprehensive range of end-to-end services, including Artificial Intelligence (AI), Machine Learning (ML), IT ... Know more