Marketing & Media Analytics Analyst

JOB SUMMARY

The Analyst of the Marketing and Media Analysis & Reporting Group is responsible for delivering reports, analyses and insights around campaigns and marketing performance across multiple marketing channels (Direct Mail, Email, Media and Digital). This includes marketing aimed at individual consumers and small-to-medium-sized Businesses. This individual is expected to create analytics on a tactic and overall market performance.

MAJOR DUTIES AND RESPONSIBILITIES

• Manages the completion of standard and ad hoc reports and analyses based on data from a variety of sources.
• Serves as a Business Analyst who is able to consult with their marketing peers on future strategies, explain variances in volumes month to month, provides performance reporting, and manages marketing projects.
• Works with complex data in a relational database environment, and uses numerous data sources to determine the best approach to create reports, and analyze strategy performance.
• Manages the development of standard and ad hoc reports related to the data warehouse and data append processes.
• Ensures the integrity of data in the direct-to-consumer marketing data warehouse.
• Perform other duties as assigned.

REQUIRED QUALIFICATIONS

Required Skills/Abilities and Knowledge

• Ability to read, write, speak and understand English
• Ability to multitask, prioritize and execute deliverables in a high-pressure environment
• Ability to analyze/interpret data and continually evolve based on key learnings
• Advanced Excel & PowerPoint presentment skills
• Advanced skills in one or more of the following programs: SQL, VBA, SAS, R, Python
• High attention to detail & ability to prioritize & organize effectively
• Demonstrated ability in visualizations, designing and developing dashboards on a variety of different platforms (Excel, PowerBI, MSTR, Tableau, Adobe etc.)
• Excellent problem solving and analytical skills including budgeting, forecasting, advanced modelling, attribution and strategic testing
• Firm understanding of test and control methodologies
• Knowledge of best practice marketing strategies and procedures

Required Education

Bachelor's degree in Marketing, Mathematics, Statistics, Business, Computer/Data Science

Required Related Work Experience and Number of Years

Related Work Experience

• Marketing Analytics experience - 3+ years
• Marketing Database/Technology experience - 3+ years
• Marketing Test Design/Audience Segmentation experience - 3+ years
• Data Mining & or Data Science experience - 3+ years
• Experience with attribution modeling & forecasting techniques - 3+ years

PREFERRED QUALIFICATIONS

Preferred Skills/Abilities and Knowledge

Expertise with Data extraction, reporting, and visualization tools (i.e. SQL, Tableau, Microstrategy, etc)

Preferred Education

MBA/advanced degree

WORKING CONDITIONS

Office work environment