Business Analyst

Socket.dev; Urbandale (IA); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Hybrid work arrangement

Annual bonus program

Job summary

AMBA is seeking a talented Business Analyst to join our Client Delivery Team in a hybrid work environment. You will act as a liaison between client teams, business units, and IT to develop system enhancements and online tools.

The role requires strong requirements gathering, SQL reporting, and UAT testing capabilities, with a focus on delivering effective solutions and continuous improvement. Join a team that values collaboration and professional development.

Qualifications

• Insurance and prior Business Analyst experience preferred.
• MS SQL experience (queries, functions, reports) is a plus.
• Experience performing UAT, Regression/Stress testing for system enhancements.

Responsibilities

• Acts as liaison between client team, business, and IT for system enhancements and online tools.
• Develops requirements using formal methodologies and communicates to stakeholders.
• Creates and analyzes SQL-based reports for distribution.
• Tests and validates system enhancements, server moves, production issues, and connectivity issues.
• Supports training and development of new processes and clean-up projects.

Skills

MS SQL

Power BI

Excel

Requirements gathering

UAT testing

Analytical thinking

Communication

Organization

Education

BA/BS preferred

Tools

MS Office

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.