Business Intelligence Analyst

Chubb•Chicago, IL

7d•$61,000 - $89,000•Hybrid

About The Position

Chubb Benefits is seeking a Business Intelligence Analyst to develop business intelligence dashboards and analyses using Snowflake and Power BI. The analyst will work closely with the Director of Business Intelligence and functional leadership on the design, development, programming, metadata, maintenance, and publication of reports that support business decisions. The position is based in Chicago, Illinois, with other potential locations in Columbia, South Carolina; Chattanooga, Tennessee; and Portland, Maine. The in-office expectation is four days per week, with one day remote. The pay range is $61,000 to $89,000, with the specific offer depending on the applicant’s skills and other factors. The role may also be eligible for a discretionary annual incentive program. Chubb offers a comprehensive benefits package; further details are available on its careers website.

Requirements

Three to five years of experience.
Bachelor of Arts degree required; preferably in IT, Computer Science, Data Analytics, Business Intelligence, or Finance.
Advanced knowledge of Excel.
Excellent knowledge of SQL programming.
Strong analytical, problem-solving, and multitasking skills.
Strong attention to detail.
Ability to self-start and work independently to complete assignments in a timely manner.
Novice-to-intermediate ability to leverage AI tools (Claude Code) to tune reports or code.

Nice To Haves

Knowledge of the insurance or claims industry.
Business intelligence and/or dashboard experience; DAX programming knowledge and Power BI experience are a plus.
Creative design experience.
Experience working with large databases in Snowflake or Azure.

Responsibilities

Create data visualizations and transform data into innovative dashboard designs.
Maintain large data sets, including validation, cleansing, and troubleshooting.
Create and maintain automated online reports using Power BI; update and maintain Excel and SQL sources, semantic models, and metadata to ensure data quality.
Debug technical issues as they arise.
Respond to ad hoc requests for analysis and reports from internal stakeholders, including Sales, Operations, Marketing, Underwriting, Legal, Actuarial, Training, and IT.
Develop skills and use business intelligence tools such as Power BI and Snowflake to drive functional efficiencies and deliver high-quality information solutions.
Analyze and integrate data from multiple sources.
Use a foundational understanding of AI tools to support personal productivity.