Sr Campaign Analyst

Overall Job Summary

The Sr. Campaign Analyst, Personalization and Deployment is responsible for supporting all functional areas related to campaign orchestration, and execution/deployment.  This role will use our Enterprise Data Warehouse and Campaign Databases to help identify opportunities and build improvements, create broader understanding, enhance functional support of customer personalization, assist with campaign execution, and research campaign data related questions. In addition, this role is expected to be a team lead and subject matter expert in the TSC Campaign Database.

Essential Duties and Responsibilities (Min 5%)

1. Become a functional expert in customer and campaign data, which includes but is not limited to defining data elements, providing input on data structure, creating & troubleshooting audience lists, and aiding in training documentation as needed. 
2. Troubleshoots campaign data flows to answer volume related questions and performs data analysis to provide waterfall counts 
3. Performs reconciliation of campaign data volume end-to-end (from EDW to Campaign Deployment) to understand and provide reasons for volume drop-off.  
4. Works cross functionally within Marketing, IT Marketing and Data Engineering to ensure that campaign data/technical requirements are conveyed and are reflected accurately in the systems post implementation.  
5. Performs end-to-end QC of campaign workflows, identifies opportunities, implements and documents enhancements. 
6. Supports deployment of personalization initiatives from a campaign data perspective from start to finish 
7. Monitors dashboards and campaign databases to ensure that they are synchronized.  
8. Collaborates with IT Marketing and Data Engineering to understand the data, system architecture that supports campaign orchestration. 
9. Leads high priority campaign data projects to ensure efficient, accurate, and on-time delivery of marketing campaigns 
10. Supports and aligns priorities to meet customer and business needs through consistent communication with key partners 
11. Leads internal team member training with potential to lead a direct report 
12. Monitors and ensures daily campaign data loads and list processing jobs are complete for campaigns to execute.  
13. Develops and interprets campaign dashboards and findings to business leadership

Required Qualifications

Experience:  3-4 years’ experience in Retail Campaign Activation, Analytics or related business. 

Education: Bachelor’s Degree in Business, Statistics, Finance, or equivalent experience. Any suitable combination of education and experience will be considered.

Preferred knowledge, skills or abilities

• Expert level SQL skills.  Expertise in other programming language(s) preferred  
• Experience with Alteryx/Tableau/PowerBI 
• Strong knowledge of Adobe Campaign, Zeta, SQL, Python, HTML, CSS, APIs, Marketing Automation systems, Movable Ink etc. 
• Demonstrated experience leading people through training or project management 
• Expertise with large data sets and relational databases 
• Ability to tell the customer data story clearly and concisely for various audiences, including leadership 
• Experience working with Customer Data preferred 
• Experience with Retail POS or Loyalty Program Data 
• High-level written and verbal communication skills 
• Proficiency in Microsoft Office products 
• Speak, read, and write effectively in the English language 

Working Conditions

Physical Requirements

Disclaimer

This job description represents an overview of the responsibilities for the above referenced position.  It is not intended to represent a comprehensive list of responsibilities.  A team member should perform all duties as assigned by his/ her supervisor.

Company Info