Hello Professionals,

We are looking for a Campaign Analytics Specialist for a contract role at both New York, NY and Los Angeles, CA. Please find the below job description and apply for the job if you are interested.

Role: Campaign Analytics Specialist

Location: New York, NY and Los Angeles, CA

Mode: Contract

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.

Mandatory: Advanced Excel, Complex SQL, Media domain, Digital Marketing

Key Responsibilities

Analyze campaign performance data and synthesize insights into clear compelling stories for internal stakeholders
Develop and maintain campaign performance dashboards and reporting templates using tools like Tableau Looker or Google Data Studio
Translate complex data sets into actionable insights and visual presentations for marketing media and executive teams
Collaborate with media planning and activation teams to design and evaluate AB tests brand lift studies and other measurement frameworks
Identify performance trends and anomalies and proactively recommend optimizations to improve campaign effectiveness
Help maintain data cleanliness by QAing raw campaign data correcting data errors and upholding campaign naming conventions
Handle adhoc requests to contextualize campaign data and support decisionmaking
Attend weekly meetings to understand campaign launches and market trends that may impact results
Manage multiple campaigns simultaneously prioritizing tasks and adapting to shifting timelines in a fastpaced environment
Stay current on industry trends emerging technologies and best practices in digital media analytics
Execute special projects and provide coverage for team members as needed

Qualifications

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

Campaign Analytics - Digital Marketing, Media, Advanced Excel and SQL complex queries

Job Type