Sr Financial Business Analyst
Herc Rentals Inc
Bonita Springs, FL
Apply
JOB DETAILS
SALARY
$80,000–$95,000 Per Year
SKILLS
Accounts Receivable, Accounts Receivable Management, Analysis Skills, Automation, Billing, Business Analysis, Business Support, Channel Strategies, Channel Support, Communication Skills, Credit and Collections, Cross-Functional, Data Analysis, Data Processing, Data Quality, Database Technology, Decision Support, Disability Insurance, Exceeded Sales Goal, Financial Analysis, Financial Reporting, Forecasting, Identify Issues, Leadership, Life Insurance, Microsoft Access Database, Microsoft Excel, Microsoft PowerPoint, Microsoft Visual Basic for Applications (VBA), Military, Multitasking, Needs Assessment, Past Due Accounts, Performance Metrics, Presentation/Verbal Skills, Problem Solving Skills, Process Development, Process Improvement, Rentals, SQL (Structured Query Language), Salesforce.com, Stock Market, Time Management, Web Analytics, Weight Management, Writing Skills
LOCATION
Bonita Springs, FL
POSTED
Today
Posting Start Date: 3/30/26
If you are currently an employee of Herc Rentals, please apply using this link: Herc Employee Career Portal
Founded in 1965, Herc Rentals is one of the leading equipment rental suppliers in North America with 2025 total revenues reaching approximately $4.4 billion. Herc Rentals' parent company, known as Herc Holdings Inc., listed on the New York Stock Exchange on July 1, 2016, under the symbol "HRI." Herc Rentals serves customers through approximately 602 locations and has about 9,600 employees in North America as of December 31, 2025.
Job Purpose
The Senior Business Analyst is responsible for facilitating financial reporting activities for Credit & Collections. This role requires a combination of analytical thinking, database experience, and advanced Excel capabilities, including VBA development, to streamline reporting processes and improve data accuracy.
This position reports to the AR Analytics and Customer Portal Billing Sr. Manager and will assist the team to meet/exceed departmental objectives and goals, KPI reporting, produce and analyze reports, and develop ways to automate reporting (using VBA, Macros, Access, etc.) and other duties as assigned.
What you will do...
- Design, develop, and maintain recurring receivables and ad hoc reports to support business decision-making
- Extract, manipulate, and analyze data from multiple sources using VBA and other tools
- Build and maintain automated reporting solutions using advanced Excel and VBA (beyond basic macro recording)
- Ensure data accuracy, consistency, and integrity across reports and systems
- Troubleshoot and optimize existing reports, queries, and automation processes
- Partner with cross-functional teams to identify reporting needs and process improvement opportunities
- Maintain awareness of assigned targets and meet/exceed these targets.
- Provide and articulate receivables reporting analysis to enable rapid, fact-based decision making and economic thinking.
- Areas of analysis may include overall receivables, cash forecasting, aging/percent delinquent/ DSO reporting/Bad Debt reporting, and dispute analysis.
- Develop and maintain good relationships with key business groups to enable improved decision-making.
- Support month-end, quarterly and yearly reporting.
- Become a subject matter expert and trusted partner supporting the analytical needs of the OTC credit and collections department
- Effectively communicate with various levels of leadership.
Requirements
- 5+ years of experience in business analysis, reporting, or data analytics
- 3+ years of experience with Access databases and Advanced Microsoft Excel skills, including writing and maintaining VBA code for automation
- Experience using various tools to analyze large amounts of data (i.e., Excel, SQL, Qlik, Salesforce, GetPaid, Dbeaver)
- Experience improving or automating manual reporting processes
Skills
- Data query and Data generation
- Data Analysis
- Expert Microsoft Excel skills (VBA, writing complex formulas), PowerPoint, Access
- Process improvement mindset
- Ability to manage multiple priorities and deadlines
SQL a plus - VBA Macro writing for process automation
- Excellent written, verbal, and non-verbal listening, communicating, and influencing skills
- Ability to work with minimal supervision and think logically & constructively
- Creative problem solver
- Self-Motivated, solutions-oriented
- Comfortable with ambiguity
What Success Looks Like
- Reporting processes are automated, reliable, and scalable
- Stakeholders receive timely, accurate, and actionable insights
- Manual effort is reduced through effective use of VBA and SQL
- Data issues are proactively identified and resolved
Req #: 68101
Pay Range: $80,000 - $95,000
Please be advised that the actual salary offered for any position is subject to the company's sole discretion and may be influenced by various factors, including but not limited to the candidate's qualifications, experience, location, and overall fit for the role.
Herc Rentals values its employees and provides excellent compensation and benefits packages which are not limited to the following.
Keeping you healthy
Medical, Dental, and Vision Coverage
Life and disability insurance
Flex spending and health savings accounts
Virtual Health Visits
24 Hour Nurse Line
Healthy Pregnancy Program
Tobacco Cessation Program
Weight Loss Program
Building Your Financial Future
401(k) plan with company match
Employee Stock Purchase Program
Life & Work Harmony
Paid Time Off (Holidays, Vacations, Sick Days)
Paid parental leave.
Military leave & support for those in the National Guard and Reserves
Employee Assistance Program (EAP)
Adoption Assistance Reimbursement Program
Tuition Reimbursement Program
Auto & Home Insurance Discounts
Protecting You & Your Family
Company Paid Life Insurance
Supplemental Life Insurance
Accidental Death & Dismemberment Insurance
Company Paid Disability Insurance
Supplemental Disability Insurance
Group Legal Plan
Critical Illness Insurance
Accident Insurance
Herc does not discriminate in employment based on the basis of race, creed, color, religion, sex, age, disability, national origin, marital status, sexual orientation, citizenship status, political affiliation, parental status, military service, or other non-merit factors.
About the Company
H