Marketing Data Analyst

Job Description

 

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 (+)

 

 

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)