Associated Insurance and Risk Management Advisors is hiring: Business Analyst in

Join to apply for the Business Analyst role at Associated Insurance and Risk Management Advisors

Join to apply for the Business Analyst role at Associated Insurance and Risk Management Advisors

Description

Description

As a Business Analyst, you will be leading the charge in converting claim, exposure, and operational data into actionable insights that help our clients reduce their cost of risk, protect their people and customers, enhance their compliance programs, and save money on their insurance. You will be working with some of our largest clients and prospects to help them better manage their property, Workers Compensation, general liability, and automobile risks. For prospects (future clients), you will play an integral role in showcasing how we can improve their risk outcomes by putting data into action.

Our Ideal Candidate

• Intellectual curiosity always wanting to know answers to the questions of why, how, and so what
• Self-directed learner comfortable learning new skills, tools and domain knowledge independently
• Entrepreneurial problem solver identifies and solves nuanced problems through curiosity and resourcefulness
• Storyteller capable using data to motivate leaders to make decisions and take action
• Organized able to juggle multiple projects without compromising quality or timeliness
  
  

• Build and maintain custom client-facing dashboards in Power BI that showcase:
• Claim performance and trending, opportunities for improvement, and KPI tracking
• Total cost of risk estimates
• Experience modification analysis and projections
• Property portfolio characteristics
• Extract, cleanse, and blend structured and semi-structured data sources (loss runs, OSHA logs, telematics data, financials, hours worked reports, incident reports, etc.) to create a holistic analysis and complete story to tell clients
• Translate findings into executive-ready deliverables (slide decks, one-page briefs, research reports, talking points, etc.) that motivate clients to invest in safety, fleet, and compliance programs
• Support the sales team on new business pursuits by leveraging data and research
• Deliver diligence reports for private equity transactions that provide a complete view of risk on target acquisitions
• Identify automation opportunities to streamline recurring analytics workflows
• Act as a thought leader to service teams, producers, and clients. Always ask follow-up questions, challenge assumptions, and find actionable insights
• Deliver ad-hoc reports (loss summaries, experience modification histories, etc.) to clients and internal team members
  
  

• 1 - 3 years in a data analyst, business analyst, or similar quantitative role
• Bachelors degree in quantitative discipline preferred but not required
• Advanced Microsoft Excel skills (nested formulas, pivot tables, Power Query, VBA or similar automation a plus)
• Intermediate-to-advanced Power BI experience (DAX, data modeling, visual customization, etc.)
• Proven ability to turn messy data into clear, concise insights and recommendations for non-technical audiences
• Strong business writing skills that can turn complex analysis into crisp, client-ready language
  
  

• Skilled in workflow automation using tools like Power Automate
• Experienced in content/prompt engineering for large language models
• Proficient in extracting data from PDFs and other unstructured sources
  
  

• Click HERE for benefits
• Hybrid work schedule
• Bonus eligible
  
  

Seniority level

• Seniority level

  Entry level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Research, Analyst, and Information Technology

• Industries

  Insurance

Referrals increase your chances of interviewing at Associated Insurance and Risk Management Advisors by 2x

Get notified about new Business Analyst jobs in Rolling Meadows, IL.

Deerfield, IL $63,100.00-$101,200.00 2 hours ago

Chicago, IL $60,000.00-$110,000.00 1 month ago

Greater Chicago Area $60,000.00-$80,000.00 2 days ago

Analysis & Consulting - Process Analyst - Intermediate

Naperville, IL $80,000.00-$100,000.00 6 days ago

Chicago, IL $85,000.00-$95,000.00 1 week ago

Chicago, IL $95,000.00-$130,000.00 5 days ago

Business Process Analyst - Intermediate Line of Business

Schaumburg, IL $60,000.00-$70,000.00 2 weeks ago

Schaumburg, IL $120,000.00-$140,000.00 1 month ago

Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.