Finance Collector (Power BI & Excel Specialist)
Pune, Maharashtra, India · Full Time
Be the first to apply
- Experience
- Any
- Salary
- —
- Openings
- 1
- Posted
- 20 hours ago
- Work mode
- In office
- Education
- Bachelor’s degree
- Resume
- Required to apply
Where you'll work
Job description
About the Opportunity
Join a Fortune Global 500 company and advance your career with UPS, a workplace that fosters innovation, skill development, and a supportive culture. We seek motivated individuals ready to lead themselves or teams toward future success.
Role Overview
The Finance Collector will handle Accounts Receivable management while resolving customer billing issues, ensuring proper reconciliation of unapplied payments, and reviewing disputed items for prompt resolution. This role also requires strong expertise in MIS reporting, advanced Excel, and Power BI to analyze data, create dashboards, and deliver insightful reports.
Key Responsibilities
- Develop, maintain, and automate daily, weekly, and monthly MIS reports for management review.
- Conduct detailed analysis of Accounts Receivable, Collections, Billing, Cash Application, and Dispute Management data using advanced Excel functionalities.
- Build and update dashboards, performance trackers, and business reports leveraging Excel and Power BI.
- Perform data reconciliation and validation to detect trends, gaps, and improvement areas within processes.
- Produce and disseminate analytical reports and presentations upon request.
- Monitor key business metrics and provide actionable insights derived from data evaluation.
- Ensure consistency, accuracy, and integrity of data across various reports and visualization tools.
- Support decision-making via ad hoc reporting and trend analyses.
Required Skills & Knowledge
- Exceptional verbal and written communication abilities to present information clearly and respond professionally.
- Advanced proficiency in Microsoft Excel and Power BI.
- Strong analytical thinking and problem-solving capabilities.
- Capability to perform effectively in high-pressure, fast-paced production environments.
- Bachelor’s degree mandatory.
- Experience in inbound or outbound calling is preferred.
- Familiarity with Accounts Receivable, Collections, and Billing processes is advantageous.
- Flexibility to work varied shifts according to operational requirements.
Additional Information
This position is a permanent employee role at UPS, a company dedicated to maintaining a discrimination- and harassment-free workplace.