Business Data Analyst

Alliant Insurance Services

Omaha (NE)

On-site

USD 60,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 seeks an Analyst to support renewal processes for assigned accounts, including data gathering for pre-renewal spreads and marketing analysis with financial summaries.

You will evaluate carrier utilization reports, conduct provider network comparisons, and partner with the account team to shape renewal strategy and present results to clients. Strong Excel, MS Office, and communication skills are essential.

Qualifications

  • Bachelor's degree or equivalent in business or math preferred.
  • 1+ year of related work experience.
  • Valid insurance license or ability to obtain within 90 days of employment.
  • Must continue to meet Continuing Education requirements for license renewal.
  • Basic knowledge of HIPAA, COBRA, ACA, Medicare.
  • Salesforce experience preferred.

Responsibilities

  • Initiates renewal projects on assigned accounts (pre-renewal spreads, information requests).
  • Gathers and validates information for renewal analysis and marketing.
  • Evaluates carrier utilization reporting to identify key cost drivers.
  • Coordinates renewal challenges (underwriting) and marketing strategy.
  • Creates and updates financial reporting packages from templates.
  • Performs provider network comparison analysis (access disruption).
  • Collaborates with account team to define renewal strategy and deadlines.
  • Presents preliminary renewal summaries and marketing results to clients.
  • Executes plan option requests and related analyses to achieve renewal objectives.
  • Reviews marketing responses for accuracy and completeness.
  • Handles ongoing client maintenance projects as determined by the account team.
  • Ensures data integrity per agency standards.

Skills

Microsoft Excel
PowerPoint
Outlook
Analytical thinking
Communication (verbal & written)
Time management
Teamwork
Customer service
Attention to detail

Education

Bachelor's degree
Business or Mathematics background
Insurance license

Tools

Salesforce

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 II
Business Data Analyst II

Alliant Insurance Services • Omaha (NE)

On-site
USD 55,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
Account Manager - Employee Benefits

Alliant Insurance Services, Inc. • Tennessee

On-site
USD 60,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
Sales Analyst
Sales Analyst

BRMS • Folsom (CA)

On-site
USD 55,000 - 75,000