Assistant Manager / Senior Executive - CRM

Prince Pipes & Fittings; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

Prince Pipes & Fittings is seeking a skilled CRM Operations Analyst to manage day-to-day CRM activities, produce MIS reports, and drive data-driven decision support. The role involves coordinating with multiple departments, maintaining loyalty programs, and optimizing CRM processes.

The ideal candidate will excel in Excel, Power BI, and data analysis, with strong attention to detail and cross-functional collaboration. This on-site Mumbai position offers growth in FMCG/building materials sectors.

Qualifications

• Advanced Microsoft Excel (Mandatory)
• MIS Reporting & Dashboard Preparation
• Data Analysis & Business Reporting
• Excel Automation (Power Query, Macros preferred)
• MS PowerPoint & MS Word
• Power BI (Good to Have)

Responsibilities

• Manage day-to-day CRM operations and ensure smooth execution of customer engagement initiatives.
• Prepare, maintain, and analyze CRM MIS reports and dashboards using Advanced Microsoft Excel.
• Generate business insights through data analysis to support management decision-making.
• Coordinate with sales, finance, IT, marketing, vendors, and external partners for CRM-related activities.
• Administer customer loyalty programs, ensuring accurate processing, reconciliation, and issue resolution.
• Manage vendor relationships for loyalty program execution and other CRM initiatives.
• Monitor operational KPIs and prepare periodic performance reports.
• Ensure data accuracy, integrity, and timely availability of CRM information.
• Identify opportunities for process improvement and automation in CRM reporting.
• Support management presentations and documentation using MS PowerPoint and Word.
• Assist in CRM system enhancements, testing, and implementation of new initiatives.
• Ensure compliance with company policies and established CRM processes.

Skills

Advanced Excel

MIS Reporting

Dashboard Preparation

Data Analysis

Excel Automation

PowerPoint

MS Word

Power BI

Tools

Power Query

Macros

Power BI

Job description

Role Purpose

To manage CRM operations by ensuring timely MIS reporting, customer loyalty program administration, vendor coordination, data analysis, and seamless collaboration with internal and external stakeholders. The role focuses on improving operational efficiency, customer engagement, and decision-making through data-driven insights.

Key Responsibilities

• Manage day-to-day CRM operations and ensure smooth execution of customer engagement initiatives.
• Prepare, maintain, and analyze CRM MIS reports and dashboards using Advanced Microsoft Excel.
• Generate business insights through data analysis to support management decision-making.
• Coordinate with sales, finance, IT, marketing, vendors, and external partners for CRM-related activities.
• Administer customer loyalty programs, ensuring accurate processing, reconciliation, and issue resolution.
• Manage vendor relationships for loyalty program execution and other CRM initiatives.
• Monitor operational KPIs and prepare periodic performance reports.
• Ensure data accuracy, integrity, and timely availability of CRM information.
• Identify opportunities for process improvement and automation in CRM reporting.
• Support management presentations and documentation using MS PowerPoint and Word.
• Assist in CRM system enhancements, testing, and implementation of new initiatives.
• Ensure compliance with company policies and established CRM processes.

Key Skills & Competencies

Technical Skills

• Advanced Microsoft Excel (Mandatory)
• MIS Reporting & Dashboard Preparation
• Data Analysis & Business Reporting
• Excel Automation (Power Query, Macros preferred)
• MS PowerPoint & MS Word
• Power BI (Good to Have)

Behavioural Competencies

• Analytical Thinking
• Proactive Approach
• Effective Communication
• Time Management
• Adaptability
• Coordination & Stakeholder Management
• Attention to Detail
• Problem Solving

Preferred Experience

• Experience in handling high-volume CRM operations.
• Exposure to customer loyalty/rewards programs.
• Vendor management experience.
• Cross-functional coordination with multiple business teams.
• Experience in FMCG, Building Materials, Consumer Durables, or Manufacturing industries is preferred.