Business Data Analyst II
Job Description
Join Alliant Insurance Services in Omaha, NE (onsite) as a Business Data Analyst II, supporting account teams with renewal processing and data-driven analysis across fully-insured and self-funded benefits. This role combines analytics, reporting, and coordinated renewal execution, helping turn renewal inputs into clear summaries, plan options, and actionable marketing and negotiation support.
What You’ll Do
- Launch recurring renewal analyst projects for assigned accounts, including pre-renewal spreads, carrier renewal process initiation, and information requests.
- Gather, review, and validate client renewal and marketing information, building familiarity with current details and account history.
- Analyze carrier utilization reporting to identify cost drivers and recommend potential plan design changes.
- Coordinate renewal challenges (including underwriting) with the account team as needed.
- Create financial reporting packages from templates when required.
- Perform provider network comparison and access disruption analysis.
- Partner with the account team to support renewal strategy by defining roles, tracking action items, and outlining all deadlines.
- Work with insurance carriers and vendors to obtain preliminary and/or firm renewals, then produce initial financial summaries and benefit highlights.
- Present preliminary renewal summaries and marketing results to help determine plan options and/or marketing strategy, and support negotiation planning and execution with the account team.
- Present final results, including determining renewal presentation content and structure and identifying analytical support materials (such as utilization review, contribution strategy, benchmarking, and financial reporting).
- Execute plan option requests and related marketing projects and analysis to meet account strategy objectives.
- Review marketing and plan option responses for accuracy and completeness, requesting clarifications and revisions when needed.
- Support ongoing monthly or quarterly client maintenance projects as directed by the account team.
- Review team members’ work for accuracy and completeness as needed.
- Maintain agency management system data standards and data integrity by entering and keeping information complete and accurate.
- Complete other duties as assigned.
What You Bring
- Bachelor’s degree (or equivalent combination of education and experience).
- Preferred: Degree in Business or Mathematics.
- One (1) or more years of related work experience.
- Valid insurance license, or ability to obtain within ninety (90) days of employment.
- Ability to continue meeting Continuing Education requirements for license renewal.
- Basic knowledge of compliance topics: HIPAA, COBRA, ACA, and Medicare.
- Basic knowledge of programs, including awareness of how to get a quote.
- Preferred: Salesforce experience.
- Knowledge of major fully-insured and self-funded lines of benefits insurance: Medical, Dental, Vision, Life and Disability, and EAP.
Tools and Technical Skills
- Microsoft Office Suite, including Excel and Power Point
- Outlook and Salesforce
Success Profile
- Intermediate Microsoft Excel skills.
- Excellent verbal and written communication.
- Strong problem solving, time management, planning, organization, and prioritization.
- Good customer service skills, including telephone and listening skills.
- Ability to work both independently and collaboratively, and to support teamwork.
- Ability to manage multiple projects and deadlines.