Date: 1 week ago
City: Corona, California
Contract type: Full time

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
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.
- 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.
See more jobs in Corona, CA