Business Data Analyst II

Alliant Insurance Services•Omaha, NE

About The Position

The Business Data Analyst II works with account teams to process renewals, conduct and analyze marketing, prepare financial summaries, and provide technical support for assigned fully insured and self-funded accounts. The role performs analyses such as provider network comparisons and carrier utilization reviews, and supports account strategy through accurate reporting, recommendations, and coordination with carriers, vendors, and colleagues. The analyst initiates and manages renewal projects, gathers and validates client information, evaluates utilization and renewal responses, and prepares financial summaries and presentation materials. The position also supports plan option and marketing requests, negotiation strategy, ongoing client maintenance, and review of team members’ work as needed. It maintains accurate agency management system data and performs other duties as assigned.

Requirements

Bachelor’s degree or equivalent combination of education and experience.
One or more years of related work experience.
Valid insurance license, or ability to obtain one within 90 days of employment.
Meet continuing education requirements for license renewal.
Basic knowledge of compliance topics, including HIPAA, COBRA, ACA, and Medicare.
Basic knowledge of programs, including awareness of their existence and how to obtain a quote.
Knowledge of major fully insured and self-funded benefit insurance lines, including Medical, Dental, Vision, Life and Disability, and EAP.
Proficiency in Microsoft Office Suite, including Excel, PowerPoint, and Outlook.
Intermediate Microsoft Excel skills.
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 foster teamwork.
Ability to work productively as an individual to accomplish assigned projects.
Ability to prioritize work across multiple projects and deadlines.

Nice To Haves

A degree in Business or Mathematics.
Salesforce experience.

Responsibilities

Initiate recurring renewal projects for assigned accounts, including pre-renewal spreads, carrier renewal process initiation, and information requests.
Gather, review, and validate client information for renewal analysis and marketing, and develop familiarity with each client’s current details and history.
Evaluate carrier utilization reports to identify cost drivers and recommend possible plan design changes.
Coordinate and assist with renewal challenges and underwriting.
Create financial reporting packages from templates as needed.
Conduct provider network comparison and access disruption analyses.
Coordinate with the account team to understand client renewal strategy and define roles and responsibilities.
Track renewal project action items and deadlines throughout the renewal development process.
Work with insurance carriers and vendors to obtain preliminary or firm renewals and prepare initial financial summaries and benefit highlights.
Present preliminary renewal summaries and marketing results to the account team to determine plan options and marketing strategy.
Work with the account team to develop and execute negotiation strategy.
Present final results to the account team and determine renewal presentation content, structure, and supporting analytical materials.
Execute plan option requests, marketing projects, and analyses needed to complete account strategy objectives.
Review marketing and plan option responses for accuracy and completeness, and request clarifications or revisions as needed.
Handle ongoing monthly or quarterly client maintenance projects as determined by the account team.
Review team members’ work for accuracy and completeness as needed.
Maintain complete and accurate information in accordance with agency management system data standards and data integrity requirements.
Perform other duties as assigned.