Smart IT Frame LLC
Campaign Analytics - Digital Marketing, Media, Advanced Excel and SQL complex qu
Smart IT Frame LLC, New York, New York, us, 10261
Campaign Analytics - Digital Marketing, Media, Advanced Excel and SQL complex queries
Senior Technical Recruiter @ Smart IT Frame LLC
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 decision-making
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 fast paced 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 and/or R is a plus
Strong storytelling and presentation skills using Google Slides PowerPoint or Keynote
Detail oriented with strong documentation and QA skills to ensure data accuracy and consistency
Proactive self motivated 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
Seniority level:
Mid-Senior level
Employment type:
Contract
Job function:
Analyst
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.
#J-18808-Ljbffr
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 decision-making
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 fast paced 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 and/or R is a plus
Strong storytelling and presentation skills using Google Slides PowerPoint or Keynote
Detail oriented with strong documentation and QA skills to ensure data accuracy and consistency
Proactive self motivated 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
Seniority level:
Mid-Senior level
Employment type:
Contract
Job function:
Analyst
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.
#J-18808-Ljbffr