Collection Admin (Data Analyst & SQL)

Cartrack Technologies Indonesia; Jakarta Selatan; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading smart mobility SaaS company in Indonesia is seeking a Collection Admin to manage daily collection activities and analyze data. This role requires a Bachelor's degree and 2+ years of experience in collections or data analysis. The ideal candidate will have strong SQL skills and be proficient in Excel and data visualization tools. Opportunities for career growth in a dynamic environment are available.

Qualifications

• At least 2 years of experience in collections, credit control, or analyst roles.
• Proven experience in data analysis and SQL, including complex queries.
• Proficiency in Excel with pivot tables and charts.

Responsibilities

• Manage daily collection activities and monitor supporting documents.
• Analyze collection data to identify trends and risks.
• Develop and optimize SQL queries and analytical reports.

Skills

Data analysis

SQL proficiency

Attention to detail

Communication skills

Problem-solving

Education

Bachelor’s degree in Finance, Accounting, Business Analytics, Information Systems

Tools

Excel

Power BI

Tableau

Job description

We are a world-leading smart mobility SaaS company with over 2,000,000 subscribers across 23 countries, and we are seeking a Collection Admin (Data Analyst & SQL) to join our team. Our teams are collaborative, vibrant, and fast-growing, with all members empowered to influence our business through innovative ideas and efficiency improvements.

Responsibilities

• Manage daily collection activities and work closely with the Team Leader to accelerate payment realization, including tracking and monitoring supporting documents from clients and internal units.
• Collaborate proactively with internal teams.
• Analyze collection data to identify trends, payment behaviors, and areas of risk or opportunity.
• Develop, maintain, and optimize SQL queries and reports to support collection processes and business intelligence.
• Work with finance, operations, and IT teams to implement data-driven solutions and process improvements.
• Prepare and present collection performance dashboards, KPIs, and analytical reports for management.
• Maintain data integrity of customer accounts in internal systems.
• Reconcile payments, disputes, and escalated issues for timely resolution.
• Assist in designing and implementing automated workflows for collection activities.
• Ensure compliance with internal policies, legal standards, and industry regulations.

Requirements

• Bachelor’s degree in Finance, Accounting, Business Analytics, Information Systems, or related field.
• At least 2 years of experience in collections, credit control, accounts receivable, administration, or analyst roles.
• Proven experience in data analysis and SQL, including writing complex queries, joining tables, and data manipulation.
• Proficiency in Excel (pivot tables, lookups, charts) and familiarity with data visualization tools (e.g., Power BI, Tableau) is a plus.
• Strong analytical, problem-solving, and attention to detail skills.
• Excellent written and verbal communication skills.
• Ability to work independently and collaboratively in a fast-paced environment.

PT Cartrack South East Asia is part of Cartrack Holdings Ltd., a global telematics company operating in 23 countries. We provide comprehensive fleet management solutions including real-time GPS tracking and data analytics. We develop our SaaS platform and manufacture IoT devices internally.

In Indonesia, we have a head office in Jakarta and a branch in Surabaya, with representatives in several other areas. Joining our team offers a dynamic, multinational environment with opportunities for career growth locally and regionally.

Visit our website: www.cartrack.id