Media Analyst (Remote)

Company Description

Moonrock is a New York-based media and content marketing agency at the forefront of gaming and traditional entertainment. Made up of veterans in digital media and gaming, we believe that every element of your campaign is vital and informs each element, which is why our approach is never siloed and always integrated. are a full-service NYC-based digital marketing & media agency specializing in the entertainment, retail, education, and technology verticals. Fearless Metaverse a

Job Description

MOONROCK is seeking an Analyst to lead analytics-based strategic insights and direction to aid in the development of communications initiatives for clients. Working closely with the Account Management, Creative, Strategy, and Media teams, this position provides both and internal and client facing consultative perspective on analytical tools, measurement, and testing.

Qualifications

• Recommend and design appropriate analytical methodologies based on business questions
• 3-4 years of work experience performing analytics initiatives
• Strong analytical skills and experience designing analytical solutions to address business problems
• Experience working with media and sales
• Proficient knowledge of advanced Excel, pivot tables, VLOOKUP
• Reporting background demonstrated by the ability to report from various tools conception to delivery (Excel/VBA, Tableau.) Must be and ADVANCED Excel power user.
• Ability to provide critical thinking: drawing conclusions, find creative solutions, structured problem-solving approach
• Proven ability to communicate complex, technical concepts to non-quantitative audience
• Ability to build relationships across team, departments, vendors and clients
• Exceptional oral and written communications skills
• Ability to effectively manage timelines and deliverables of multiple projects simultaneously
• Data visualization and Google data studio expertise required
• Ability to present relevant data to clients and establish streamlined methods or reporting and monitoring analytics

Responsibilities

• Function as the subject-matter expert for analytical tools and techniques
• Supports senior analyst team members in partnering with account teams (agency and client) on campaign planning and campaign effectiveness as well as in the development of plans and strategies to improve effectiveness of programs
• Research innovative and cutting-edge techniques and methodologies
• Partner with senior analytics team in the delivery and integration of conclusions and/or recommendations and actionable insights, including completing complex analysis and creating compelling visualizations for data
• Specific job functions include partnering with analytics team members to:
• Define key metrics and set goals
• Extract data from various digital tools establishing streamlined methods for reporting
• Complete data transformation, extraction, loading; merge formats
• Analyze and interpret media and sales performance
• Mine retailer websites for traffic, engagement, and sales data to drive actionable business insights
• Support advanced modeling and ROI/sales attribution analysis of shopper and media campaigns
• Visualize data and measurement outputs through PowerPoint presentations and customized Tableau dashboards

·     Function as the subject-matter expert for analytical tools and techniques.

Salary commensurate with experience