Financial Analyst II

NFP, an Aon company; Cleveland (OH); On-site; USD 60,000 - 85,000; Full time

Benefits offered by this job

Competitive salary

PTO & paid holidays

401(k) with match

Exclusive discount programs

Job summary

NFP, an Aon company, is seeking a Financial Analyst in Ohio to review day-to-day financial reporting for select clients and create client-specific reports for analysis. The role also mentors a Junior Analyst and supports renewal projections and reporting processes.

Responsibilities include audits, data validation, and collaboration with Account Management; strong Excel, Power BI, and communication skills are essential for success in this on-site position in Cleveland.

Qualifications

• Four-year college or university degree in Finance/Statistics/Math is preferred or 6+ years of equivalent work experience.
• 3-5 years of related experience with a carrier, consultant or broker.
• Strong Microsoft Excel skills are required.
• Microsoft Access and Power BI/Power Query skills are preferred.

Responsibilities

• Review self-funded financial reports and provide comments for monthly or quarterly discussions.
• Manage claims audit, dependent audit, and plan optimization/contribution differential analysis.
• Develop self-funded renewal projections and prepare renewal options.

Skills

Critical Thinking

Active Listening

Strong Presentation/Speaking Skills

Project Management

Multi-Tasking

Communication Skills

Independent Work

Education

Finance/Statistics/Mathematics degree or 6+ years experience

3-5 years of related experience with a carrier, consultant or broker

Tools

Microsoft Excel

Microsoft Access

Power BI

Power Query

Job description

About the job

FINAN014784_1

Who We Are

NFP, an Aon company, is a multiple Best Places to Work award winner in Business Insurance. We are an organization of consultative advisors and problem solvers. We help companies and individuals around the globe address their most significant risk, workforce, wealth management and retirement challenges through custom solutions and a people-first approach. To learn more, please visit: https://www.NFP.com.

Summary: This full-time position requires review of day-to-day financial reporting and analysis for select clients. Position includes reviewing data for accuracy and creating client specific reports for analysis and review. Additionally, the Financial Analyst will serve as a mentor to a Junior Analyst.

Essential Duties And Responsibilities

• Review self-funded, financial reports and provide comments to Account Management team for monthly or quarterly discussions
• Mange claims audit, dependent audit, and plan optimization/contribution differential analysis process
• Develops self-funded renewal projections, assist in the preparation of financial renewal summary, prepare alternate funding options
• Prepare stop loss sensitivity analysis for self-insured clients
• Review client IBNR reserve analysis templates prior to actuarial review
• Proof exhibits created by Level 1 Analysts for mathematical, formulaic, spelling, grammatical and branding errors and ensure they are client ready
• Update excel-based templates/models to improve the reporting or renewal process
• Attends seminars or educational activities to stay up-to-date on the latest developments, trends and regulations in the market place
• Attend client meetings on an as-needed basis to review financial reports
• Maintain confidentiality and HIPAA compliance with all client information obtained in the course of work
• Build and maintain solid relationships carrier sales representatives and Account Management teams
• Additional duties as assigned

Knowledge, Skills, And/or Abilities

• Critical Thinking – Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems
• Active Listening – Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times
• Strong Presentation/Speaking Skills – Effectively communicating with others in an individual or group environment to articulate the items or information needed
• Project Management – Taking ownership of the project and seeing it through to completion through complex problem solving, operational analysis, quality control analysis, technology design, and exceptional time management
• Multi-Tasking – Efficiently organize work and manage time in order to meet deadlines and remain on task with designated timelines
• Knowledge of benefits administration, healthcare reform, industry trends, carrier products and services preferred
• Ability to correspond on all financial issues in a clear, concise and persuasive manner
• Ability to effectively establish rapport, present information and respond to questions from managers, clients and coworkers
• Ability to work independently
• Strong Communication and analytical skills
• 10% travel required - level of travel can potentially increase due to client growth.

Education And/or Experience

• Four-year college or university Finance/Statistics/Mathematics is preferred or 6+ years of equivalent work experience
• 3-5 years of related experience and/or training with a carrier, consultant or broker
• Strong Microsoft Excel skills required
• Microsoft Access and Microsoft Power BI and Power Query skills preferred

Certificates, Licenses, Registration

• Employees required to possess or obtain the Ohio Life and Health License within 4 months of employment
• Ongoing Education: CE Requirements

What We Offer

We're proud to offer a competitive salary, PTO & paid holidays, 401(k) with match, exclusive discount programs