Marketing Allocation Analyst

SETUP: Hybrid set-up - No. of days depending on the business needs / Amenable to work on Night shfit
OPEN Salary!!

Required Skill:
•SQL

DUTIES AND 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 the current process with a focus on scalability and efficiency.
•Implement controlled experiments & A/B testing (test and learn!) to show the 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.

Qualifications / Other Requirements:

•Bachelor's degree or master's degree in business or related field.
•With 2 years or more relevant experience.
•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.
•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