The Business Analyst is responsible for facilitating financial reporting activities for Credit & Collections. This position will facilitate the weekly, monthly, and quarterly analyzing & reporting of key metrics. Develop reports that will enhance productivity and optimize resources.
This position reports directly to the Director, Credit & Collections, assisting the team to meet/exceed departmental objectives and goals, KPI reporting, coordinating audit requests, producing and analyzing reports, running approved macros, developing ways to automate reporting, creating a reporting database and other duties as assigned by management.
Maintain awareness of assigned targets and meet/exceed these targets.
Proactively create and enhance effective receivables reports and recommend areas of focus.
Provide and articulate receivables reporting analysis to enable rapid, fact-based decision making and economic thinking. Areas of analysis may include; overall receivables aging/percent delinquent/ DSO reporting/Bad Debt reporting, dispute analysis.
Recommend suspensions, re-activations and referrals to ensure bad debt
exposure is kept to a minimum.
Develop and maintain good relationships with key business groups to enable improved decision-making and integration of analytical function within the business.
Develop and maintain departmental Key Performance Indicators (KPI’s) to stay up to date in terms of portfolio statistics and collection performance as well as for reporting on exceeded credit limits & unapplied cash.
Assist collections management in developing and presenting proposals.
Supporting Internal Audit/External Audit & SOX Compliance.
Monthly review & coordination of user access.
Month-end close process & Quarterly reporting.
Build reporting database and initiating automation to gain efficiencies.
Produce SOPs, document processes and create process flow charts
Build and maintain various collections dashboards.
Other duties as assigned by management.
Conditions of Employment
Minimum 5+ year’s Analytical experience required with relevant exposure to financial reporting
Experience working with B2B collections portfolios
Experience with financial reporting
Experience in database creation and management
Previous leadership and 1st Level Supervisory experience a plus
SOX compliance experience and experience working with auditors
Experience executing testing cycles on various processes and reporting during systems upgrades
Experience producing SOPs, document processes and create process flow charts
Previous project management experience