SUMMARY

This Marketing Analyst role supports the data-driven marketing strategy for both the digital marketing team and the entire marketing organization. This role is mainly responsible for preparing the monthly marketing performance reports for the head of marketing. The Digital Marketing Analyst also provides analytic services (implement data tracking, build QR codes, manage data inflows, conduct ad hoc analysis, etc.) within the marketing organization and also for cross functional teams. In addition, this role automates the processes for ETL, calculates attribution and incrementality of marketing channels and costs, and builds prediction and machine learning models to help optimize marketing performance.

PRIMARY RESPONSIBILITIES

• Build monthly marketing performance dashboards
• Conduct readout for monthly reports
• Support Marketing team members to maintain the trackable URL building tool
• Provide trackable QR codes to marketing team members
• Conduct ad-hoc analysis to answer business questions
• Automate the ETL process across all different marketing data sources
• Educate the marketing team members on Marketing KPIs and report results
• Build data models to predict marketing behaviors
• Help to build marketing yearly goals and report on the status of goal achievement.

REQUIRED KNOWLEDGE AND EXPERIENCE

• 3 years SQL experience- Google BigQuery preferred
• 3 years data visualization and reporting experience - Google Looker Studio preferred
• Experience integrating data from Pardot and Salesforce.
• Familiarity with A/B Testing via Sitecore's Content Management System
• Strong communication skills with both technical and non-technical stakeholders
• Strong ability in interpreting data and providing insights
• Establish KPIs to measure the effectiveness of business decisions
• Structure large datasets to turn usable information into actionable insights
• Strong writing skills
• Strong self-learning and self-management skills
• Ability to handle multiple tasks/projects simultaneously

#LI-REMOTE