Business Analyst

Association Member Benefits Advisors; Urbandale (IA); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Annual Bonus Program

401(k) matching

Paid holidays

Volunteer day

Hybrid work arrangement

Medical insurance

Dental & Vision

Job summary

Association Member Benefits Advisors (AMBA) is seeking a Business Analyst to join our Client Delivery Team in Urbandale, IA. This role thrives in an agile, team-oriented environment.

The Business Analyst will bridge client, business, and IT, document requirements, and help implement system enhancements and online tools. Strong SQL and BI skills are valued.

Qualifications

• Experience facilitating meetings to document 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.

Responsibilities

• Act as a liaison between the client team, business, and IT for system enhancements and online tools.
• Document and communicate requirements to stakeholders.
• Develop reports and SQL scripts; deliver reports through approved channels.
• Support client management system and website production issues with various teams.
• Coordinate testing and production rollout; manage regression/sanity testing and UAT.
• Assist with training and supplemental materials for new processes.

Skills

Requirements gathering

Stakeholder facilitation

Analytical thinking

Communication skills

Attention to detail

Problem-solving

Self-motivated

Organizational skills

Adaptability

Education

BA/BS preferred

Tools

MS SQL

Power BI

Excel

PowerPoint

Word

Access

Job description

Full-time

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 w