Marketing Allocation Analyst

Job Description

Bachelor's degree or master's degree in business or related field.

Proven experience as a Technical Analyst, Data Analyst, or similar role involving SQL-based data manipulation.

Strong proficiency in SQL for data extraction, transformation, and reporting.

Python experience preferred.

Ability to work on multiple projects simultaneously.

Possess great communication and collaboration skills and be a creative problem solver.

Proficiency with MS Office suite, specifically Excel.

Handle change requests quickly and efficiently.

General understanding of Email and Mobile marketing best practices.

Responsibilities:Run and adapt SQL code to implement loyalty initiatives by pairing relevant offers to customers.

Maintain data structures that ensure accurate deployment of strategic offers to individual customers via personalized email, mobile app, website, and text push.

Leverage proprietary segmentations, customer insights and analytical results to improve the relevance and effectiveness of offers allocated to customers.

Ideate, build & integrate metrics - regarding a customer's segmentation, behavior & attitudes into current process with a focus on scalability and efficiency.

Implement controlled experiments & A/B testing (test and learn!) to show value of new or modified strategies.

Meet with Team/Internal Partners to discuss and manage strategies and operational needs. Partners include business development (digital content acquisition) and email teams to integrate and communicate offers; the analytics team to clarify details regarding test & learns in progress; and the IT team for development details and process productionalization.