Digital Marketing Analyst - SQL Query Writing, Pivot Tables and Media Domain Experience

Note: Only locals in New York, NY and Los Angeles, CA (Onsite/ Hybrid - 2 to 3 days in a week) Experience Level: 10+ Years 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 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).