Business Analyst
@ Associated Agencies Inc

Rolling Meadows, Illinois, United States
$60,000 - $75,000
On Site
Posted 18 days ago

Your Application Journey

Personalized Resume
Apply
Email Hiring Manager
Interview

Email Hiring Manager

XXXXXXXX XXXXXXXXXXXXX XXXXXXX***** @associatedagencies.com
Recommended after applying

Job Details

Business Analyst at Associated Agencies Inc

As a Business Analyst, you will lead the charge in converting claim, exposure, and operational data into actionable insights to help clients reduce cost of risk, protect people and customers, enhance compliance, and save money on insurance. You will work with some of our largest clients and prospects to better manage their property, Workers’ Compensation, general liability, and automobile risks, and showcase how data can drive improved risk outcomes.

Our Ideal Candidate

The ideal candidate is intellectually curious, a self-directed learner, an entrepreneurial problem solver, a storyteller with data, and exceptionally organized.

Core Responsibilities

  • Build and maintain custom client-facing dashboards in Power BI showcasing claim performance, cost of risk, experience modification analyses, and property portfolio details.
  • Extract, cleanse, and blend structured and semi-structured data sources into complete, holistic analyses.
  • Translate findings into executive-ready deliverables such as slide decks, briefs, and reports.
  • Support new business pursuits with data-driven insights and deliver diligence reports for private equity transactions.
  • Identify automation opportunities to streamline recurring analytics workflows and act as a thought leader.
  • Deliver ad-hoc reports to clients and internal teams as required.

Requirements

  • 1-3 years in a data analyst, business analyst, or similar quantitative role.
  • Bachelor’s degree in a quantitative discipline preferred but not required.
  • Advanced Microsoft Excel skills, with experience in nested formulas, pivot tables, and Power Query.
  • Intermediate-to-advanced Power BI experience (DAX, data modeling, visual customization).
  • Proven ability to transform messy data into clear insights and recommendations for non-technical audiences.
  • Strong business writing skills for presenting complex analysis in client-friendly language.

Additional Experience (Not Required)

  • Experience with workflow automation tools like Power Automate.
  • Content/prompt engineering for large language models.
  • Proficiency in extracting data from PDFs and other unstructured sources.

Associated Benefits

This role offers a hybrid work schedule and is bonus eligible. Click HERE for benefits.

Key skills/competency

  • Data Analysis
  • Power BI
  • Dashboard
  • Excel
  • Automation
  • Reporting
  • Risk Management
  • Data Cleansing
  • Storytelling
  • Client Communication
Apply without a personalized resume

How to Get Hired at Associated Agencies Inc

🎯 Tips for Getting Hired

  • Customize your resume: Highlight analytical tools and business insight skills.
  • Showcase project examples: Detail successful dashboard projects and data stories.
  • Highlight Excel expertise: Emphasize advanced Excel and Power BI skills.
  • Research Associated Agencies Inc: Understand their client and risk management focus.

📝 Interview Preparation Advice

Technical Preparation

Review advanced Excel functions and formulas.
Practice Power BI dashboard projects.
Refine data modeling and DAX skills.
Learn data extraction from varied sources.

Behavioral Questions

Describe a time you solved a complex problem.
How do you manage multiple projects simultaneously?
Explain your approach to client data storytelling.
Discuss a situation where you questioned assumptions.

Frequently Asked Questions