Associated Insurance and Risk Management Advisors
Business Analyst
Associated Insurance and Risk Management Advisors, Rolling Meadows, Illinois, United States, 60008
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
Core Responsibilities
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
Requirements
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
Additional Experience (Not Required)
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
Associated Benefits
Click HERE for benefits Hybrid work schedule Bonus eligible
Salary Description
$60,000 - $75,000
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. #J-18808-Ljbffr
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
Core Responsibilities
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
Requirements
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
Additional Experience (Not Required)
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
Associated Benefits
Click HERE for benefits Hybrid work schedule Bonus eligible
Salary Description
$60,000 - $75,000
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. #J-18808-Ljbffr