CRM Intern

Tata CLiQ Fashion; Maharashtra; On-site; INR 134,000 - 268,000; Part time

Job summary

Tata CLiQ Fashion is seeking a CRM Data Analyst Intern to support customer retention initiatives through Cash Programs, CRM campaigns, and SQL-based insights. You will work with CRM, Marketing, Analytics, and Business teams to improve engagement, retention, and customer lifetime value.

This role is ideal for candidates interested in CRM, Customer Analytics, Marketing Analytics, SQL, and Business Analysis. Location is Mumbai (Vikhroli) with a 4-6 month duration and immediate joiner preferred.

Qualifications

• Must have strong analytical and problem-solving abilities.
• Basic SQL knowledge.
• Proficiency in Microsoft Excel or Google Sheets.
• Pursuing or recently completed a Bachelor's/Master's degree in Engineering, Economics, Business Analytics, Marketing, or a related field.

Responsibilities

• Support CRM and customer retention initiatives via cash programs, campaigns, and analytics.
• Write SQL queries to extract, validate, and analyze customer, campaign, and transaction data.
• Monitor campaign performance and identify optimization opportunities.
• Create views and dashboards to analyze retention, repeat purchase, and reactivation trends.
• Analyze campaign performance metrics such as Open Rate, CTR, Revenue, and ROI.
• Assist in preparing presentations, reports, and business recommendations.
• Collaborate with cross-functional teams to support data-driven decision-making.

Skills

Analytical thinking

Attention to detail

SQL basics

Excel/Sheets

Communication skills

Presentation skills

Education

Bachelor's/Master's degree in Engineering, Economics, Business Analytics, Marketing, or related field

Tools

Power BI

Tableau

Looker

Job description

About The Role

We are looking for a highly analytical and detail-oriented

CRM Data Analyst Intern

Location: Vikhroli, Mumbai

Duration: 4-6 Months

Immediate joiner preferred

About The Role

We are looking for a highly analytical and detail-oriented CRM Retention Intern to support customer retention initiatives through Cash Programs, CRM Campaigns, SQL-based insights, and campaign performance evaluation. The intern will work closely with CRM, Marketing, Analytics, and Business teams to help improve customer engagement, retention, and customer lifetime value.

This role is ideal for candidates interested in CRM, Customer Analytics, Marketing Analytics, SQL, and Business Analysis.

What You’ll Do

CRM & Customer Retention

• Streamlining process for high priority industry first feature – Power Cash (brand locked
• Planning marketing activities & innovations related to CLiQ Cash.
• Assist in planning and executing CRM campaigns.
• Monitor campaign performance and identify optimization opportunities.
• Assist in creating views to analyse customer retention, repeat purchase, and reactivation trends.

SQL & Data Analysis

• Write SQL queries to extract, validate, and analyze customer, campaign, and transaction data.
• Understand reports in detail and dashboards for tracking CRM and business metrics.
• Ensure data accuracy and consistency across analyses and reports.

Business Analytics

• Analyze campaign performance metrics such as Open Rate, CTR, Conversion Rate, Revenue, and ROI.
• Support ad-hoc business analysis and stakeholder reporting.
• Identify trends, insights, and opportunities from large datasets.
• Assist in preparing presentations, reports, and business recommendations.
• Collaborate with cross-functional teams to support data-driven decision-making.

Qualifications

Must Have:

• Excellent analytical and problem-solving skills.
• Strong attention to detail and data accuracy.
• Basic SQL knowledge.
• Proficiency in Microsoft Excel or Google Sheets.
• Pursuing or recently completed a Bachelor's/Master's degree in Engineering, Economics, Business Analytics, Marketing, or a related field (open to any Graduate)
• Good communication and presentation skills.

Good to Have

• Familiarity with Marketing concepts and customer lifecycle marketing.
• Experience with BI tools such as Power BI, Tableau, or Looker.
• Basic understanding of retention, churn, cohort, and funnel analysis.
• Knowledge of Python or data visualization tools.

Key Metrics Exposure

The intern will gain hands‑on experience working with:

• Customer Retention Rate
• Repeat Purchase Rate
• Churn Rate
• Customer Lifetime Value (CLV)
• Open Rate
• Click-Through Rate (CTR)
• Conversion Rate
• Return on Investment (ROI)

What You Will Learn During the Internship

• End-to-end CRM campaign management.
• Customer segmentation and retention strategies.
• Real-world SQL and analytics applications.
• Dashboarding and business reporting.
• Customer behavior analysis in an e-commerce environment.
• Stakeholder management and business communication.

Preferred Candidate Profile

• Data-driven and curious mindset.
• Strong interest in CRM, customer behavior, and analytics.
• Ability to work with large datasets and derive actionable insights.
• Self‑starter with strong ownership and willingness to learn.
• Ability to work effectively in a fast‑paced environment.