Job Responsibilities
- Responsible for the timely and accurate production of weekly, monthly and quarterly metrics, reports and analyses on delinquencies, bad debt, and penalty revenues.
- Prepares budgets, forecasts and financial analyses for AR aging, bad debt and penalty revenues.
- Leads the creation, maintenance and update of complex financial models that forecast bad debt, penalty revenue and other operating expenses.
- Requires heavy use of large amounts of data, being able to analyze and understand the data and use it to improve models and provide variance explanations.
- Coordinates with key internal stakeholders to determine appropriate modeling assumptions and structuring for bad debt.
- Clearly communicates and presents analyses to senior management for financial decision making.
- Independently and/or cross-functionally conduct special projects that monitor, report and control risk factors driving bad debt.
- Works with Accounting to record month end accruals for monthly close process.
- Leads the process of gathering, analyzing, preparing, and summarizing recommendations for bad debt optimization and drivers of bad debt, including attrition, pricing, operational processes, etc.
- Creates financial analyses and narrative for quarterly earnings preparation on bad debt.
- Responds to ad hoc reporting requests by leadership.
- Performs all aspects of work with a high degree of effectiveness, efficiency and accuracy.
Requirements
- Bachelors degree in math, data analytics, business, finance, accounting, or economics from an accredited college or university required.
- Experience building financial models that use trends and multiple inputs to forecast future results.
- Minimum of five years of experience in a financially focused or data analysis role.
- Must be proficient with Power-Bi.
- 2 + years of Proficient Excel experience used to prepare reports and perform data analysis using lookup formulas and pivot tables.
- 3+ years with SAS.
- 3+ years with Python.
Preferred Qualifications:
- Obtains general knowledge of accounting concepts (income statement, general ledger, accruals, debits and credits).
- Experience with SAP General Ledger systems and/or Hyperion Planning systems is a plus.
- Experience with SAS, regression analysis and data analytics is a plus.
Additional Knowledge, Skills and Abilities:
- Ability to manage and organize workload in order to meet aggressive deadlines.
- Ability to work independently with minimal supervision and produce quality results but can also work effectively in a team-oriented environment.
- Ability to simplify and improve processes.
- Ability to adapt effectively to new and changing requirements.
- Obtains strong analytical and problem-solving skills and is detail oriented.
- Excels in quickly conceptualizing and assimilating data to make decisions and take appropriate action.
- Ability to effectively communicate to a wide range of audiences in both written and oral form.
Salary
$56 per hour
Benefits
N/A