Collection Admin (Data Analyst & SQL)

Cartrack; Markham; On-site; CAD 50,000 - 65,000; Full time

Job summary

A leading smart mobility SaaS company is seeking a Collection Admin to manage daily collection activities and analyze collections data. The ideal candidate will have a Bachelor’s degree and 2+ years of relevant experience. Responsibilities include developing SQL reports and collaborating with different teams to improve processes. This full-time role is based in Markham, Canada, offering an opportunity for growth in a vibrant organization.

Qualifications

• 2+ years of experience in collections, credit control, accounts receivable, or analyst roles.
• Ability to write complex SQL queries and manipulate data.
• Excellent written and verbal communication skills.

Responsibilities

• Manage daily collection activities and work closely with the Team Leader.
• Analyze collections data to identify trends and areas of risk.
• Prepare and present collection performance dashboards and KPIs.

Skills

Data analysis

SQL

Excel

Communication skills

Problem-solving skills

Education

Bachelor’s degree in Finance, Accounting, Business Analytics, or related field

Tools

Excel

Power BI

Tableau

Job description

Join us to apply for the Collection Admin (Data Analyst & SQL) role at Cartrack.

We are a world-leading smart mobility SaaS company with over 2,000,000 subscribers across 23 countries. Our teams are collaborative, vibrant, and fast-growing. All team members are empowered to influence our business through ideas that drive innovation and efficiency.

Responsibilities

• Manage daily collection activities and work closely with the Team Leader to accelerate payment realization, particularly through tracking and monitoring supporting documents from both clients and internal units.
• Proactively collaborate with internal units.
• Analyze collections data to identify trends, payment behaviors, and areas of risk or opportunity.
• Develop, maintain, and optimize SQL queries and reports to support collections processes and business intelligence.
• Collaborate 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.
• Monitor and maintain customer account data integrity in internal systems.
• Reconcile payments, disputes, and escalated issues to ensure 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.
• 2+ years of experience in collections, credit control, accounts receivable, administration, or analyst roles.
• Proven experience in data analysis and SQL (ability to write complex queries, join tables, extract, and manipulate data).
• Strong proficiency in Excel (pivot tables, lookups, charts) and data visualization tools (e.g., Power BI, Tableau) is a plus.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent written and verbal communication skills.
• Ability to work independently and collaboratively in a fast-paced environment.

Seniority level: Entry level

Employment type: Full-time

Job function: Information Technology

Industry: Software Development

Referrals increase your chances of interviewing at Cartrack by 2x.

Sign in to set job alerts for “Data Analyst” roles.