The Analyst will work closely with the VP to support a portfolio of clients from various verticals who are investing in any combination search, social, digital video, programmatic display, linear TV, and OTT. Responsible for collecting, organizing, and analyzing data to find performance media insights. Responsible for managing a portfolio of reports in Tableau and Excel.
Advanced Media Analytics: Our core offering is finding the best mix of media and linking to performance outcomes (leads & sales). The primary responsibility for the Analyst and his / her team will be anything that improves upon this core offering via observations from testing or analytics. Specifically, this includes looking for links between performance and: initiated / influenced touchpoints, path length, days to convert, mobile / desktop, geography, creative, creative sequence, daypart, placement, channel, and completive share (spend and voice).
Data Visualization and Advanced Reporting: Support client campaign reporting in Tableau, Datorama and Excel. Responsibilities Include data manipulation in SQL, overarching reporting strategy, and design of visualizations.
Data Strategy: Finding insights in disparate data sources that can refine our marketing strategy. This data will include 1st and 3rd party data, website visitation trends, adserver logs, Comscore and other research sources, offline data trends.
Innovation & Development of Broadbeam Tools: The Analyst will support longer term “build” projects that contribute amazing new solutions to our overall offering. This is an opportunity to think broader, work closely with senior leadership teams, and participate in new business efforts.
Key Competencies Required
Analytical – Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; Completes statistical analyses; Queries complex data
Problem Solving – Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations
Technical Skills – Strong data querying, report building, statistical skills; Pursues training and development opportunities; Strives to continuously build knowledge and skills; Shares expertise with others.
Quality Management – Looks for ways to improve and promote quality; Demonstrates accuracy and thoroughness.
Strategic Thinking – Develops strategies to achieve client measurement goals; Analyzes market and competition; Identifies external threats and opportunities; Adapts strategy to changing conditions.
Planning/Organizing – Prioritizes and plans work activities; Uses time efficiently; Meets deadlines; Plans for additional resources; Sets goals and objectives; Develops realistic action plans.
Quality – Demonstrates accuracy and thoroughness; Looks for ways to improve and promote quality; Monitors own work to ensure quality.
Dependability – Follows instructions, responds to management direction; Takes responsibility for own actions; Keeps commitments; Commits to long hours of work when necessary to reach goals.; Completes tasks on time or notifies appropriate person with an alternate plan.
Innovation – Displays original thinking and creativity; Meets challenges with resourcefulness; Generates suggestions for improving work; Develops innovative approaches and ideas; Presents ideas and information in a manner that gets others’ attention.
BS/BA degree, preferably in Marketing Analytics, Statistics, or equivalent experience is required.
3+ years in marketing analytics with a focus on digital analytics, Television, and/or Online Video. Proven track record of directly supporting clients with a suite of analytical solutions.
Experience on the agency side is strongly preferred however, data visualization or consultancy experience will also be considered.
Expert in Excel
Highly proficient in a statistical analysis principles and software packages (R, SPSS, SAS, Minitab)
Highly skilled in accessing data from relational databases (SQL, Python)
Experience overseeing the build out of campaigns and extracting data from adservers and publisher platforms
Experience with BI tools including Tableau & Datorama
Experience with Google Analytics is preferred
Experience with digital media research tools is preferred: Comscore, Nielson
This position does not require any regularly scheduled travel.