Customer Relationship Analyst

PT Electronic City Indonesia, Tbk; Jakarta Selatan; On-site; IDR 133,920,000 - 223,200,000; Full time

Job summary

PT Electronic City Indonesia, Tbk (ECII) invites a skilled professional to design and implement CRM and loyalty programs aimed at increasing customer transactions and engagement across our store network.

You will monitor performance, manage rewards inventory, analyze data, and collaborate with merchant partners to enhance member value. Candidates should have a Bachelor's degree and at least two years in CRM or related roles, with strong Excel and data visualization skills.

Qualifications

• Bachelor’s degree in Marketing, Management, Business, or related field.
• Minimum 2 years in CRM, loyalty, or customer engagement.
• Advanced Excel skills incl. Power Query and Power Pivot.
• Basic SQL knowledge for data retrieval.
• Strong data analysis and visualization to drive decisions.
• Excellent communication and negotiation with merchant partners.

Responsibilities

• Design and implement CRM/Loyalty programs to boost transactions and engagement.
• Monitor program performance against targets, results, and customer responses.
• Manage program reward inventory across stores.
• Analyze and visualize program data to support business decisions.
• Develop partnerships with merchant partners to expand benefits.
• Prepare reports and provide recommendations based on data and behavior.

Skills

CRM

Loyalty

Data Analysis

Power Query

Power Pivot

SQL basics

Merchant Partnerships

Excel

Education

Bachelor's degree in Marketing/Management/Business/Communication

Tools

SQL

Job description

Design and implement CRM/Loyalty Programs aimed at increasing customer transactions and engagement.

Monitor and evaluate program performance based on targets, transaction results, and customer responses.

Monitor and control program reward inventory, ensuring sufficient availability based on redemption needs across stores.

Process, analyze, and visualize program performance data to generate insights that support business decision-making.

Establish and develop partnerships with merchant partners to expand benefits and enhance value for members.

Prepare program performance reports and provide recommendations for improvement based on data analysis and customer behavior.

Requirements

Bachelor’s degree in Marketing, Management, Business, Communication, or other relevant fields.

Minimum 2 years of experience in CRM, Loyalty Program, Customer Engagement, Marketing, or a related role.

Advanced proficiency in Microsoft Excel, particularly Power Query and Power Pivot, for data processing and analysis.

Basic knowledge of SQL for data retrieval, filtering, and processing is a plus.

Strong skills in data analysis and visualization, with the ability to translate data into actionable insights and recommendations.

Strong communication and negotiation skills, particularly in establishing and maintaining relationships with merchant partners.

PT Electronic City Indonesia, Tbk. (Stock code: ECII), is a pioneer of modern electronic retail in Indonesia that was founded in 2001. Currently ECII already operates 60 stores spread across various regions in Indonesia and has covered 5 main Islands (Java, Bali, Sumatera, Kalimantan and Sulawesi). Electronic City provides a variety of products are available in four main categories include Audio-Videos, Home appliance, Mobile devices & gadgets, as well as IT and office equipment. Electronic City also pioneered to provide value added services to consumers.

PT Electronic City Indonesia, Tbk. (Stock code: ECII), is a pioneer of modern electronic retail in Indonesia that was founded in 2001. Currently ECII already operates 60 stores spread across various regions in Indonesia and has covered 5 main Islands (Java, Bali, Sumatera, Kalimantan and Sulawesi). Electronic City provides a variety of products are available in four main categories include Audio-Videos, Home appliance, Mobile devices & gadgets, as well as IT and office equipment. Electronic City also pioneered to provide value added services to consumers.