Business Intelligence Analyst

Chubb•Chicago, IL

6d•$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 role is based in Chicago, Illinois, near Rosemont’s Triangle Plaza, or may be filled in Columbia, South Carolina; Chattanooga, Tennessee; or Portland, Maine. The in-office expectation is four days per week, with one day remote. The stated pay range is $61,000 to $89,000; the specific offer depends on the applicant’s skills and other factors, and the role may also be eligible for a discretionary annual incentive program.

Requirements

Three to five years of experience.
Knowledge of the insurance or claims industry.
Excellent technical skills, including 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 use AI tools, such as Claude Code, to tune reports and code.
Bachelor of Arts degree required, preferably in IT, Computer Science, Data Analytics, Business Intelligence, or Finance.

Nice To Haves

Business intelligence and/or dashboard experience.
DAX programming knowledge and Power BI experience.
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 datasets, 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 analyses 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.