Business Data Analyst II

Alliant Insurance Services

Omaha (NE)

On-site

USD 55,000 - 75,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Alliant Insurance Services in Omaha, NE is seeking an Analyst to support renewals for fully-insured and self-funded accounts. You will collaborate with the account team to gather data, analyze carrier utilization, and present renewal options.

You will prepare financial summaries, conduct network analyses, and help drive negotiation strategies with carriers. The role requires a bachelor’s degree and insurance licensing or the ability to obtain one within 90 days, plus Salesforce and Excel

Qualifications

  • Bachelor's degree or equivalent combination of education and experience. Degree in Business or Mathematics preferred.
  • One (1) or more years related work experience
  • Valid insurance license (or must be obtained within ninety (90) days of employment)
  • Must continue to meet Continuing Education requirements for license renewal
  • Basic knowledge of compliance topics (HIPAA, COBRA, ACA, Medicare).
  • Basic knowledge of programs (know of existence and how to get a quote).
  • Salesforce experience preferred
  • Knowledge of all major fully-insured and self-funded lines of benefits insurance (Medical, Dental, Vision, Life and Disability, EAP)

Responsibilities

  • Initiates renewal projects on assigned accounts (pre-renewal spreads, information requests, etc.).
  • Gathers, reviews and validates information related to renewal analysis and marketing purposes.
  • Evaluates carrier utilization reporting to identify cost drivers and suggest plan design changes.
  • Coordinates renewal challenges (underwriting) and assists in negotiations.
  • Creates new financial reporting packages from templates as needed.
  • Conducts provider network comparison analysis (access disruption).
  • Prepares renewal presentations and marketing results with account team to determine plan options.
  • Develops and executes renewal strategy with the account team.

Skills

Verbal & written communication
Time management
Customer service
Planning & organization
Teamwork
Independent work
Prioritization

Education

Bachelor's degree in Business or Mathematics
1+ years related work experience
Insurance license

Tools

Salesforce
Microsoft Excel
PowerPoint
Outlook

Job description

SUMMARY

Responsible for working with account team in processing renewals, conducting and analyzing marketing, preparing financial summaries and providing general technical support for assigned fully-insured and self-funded accounts. Performs a variety of analysis including provider network analysis and carrier utilization analysis.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Initiates recurring analyst renewal projects on assigned accounts (pre-renewal spreads, carrier renewal process initiation, information requests, etc.); Gathers, reviews and validates all information related to assigned clients for renewal analysis and marketing purposes, gaining comprehensive familiarity with client’s current details and history;

Evaluates carrier utilization reporting to identify key cost drivers and make recommendations for possible plan design changes;

Coordinates and assists in renewal challenges (underwriting);

Creates new financial reporting package from templates as needed;

Conducts provider network comparison analysis (access disruption analysis);

Coordinates with account team to understand strategy for client renewal and define roles and responsibilities. Revisits throughout the renewal development process, outlining renewal project action items, including all deadlines;

Collaborates with all current insurance carriers and vendors to obtain preliminary and/or firm renewals and prepares initial financial summary and benefit highlights;

Presents preliminary renewal summaries and marketing results to account team to determine plan options and/or marketing strategy; works with account team to develop and execute negotiation strategy;

Presents all final results to account team; determines content and structure of renewal presentation and identifies analytical support materials (i.e.; utilization review, contribution strategy, benchmarking, financial reporting, etc.);

Executes all relevant plan option requests, marketing projects and necessary analysis to complete account strategy objectives;

Reviews all marketing and plan option responses, evaluates for accuracy and completeness, and requests clarifications and revisions as needed;

Handles ongoing (monthly/quarterly) client maintenance projects as determined by account team;

Reviews team members work for accuracy and completeness as needed;

Complies with agency management system data standards and data integrity (enters and maintains complete and accurate information);

Other duties as assigned.

QUALIFICATIONS
EDUCATION / EXPERIENCE

Bachelor's degree or equivalent combination of education and experience. Degree in Business or Mathematics preferred.

One (1) or more years related work experience

Valid insurance license (or must be obtained within ninety (90) days of employment)

Must continue to meet Continuing Education requirements for license renewal

Basic knowledge of compliance topics (HIPAA, COBRA, ACA, Medicare).

Basic knowledge of programs (know of existence and how to get a quote).

Salesforce experience preferred

Knowledge of all major fully-insured and self-funded lines of benefits insurance (Medical, Dental, Vision, Life and Disability, EAP);

SKILLS

Proficient in Microsoft Office Suite: Excel, Power Point, and Outlook

Intermediate skills in Microsoft Excel

Excellent verbal and written communication skills

Excellent problem solving and time management skills

Good customer service skills, including telephone and listening skills

Excellent planning, organizational and prioritization skills

Ability to work within a team and to foster teamwork

Ability to work productively as an individual to accomplish assigned projects

Ability to prioritize work for multiple projects and deadlines

#LI-GS1

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Data Analyst
Business Data Analyst

Senior Market Sales • Omaha (NE)

On-site
USD 55,000 - 90,000
Business Data Analyst
Business Data Analyst

Alliant Insurance Services • Omaha (NE)

On-site
USD 60,000 - 75,000
Employee Benefits Analyst II
Employee Benefits Analyst II

Alliant Insurance Services, Inc. • Houston (TX)

On-site
USD 55,000 - 75,000
Employee Benefits Analyst II
Employee Benefits Analyst II

Alliant Insurance Services • Houston (TX)

On-site
USD 65,000 - 90,000
Benefits Strategy Analyst: Mid-Market Renewals
Benefits Strategy Analyst: Mid-Market Renewals

Alliant Insurance Services • Chicago (IL)

On-site
USD 60,000 - 75,000
Benefits Analyst - Employee Benefits
Benefits Analyst - Employee Benefits

Alliant Insurance Services • Chicago (IL)

On-site
USD 60,000 - 75,000
Benefits Analyst
Benefits Analyst

Alliant Insurance Services, Inc. • San Francisco (CA)

On-site
USD 70,000 - 90,000
Account Manager - Employee Benefits - Mid Market
Account Manager - Employee Benefits - Mid Market

Alliant Insurance Services • Connecticut

On-site
USD 55,000 - 75,000
Account Manager - Employee Benefits
Account Manager - Employee Benefits

Alliant Insurance Services, Inc. • Tennessee

On-site
USD 60,000 - 90,000
Insurance Data Analyst - Renewal Strategy & Analytics
Insurance Data Analyst - Renewal Strategy & Analytics

Alliant Insurance Services • Omaha (NE)

On-site
USD 60,000 - 75,000