Business Analyst

Amba; Urbandale (IA); Hybrid; USD 65,000 - 95,000; Full time

Benefits offered by this job

Medical, dental, and vision

Annual bonus

401(k) matching

Paid time off & holidays

Volunteer days

Education support

Business casual

Hybrid work arrangement

Job summary

AMBA is seeking a talented Business Analyst to join our Client Delivery Team in an agile, team-oriented environment. You will bridge the client, business, and IT sides to implement system enhancements and online tools, documenting requirements and communicating them to stakeholders.

The role focuses on analysis, testing, reporting, and collaboration across carriers, vendors, and internal teams to deliver smooth deployments and data-driven improvements.

Qualifications

• Insurance experience and prior business analyst experience preferred.
• BA/BS degree preferred.
• Experience facilitating meetings and requirements sessions with stakeholders to document high-quality requirements.
• MS SQL experience (queries, functions, reports) is a plus.
• Experience performing UAT, Regression/Stress testing for system enhancements.
• Lean Six Sigma Certification is a plus.
• Power BI experience is a plus.
• Proficient in MS Office Tools (Excel, PowerPoint, Word, Access).
• Excellent written and verbal communication skills.
• Self-motivated with the desire for continuous improvement.
• Great analytical, critical thinking, and problem-solving abilities.
• Strong organizational skills and attention to detail.
• Adaptable and capable of working in a fast-paced environment.

Responsibilities

• Ensures requirements are communicated effectively to parties responsible for technical development and implementation.
• Provides client management system and website production issue research and support, including managing any clean-up required for customer files.
• Identifies, verifies, and documents functional and operational requirements using requirements management methodology and tools.
• Evaluates, troubleshoots, and analyzes business requests and submits requirements through JIRA.
• Manages the testing, communication, and documentation throughout development and production rollout.
• Develops reports through SQL scripts, analyzes data, and delivers reports through proper distribution channels.
• Identifies opportunities to streamline our processes, provide viable options for enhancements, and isolate the risks associated with them.
• Responsible for client management system and website testing, regression/sanity testing and/or UAT for all system enhancements, server moves, production issues, connectivity issues, etc.
• Assists with development and delivery of training and supplemental materials for new processes and clean-up projects.
• Responsible for the implementation and maintenance of system rating, solicitation, and policy issuance.

Skills

Requirements gathering

Stakeholder communication

Analytical thinking

Education

BA/BS Preferred

Tools

MS SQL

Power BI

JIRA

Excel

Job description

Description

AMBA was recognized by U.S. News & World Report as one of its 2026–2027 Best Companies to Work For.

AMBA is seeking a talented Business Analyst to join our growing Client Delivery Team! We are looking for someone who thrives in an agile, team-oriented environment.

About AMBA

Since 1981, AMBA has been a trusted provider of essential coverage for retired public servants nationwide. Our reach extends to diverse groups, including hardworking public employees, state retirees, educators, military personnel, trade professionals, firefighters, law enforcement, Unions, Alumni groups, Allied Healthcare, and other non-profit associations. As a full-service marketing and membership development company, we proudly offer outstanding insurance services to our vast network of 44 million members across 450+ associations in all 50 states.

Benefits

• Comprehensive benefits package including medical, dental, and vision insurance, spending accounts, and other voluntary benefits.
• Annual Bonus Program.
• Corporate 401 (k) matching.
• Generous time off, 10 paid company holidays, sick time off, and paid parental leave.
• Community Involvement perks, including 1 paid day off each year to volunteer with a local charity of your choice and company volunteer events.
• Support & development to cultivate your knowledge and continuing education to support your professional designations
• Business casual dress code.
• Hybrid work arrangement.

About the Role

The primary role of the Business Analyst is to act as a liaison between the client team, business, and IT in the development of system enhancements and online tools. Implement technology and process-based solutions by determining the requirements for a project or program, analyzing and documenting them, and communicating them to stakeholders.

Day-to-Day Responsibilities

• Ensures requirements are communicated effectively to parties responsible for technical development and implementation.
• Provides client management system and website production issue research and support, including managing any clean-up required for customer files. This entails working with various teams, carriers, and vendors.
• Identifies, verifies, and documents functional and operational requirements using requirements management methodology and tools.
• Evaluates, troubleshoots, and analyzes business requests and submits requirements through JIRA.
• Manages the testing, communication, and documentation throughout development and production rollout.
• Develops reports through SQL scripts, analyzes data, and delivers reports through proper distribution channels.
• Identifies opportunities to streamline our processes, provide viable options for enhancements, and isolate the risks associated with them.
• Responsible for client management system and website testing, regression/sanity testing and/or UAT for all system enhancements, server moves, production issues, connectivity issues, etc.
• Assists with development and delivery of training and supplemental materials for new processes and clean-up projects.
• Responsible for the implementation and maintenance of system rating, solicitation, and policy issuance.
• Other duties as assigned.

Requirements

• Insurance and prior Business Analyst experience preferred
• BA/BS Preferred
• Experience facilitating meetings and requirements sessions with stakeholders to document high-quality requirements.
• MS SQL experience (queries, functions, reports) is a plus
• Experience performing UAT, Regression/Stress testing for system enhancements
• Lean Six Sigma Certification is a plus
• Power BI experience is a plus
• Proficient in MS Office Tools (Excel, PowerPoint, Word, Access)
• Excellent written and verbal communication skills
• Self-motivated with the desire for continuous improvement
• Great analytical, critical thinking, and problem-solving abilities
• Strong organizational skills and attention to detail
• Adaptable and capable of working in a fast-paced environment

Physical Requirements

• Prolonged periods of sitting at a desk and working on a computer
• Continually required to utilize hand and finger dexterity
• Continually utilize visual acuity to operate equipment, read technical information, and/or use a keyboard

AMBA is an equal opportunity employer committed to providing a workplace free from harassment and discrimination. We celebrate the unique differences of our employees because that is what drives curiosity, innovation, and the success of our business. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, gender identity or expression, age, marital status, veteran status, disability status, pregnancy, parental status, genetic information, political affiliation, or any other status protected by the laws or regulations in the locations where we operate. We value diversity and the skills, knowledge, and experience that difference brings to our culture, attracting top talent with shared values and forming the foundation for a great place to work.