Accounts Receivable Financial Analyst
Posted 5 years ago
| Requirements | a:2:{s:5:"label";s:12:"Requirements";s:5:"value";s:521:"- Minimum 3 years' experience in Finance or Accounting related profession - Bachelor's degree in Accounting or equivalent required - Proficient in Microsoft Office suite, such as Excel & PowerPoint - Previous experience with receivables and collection preferred - SAP experience preferred - Tableau experience preferred, or relevant experience with other data warehousing tools - Strong attention to detail - Ability to work independently and manage multiple deliverables - Excellent oral and written communication skills";} |
| Education Qualification | a:2:{s:5:"label";s:23:"Education Qualification";s:5:"value";s:0:"";} |
| Responsibilities | a:2:{s:5:"label";s:16:"Responsibilities";s:5:"value";s:2202:"- Responsible for all global metrics reporting & target setting related to receivable and collection cycle, including days sales outstanding and past dues - End-to-end ownership over the Tableau past due report and logic - Maintain, document, and enhance existing receivables & collections reporting logic, structure, and data requirements. - Perform periodic analysis to help customer care and commercials teams to improve data quality tied to collection and billing - Own integrity of reporting of key metrics through validation of SAP and 3rd party tools receivables and customer master data - Build ad-hoc analytics to help understand performance drivers to support global cash flow leader and O2C process leader - Weekly consolidation of top past due and coming due details by customer for global cash councils - Perform calculation & automation of month end account reconciliations in Tableau, including AR subledger to general ledger and bad debt calculation - Operationalize key metrics by ensure proper maintenance on relevant collection hierarchies - Support integration of non-SAP entities onto SAP in order to ensure able in integrate into Tableau reporting - Partnering with IT to drive system enhancements to improve Tableau report performance and automation - Work with customer care to help support reporting requirement around customer disputes, resolution cycle time / Billing quality analytics & improvements - Work with global cash flow leader to set meaningful and actionable targets to the Operating and 3rd party service provided align to companies cash flow strategy & initiatives - Prepare commentary tied to operational performance for leadership on variance to prior periods and estimates - Prepare collection estimates based on historical trends and operational input to help provide line of sight - Prepare analysis for treasury on short term (1 week) and rolling 13-week collection estimates - Perform monthly bad debt reserve calculation leveraging Tableau in alignment with global policies and prepare journal entry - Support any Audit or SOX requirements related to OTC - Ability to drive continuous process improvements with business partners and Service Delivery Team";} |