Strategic AR & OTC Analytics Analyst

Concepcion Business Services, Inc.

Muntinlupa

On-site

PHP 600,000 - 1,000,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Concepcion Business Services, Inc. is seeking a professional to lead management reporting and AR analytics, delivering daily to quarterly OTC reports and executive dashboards. The role will develop AR aging analyses, monitor DSO, and provide actionable insights to senior leadership.

Strong data validation, ERP proficiency (Excel, SAP), and process-improvement mindset are essential. On-site in Metro Manila. Responsibilities include building dashboards, automating recurring reports, and

Qualifications

3–5 years of experience in Order-to-Cash, Accounts Receivable, Collections, and Financial Reporting.
Experience in Shared Services / Global Business Services preferred.
Knowledge of data analytics and process improvement.

Responsibilities

Prepare daily, weekly, monthly, and quarterly OTC management reports.
Develop executive dashboards and scorecards for senior leadership.
Prepare Accounts Receivable Aging reports and portfolio analysis.
Monitor customer payment behavior and collection performance.
Analyze trends affecting Days Sales Outstanding (DSO) and overdue balances.
Present actionable insights and recommendations to management.
Analyze customer accounts by aging buckets.
Identify high-risk accounts.
Monitor unapplied cash and credit balances.
Perform FIFO offsetting analysis when applicable.
Prepare customer exposure reports.
Analyze large datasets using Excel, Power Query, SAP, or similar ERP systems.
Validate data integrity across multiple systems.
Perform root-cause analysis of aging fluctuations.
Identify collection opportunities and process gaps.
Provide financial insights supporting strategic decisions.
Build interactive dashboards using AI, Microsoft Excel.
Automate recurring reports.
Standardize reporting templates.
Develop executive-level visualizations and infographics.
Identify opportunities to automate manual reporting.
Develop VBA macros and reporting automation.
Improve reporting efficiency and accuracy.
Support OTC transformation initiatives.
Document reporting processes and standard operating procedures.
Collaborate with: Collections Team, Credit Management, Sales, Finance, Business Controllers, IT / Data Analytics.
Ensure reporting complies with company policies and financial controls.
Maintain confidentiality of financial information.
Support internal and external audit requests.
Ensure data accuracy and consistency across reports.