Analytics Support

Csmart International; Jakarta Pusat; On-site; IDR 360,000,000 - 480,000,000; Full time

Job summary

Csmart International in Jakarta seeks an experienced BI analytics consultant to join the team. You will work with client data to build segmentation, benchmarking, and predictive models, communicating insights to drive banking decisions.

The role requires Indonesian language fluency, English proficiency, and 5-7 years of BI analytics experience, especially in consumer banking. You will work on-site with clients and manage multiple priorities in a fast-paced setting.

Qualifications

• At least 5-7 years of working experience in business intelligence and/or descriptive, predictive, or prescriptive analytics.
• Experience in banking industry, preferably consumer banking.
• Ability to analyze large datasets and provide recommendations via descriptive analytics and BI.
• Experience with data analytics software (Python, R, SQL, SAS) and managing database structures.
• Strong MS Word, Excel, and PowerPoint skills.
• Ability to work with multiple stakeholders and clients in a fast-paced environment.
• Hands-on experience in consumer banking debit or credit card portfolio optimization analytics.

Responsibilities

• Conduct analysis using client data to develop segmentation and benchmarking.
• Create rule-based modelling and track performance against objectives.
• Review analytics deliverables for accuracy, quality, and timeliness.
• Support plan implementation and biweekly progress updates with steering committee.
• Coordinate with stakeholders and prepare materials for progress updates.
• Develop predictive models such as propensity to travel and attrition.
• Track campaign performance and assess results against objectives.
• Assess basic SQL skills through live query-writing exercise.
• Explain model objectives, approach selection, and validation of outputs.

Skills

Indonesian language

English proficiency

Tools

Python

R

SQL

SAS

Excel

PowerPoint

Word

Job description

• Native in Indonesian language and proficient in English
• Based in Jakarta and willing to work face to face in client's site
• Have at least 5-7 years of working experience in business intelligence and/or descriptive, predictive, or prescriptive analytics
• Ability to analyze large datasets and synthesize key findings to provide recommendations via descriptive analytics and business intelligence
• Have the knowledge on metrics, measurements, and benchmarking
• Data and analytics experience such as working with data analytics software (e.g., Python, R, SQL, SAS) and building, managing, and maintaining database structures
• Advanced Word, Excel, and PowerPoint skills
• Have experience in banking industry (preferably consumer banking)
• Can work independently and drive progress with banking clients
• Experience managing clients or internal stakeholders and ability to perform multiple tasks with multiple clients in a fast-paced, deadline-driven environment
• Have hands-on experience in consumer banking debit or credit card portfolio optimization analytics, including relevant analytics approaches and modelling
• Demonstrate basic SQL writing ability through an on-the-spot query-writing exercise; candidates should be able to construct logic independently rather than rely on copied queries
• Understand the objective of each modelling approach, why one approach is selected over another, and how to validate that model outputs are accurate and appropriate
• Be coachable and able to understand guidance and case objectives, respond to the question asked, and adjust their approach after feedback

Roles and Responsibilities

• Conduct analysis using Mastercard’s and or client’s data
• Create segmentation, benchmarking, rule based-modelling, and performance tracking
• Review analytics deliverables to ensure accuracy, quality and timeliness
• Support implementation of the agreed plan and mitigation actions agreed in the weekly cadence and steering committee meetings
• Support alignment between all stakeholders and help to coordinate as well as prepare the materials for biweekly progress updates and steering committee
• Create portfolio segmentation using factors such as merchant category code (MCC), dormancy and recency, and customer personas (e.g., traveller or foodie)
• Develop predictive models, such as propensity to travel and propensity to attrite
• Track campaign performance and assess results against objectives
• Assess candidates’ basic SQL skills through a live query-writing exercise
• Assess whether candidates can explain model objectives, approach selection, and validation of model accuracy and outputs