Reporting Collections Associate

hcmportal; Medellín; On-site; COP 42,000,000 - 54,000,000; Full time

Job summary

UPS in Medellin seeks a collections analyst to support complex billing tasks and produce ad-hoc and standard reporting for the department.

The role requires advanced Excel, Power BI, and cross-functional collaboration with finance, sales and operations to deliver insights in a fast-paced environment. This is a permanent position with a structured morning schedule.

Qualifications

• Bachelor's degree in business-related field preferred.
• Advanced Excel skills for report generation and data analysis.
• Experience in billing/collections and MS Office proficiency; strong communication.

Responsibilities

• Develops ad-hoc and standard reporting for the collections group.
• Provides account collection support for disputed items.
• Decides on credit suspensions, cancellations, and reinstatements.
• Tracks KPIs: revenue growth, gross margin, OPEX, working capital.
• Supports month-end close: accruals, journal entries, reconciliations.
• Collaborates with finance, sales and operations for insights.
• Manages advanced Excel, pivot tables and formulas.
• Creates reports using Power BI and MS Office tools.
• Supports BI dashboards and data analysis initiatives.

Skills

Advanced Excel

BI

Data analysis

Report preparation

Cross-functional collaboration

MS Office

Communication skills

Financial reporting

Problem solving

Education

Bachelor's degree in business

Tools

Excel

Power BI

PowerPoint

Accounting software

Job description

Before you apply to a job, select your language preference from the options available at the top right of this page.

Explore your next opportunity at a Fortune Global 500 organization. Envision innovative possibilities, experience our rewarding culture, and work with talented teams that help you become better every day. We know what it takes to lead UPS into tomorrow—people with a unique combination of skill + passion. If you have the qualities and drive to lead yourself or teams, there are roles ready to cultivate your skills and take you to the next level.

Job Description:

Job Summary

This position is responsible for assisting with collections and complex billing efforts commonly focusing on special projects which typically require significant experience and root cause analysis. He/She participates in the auditing of other associates’ work and may require follow up training as needed. This position is also involved with the preparation of complex reports and analysis using various software packages.

Responsibilities:

• Develops and/or completes ad-hoc and standard reporting for immediate group and/or the entire collections department.
• Provides account collection assistance for disputed items.
• Makes decisions regarding credit suspensions, account cancellations, and reinstatements.
• Track and report on key performance indicators (KPIs) such as revenue growth, gross margin, operating expenses, and working capital.
• Support month-end close activities, including accrual calculations, journal entries, and reconciliations.
• Collaborate with cross-functional teams (finance, sales, operations) to provide financial insights for decision making.
• You have strong hands-on skills in MS Excel including working with pivot tables, formulas.
• Proficient in the use of PowerPoint, Word and other Microsoft Office Applications to create documents and reports, etc.
• Possess some knowledge in BI (power BI), Dashboarding, preparing reports

Qualifications:

• Excellent written and verbal communication skills, with ability to effectively and professionally present information and answer questions
• Strong organizational and prioritization skills
• Problem solving skills requiring advanced research and root cause analysis techniques
• Ability to work in a team environment and consistently exhibit leadership and team building skills
• Ability to work in a highly measured, fast-paced, production environment
• Cross-functional billing and collections knowledge and ability to utilize multiple collection applications
• Proficient in report preparation and data analysis
• Prior phone center and/or collections experience - Preferred
• Bachelor’s Degree in Business related field - Preferred
• Advanced Excel skills for report generation, management, and data analysis.

Grade: 008
Location: Medellin
Schedule: Monday to Friday: 2:00 am - 11:30 am (44 weekly hours - after July 15th, 42 hours per week)

Employee Type: Permanent

UPS is committed to providing a workplace free of discrimination, harassment, and retaliation.