Marketing Data Analyst

Position Summary:

Responsible for data extraction, dashboard and report preparation, summary insights, and contribution to cross-functional analysis presenting ideas and communicating insightful analysis in both written and presentation formats.

Primary Responsibilities:

• Compile, organize, and reconcile data. Deliver analytics and measurement documents, dashboards, charts and pivot tables on demand and for repeating milestones (e.g. weekly, monthly, quarterly or annual).
• Translate raw data and marketing results into easy-to-understand findings. Preparation of results into executive summaries and business reviews.
• Apply working knowledge of marketing analytics platforms (Google Analytics, social media analytics, CRM tools) to data analytics.
• Develop and maintain a working knowledge of digital marketing environment and best practices.
• Assist in setting up, tracking, and reporting on marketing test models (e.g. A/B). Measure, optimize and report outcomes of marketing tests.
• Utilize SQL queries to extract data from MS Azure and other data sources.
• Use Power Bi for data visualization and create dashboards & reports, extract insights.
• Collaborate with business stakeholders to analyze marketing campaigns for effectiveness and develop data driven strategies that lead to improvements in campaign performance and other key performance indicators, including competitive analysis.
• Stay updated in the latest analytics trends and technologies for global consumer brands, participating in educational opportunities, reading professional publications, maintaining personal networks, and participating in professional organizations.
• Create ad-hoc reporting and support new report development as needed. Assist with special department projects at the direction of the Insights & Analytics department leaders.

Job Specifications:

• Prefer a Bachelor's Degree in the field of -- Marketing or other related fields.
• Between 1-3 years of experience in marketing analytics, digital media, digital analysis.
• Between 1-3 years of experience in using Microsoft Power BI building reports & dashboards, creating semantic models and using Data Analysis Expressions (DAX) functions to calculate and analyze marketing data.
• Editing and writing Boolean, SQL queries with basic understanding of open- source data mining / data visualization. Proficiency in Microsoft Office programs: Excel, Word, PowerPoint, and Outlook
• Digital media certifications a plus: Net Base, a social listening tool
• Additional Preferred Knowledge, Skills, or Abilities to be successful in this role: Blend of a data and technical analyst, possess critical thinking skills and creativity to develop innovative, relative ways to track, measure and analyze digital marketing.

Base Pay Range: USD $68,640 - USD $85,000 (+)