Customer Engagement Data Analyst

Adore Me; New York (NY); On-site; USD 85,000 - 120,000; Full time

Job summary

Adore Me, a Victoria’s Secret & Co. subsidiary, seeks a hands-on Data Analyst to drive customer engagement and maximize lifetime value across CRM, loyalty, and retention programs. You will own analyses end-to-end—from data extraction and SQL analysis to actionable business recommendations.

You will partner with cross-functional teams to prioritize projects, measure impact, and suggest next steps to scale successful initiatives. On-site at Tribeca office three days a week.

Qualifications

• 2+ years of hands-on SQL experience with complex queries and performance tuning.

Responsibilities

• Write complex SQL queries to analyze customer cohorts, journeys, reachability and engagement patterns to improve retention and lifetime value.
• Build automated reporting across CRM channels (email, SMS, push) and loyalty programs; define KPIs and analyze A/B tests to guide targeting and messaging.
• Develop customer segments and analytical models (RFM, product affinities, churn indicators) to support personalization and LTV forecasting.
• Partner with Data Engineering and BI to ensure data accuracy, definitions, and reliable analytical datasets.
• Identify growth opportunities and prioritize projects by expected revenue, retention, and profitability impact; collaborate with stakeholders to measure outcomes.

Skills

SQL

A/B testing

Dashboards

Data analysis

Communication

Education

Data Analytics degree or related quantitative field

Tools

BigQuery

Snowflake

Looker

Looker Studio

Tableau

Power BI

Job description

Adore Me, a subsidiary of Victoria’s Secret & Co. (NYSE: VSXY) since being acquired in December 2022, is looking for a hands-on Data Analyst who combines strong technical skills with business judgment to improve customer engagement, and maximize lifetime value across CRM, loyalty programs and retention initiatives.

You will own analyses from business questions through data extraction, SQL data analysis, to business recommendations. You will partner with cross-functional teams to help prioritize projects, drive action, measure results and suggest next steps to maximize impact.

Responsibilities:

• Write complex SQL queries to analyze our customer file in depth: customer cohorts, purchase journeys, reachability, and engagement patterns to explain performance changes and identify opportunities to improve retention, repeat purchases, and lifetime value.
• Build automated reporting and measure incremental impact across CRM channels (email, SMS, push), and loyalty programs. Define consistent KPIs, design and analyze A/B tests and holdout experiments to guide targeting, messaging content and frequency, and lifecycle timing.
• Develop customer segments and analytical models using purchase behavior, product affinities, category preferences, RFM, and engagement signals to support personalization, cross-selling, reactivation, and LTV forecasting.
• Partner with Data Engineering and Business Intelligence to ensure data is accurate, reliable, and actionable, aligning on definitions, addressing data gaps, and improving analytical datasets.
• Drive business impact by identifying growth opportunities, guiding projects’ prioritization based on expected revenue, retention, and profitability impact. Partner with stakeholders implementing the recommendations to measure outcomes and recommend which initiatives to scale, refine, or discontinue.

Minimum Qualifications:

• 2+ years of hands-on SQL experience, regularly writing complex queries independently. Strong command of CTEs, window functions, multi-table joins, conditional aggregations, and query optimization in BigQuery, Snowflake, or a comparable warehouse.
• Ability to translate an ambiguous business question into an analytical approach, explore unfamiliar datasets, and deliver reliable, actionable findings.
• Strong understanding of data granularity, deduplication, and join logic, with the rigor to validate results and prevent misleading conclusions.
• Experience building dashboards in Looker, Looker Studio, Tableau, or Power BI.
• Solid quantitative skills, including cohort analysis, customer metrics, and statistical interpretation of experiments.
• Strong business judgment: understand how customer behavior drives revenue and profitability, connect detailed findings to the bigger picture, and focus on opportunities that materially improve performance.
• Ownership and a bias for action: take initiative, move work forward independently, and follow through from identifying a problem to helping implement a solution.
• Ability to communicate findings clearly and balance attention to detail with timely, practical decision-making.
• Ability and willingness to work on-site at our office in Tribeca 3 days per week

Preferred Qualifications:

• Python or R for deeper analysis, automation, or predictive modeling.
• Experience with CRM and loyalty data, customer segmentation, LTV forecasting, or churn modeling.
• Familiarity with e-commerce business models and incrementality measurement.
• Degree in Data Analytics, Statistics, or a related quantitative field.