Our leading wholesaler and import client is looking for a Financial Analyst.
Position Overview:
- The Financial Analyst is a supportive role that is meant to assist the Distributor Relations Manager & finance team.
- The position operates within the confines of payables owed to TFC, which includes collections from wholesalers & credits for chargebacks owed to wholesalers.
- Functions include developing processes/procedures, generating reports in support of the finance team, auditing data for payment processing & maintaining data integrity.
Detailed Responsibilities:
Finance Processes & Procedures
- Develops & maintains processes that are useful & effective in order to streamline billbacks processing
- Understanding the needs of the billback team & developing methods to ensure efficient processing of distributors credits
- Interface with internal associates to identify necessary improvements to procedures & processes; suggest solutions & implement updates as necessary
- Works closely with IT to explore opportunities for improvement
Reporting
- Develops & maintains reports/databases that support the billbacks team, A/R team & upper management
- Billbacks aging tracker — Report to track progress of billbacks by team member (number & dollars in progress, numbers & dollars on hold, by program date) to identify issues & gaps in processing
- Depletions Levels Report — develops DA Levels report by market and audits data to ensure reconciliation against distributor DA billbacks for quicker processing.
- Commission Audit Reports — build & distribute shipment/depletions reports to assist audits of commission bills
- Budget Trackers — updates SP & DA budget tracker to provide management with a snapshot of spending vs budgets
- A/R Aging Target Reports — build & distribute A/R reports to assist collections/cleanup of statements; designed to identify target customers that require attention, along with analysis of short paid balances
- SharePoint – Oversee implementation & standardization of billback team dispute sheets & shared A/R team reports
- Additional Adhoc reports as needed (projects with other departments, reports for management, etc.)
Required Skills:
- Advanced Excel Proficiency – understanding & utilization of advanced formulas and macros (Visual Basic)
- Understanding of Accounting principles preferred – the position operates within an A/R environment (payables owed to TFC including credits issued to wholesalers
- Communication – must be able to effectively communicate with management & counterparts
- Attention to Detail – heavy data management requires a sharp eye; work must be double-checked to ensure integrity of data