Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
Senior Financial Analyst
HEALTHPLANONE, LLC - 3.0
Shelton, CT Job Details Full-time 1 day ago Benefits Health insurance Qualifications Bachelor's degree Financial data analysis tools Full Job Description HealthPlanOne's mission is to help people find the right health insurance at the right price, so they live healthier lives. We are committed to making the shopping process simpler. Our mission has never been more important than it is today. The Senior Financial Analyst will play a critical role within the Financial Analytics team. This position will be heavily involved in developing financial models and extracting valuable information from large data sources used to drive strategic business decisions. This role will also assist with analyzing payment and retention trends for each product line and calculating and reporting life-time value (LTV), persistency, pay-up rate, and other key performance indicators for the Executive team and Board. The role will also be responsible for transforming and automating processes and creating a reporting repository within the Company data visualization platform (DOMO).
Duties/Responsibilities:
Extract, merge and analyze sales and collections data from various disparate databases Prepare and present reporting on actual results across a variety of key performance indicators for the largest and fastest-growing business line Migrate key reports from Excel to DOMO and educate end-users on how to extract data through cards/links Identify trends and investigate, research and resolve data anomalies Calculate and report life-time commission revenue values (LTV) by product line, sales rep, lead source and other key and emerging variables Build collections waterfall analyses and revenue proof documentation as part of the monthly financial close process Assist CFO and CAO in explaining all key reporting to the external auditors, management team and Board Analyze carrier contracts vs. payments received to ensure HPOne is receiving accurate commissions Build and maintain policy reconciliation trackers based on analysis of payment history within SQL Finance database, carrier updates and portal extracts Work closely with the Support and Carrier Relations departments to help resolve unpaid policies, ensuring that the Company receives all commission revenue it is due Actively participate in weekly Executive Finance sessions with the CFO, CAO and other team members to review priorities and progress Ad-hoc reporting as requested Perform other related duties as assigned
Required Skills/Abilities:
Bachelor's degree in Finance, Data Analytics or related field 3-5 years' experience with 1-2 years as a senior financial analyst Highly proficient in Microsoft Excel (advanced) Strong planning and analytical skills with attention to detail Strong analytical, organizational and time management skills with attention to detail Ability to operate in a fast-paced environment and multi-task
Preferred Skills/Abilities:
Experience with data visualization tools (Power BI, Tableau, DOMO) Experience with
Workday Physical Requirements:
Must be able to remain in a stationary position (e.g., sitting or standing) for extended periods of time, typically in a cubicle environment (constant noise, fluorescent overhead lighting) Frequent use of a computer, dual monitors, keyboard, mouse, and other standard office equipment such as a telephone, copier, and printer. Must be able to communicate effectively, including exchanging information in person, in writing, by telephone, email or video conferencing. Visual and auditory acuity required to perform job duties effectively, including reading, writing, and interpreting information on screens or in print. Hand dexterity, fine motor skills needed to operate a keyboard and mouse efficiently Reach with hands and arms occasionally
For Hybrid Roles:
Must be able to commute to an office setting as required, which may include walking short distances and navigating an office environment. Occasionally moves about the office to access files, office machinery, and meet with others. Equal Employment Opportunity (EEO) is a fundamental principle at HealthPlanOne, where employment is based upon personal capabilities and qualifications. HealthPlanOne does not discriminate because of actual or perceived sex, sexual orientation or preference, gender identity, gender, transgender, race, color, religion, national origin, creed, citizenship status, ancestry, age, marital status, pregnancy, childbirth or related medical conditions, medical conditions including genetic characteristics, mental or physical disability, military and veteran status, or any other protected characteristic as established by law. HealthPlanOne requires the necessary drug testing and background checks as part of our pre-employment practices. If you need assistance or an accommodation due to a disability, please contact us to request accommodation at
