Business Intelligence Analyst
At a glance
Mid-level Data Analysis & BI role at Chubb. Chicago · full-time · $61,000–$89,000 base.
dataroles summary, based on the employer's posting.
What you'll do
- Build Power BI dashboards and visual reports that turn data into material for business decisions
- Clean, validate and troubleshoot large datasets, then maintain their quality across reports and underlying sources
- Create automated Power BI reporting and keep Excel, SQL sources, semantic models and metadata current
- Combine information from multiple sources, resolve technical issues and answer internal teams’ analysis requests
- Use Snowflake, Power BI and AI tools to improve reporting workflows and support your own productivity
What you bring
- You have three to five years of experience and a bachelor’s degree is required
- You bring advanced Excel skills and strong working knowledge of SQL
- You have BI or dashboard experience; Power BI and DAX familiarity are listed as advantages, not requirements
- You can work independently, manage competing tasks and check details while solving analytical problems
Who this fits
This mid-level role suits someone who can build and maintain reports while responding to analysis needs from internal teams. The position is based in Chicago near Rosemont. The stated annual pay range is $61,000 to $89,000, with a possible discretionary annual incentive.
From the employer
Chubb Benefits, is seeking a Business Intelligence Analyst to join our fast-paced, high energy, growing company. We are proud of our tradition of success in the insurance industry of over 100 years. Come join our team of hard-working, talented professionals!
JOB Summary
This position will be responsible for the development of Business Intelligence dashboards and analysis using Snowflake & Power BI . He/she will work closely with the Director of business Intelligence and functional leadership to deliver on the design, development, programming, meta data, maintenance, and publication of reports that play a key role in driving business decisions.
Responsibilities
- Create data visualizations and transform data into innovative dashboard designs
- Maintain large sets of data that require validation, cleansing, and troubleshooting
- Create and maintain online automated reports using Power BI; update and maintain Excel, SQL sources as well as semantic models & metadata to ensure data quality
- Debug technical issues when 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 leverage Business Intelligence tools such as Power BI & Snowflake to drive functional efficiencies and deliver high-quality information solutions
- Analyze and integrate data from multiple sources
- Leverage a foundational understanding of AI tools to support personal productivity
Skills and Experience
- Three to five years experience. Knowledge of insurance/claim industry plus
- Excellent technical skills including advanced knowledge of Excel
- Excellent knowledge of SQL programming language
- Business Intelligence and/or dashboard experience; DAX programming knowledge and Power BI a plus!
- Creative design experience a plus!
- Experience working with large databases in Snowflake or Azure a plus
- Strong analytical, problem-solving and multi-tasking 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/code
Education
- BA required, preferably in IT, Computer Science, Data Analytics, Business Intelligence, or Finance
Location: Chicago, IL (near Rosemont, IL Triangle Plaza).
The pay range for the role is $61,000 to $89,000. The specific offer will depend on an applicant’s skills and other factors. This role may also be eligible to participate in a discretionary annual incentive program. Chubb offers a comprehensive benefits package, more details on which can be found on our careers website. The disclosed pay range estimate may be adjusted for the applicable geographic differential for the location in which the position is filled."