This role will be responsible for: • Preparing financial, operational, and business-related analyses related to bad debt and penalty revenue fees • Data analytics required to decipher trends and perform appropriate reports and analyses • Monitoring and preparing financial forecasts based on inputs from business owners and historical and expected trends • Monitoring key data inputs and drivers to ensure financial forecasts and variance analyses are accurate • Compiling and preparing financial performance metrics, reports and presentations, along with communicating results to key stakeholders • Identifying reporting and forecasting improvements that can be made to improve performance and reduce manual workload
Essential Duties/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.
Minimum 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
Python, SAS and Analytics • 2 + years of Proficient Excel experience used to prepare reports and perform data analysis using lookup formulas and pivot tables.
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