Reporting Collections Associate

UPS; Medellín; On-site; COP 44,640,000 - 78,120,000; Full time

Job summary

UPS Medellin is seeking a dedicated Collections Analyst to support complex billing, audits, and reporting. You will develop ad-hoc reports, monitor KPIs, and collaborate with finance, sales, and operations to drive cash flow.

The role requires advanced Excel skills (pivot tables, formulas), PowerPoint/Word, and a proactive problem-solving mindset. Bachelor's in business is preferred; permanent, on-site position with standard hours.

Qualifications

• Bachelor’s Degree in Business-related field preferred.
• Advanced Excel skills including pivot tables and formulas.
• Strong written and verbal communication abilities.
• Experience in collections, billing, or financial reporting is preferred.
• Ability to work in a fast-paced, cross-functional environment.

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 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

Skills

Advanced Excel

Pivot tables

Data analysis

Power BI

Strong communication

Team collaboration

Education

Bachelor's Degree in Business related field

Tools

MS Excel

PowerPoint

Word

Power BI

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.