Business Intelligence Analyst
The Business Intelligence Analyst will design and develop interactive Power BI dashboards using Snowflake data sources to support strategic decisions at Chubb. They will also maintain and validate large datasets, ensuring data quality and automated reporting for business stakeholders.
Skills required
About this role
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) and or other potential locations: Columbia, SC, Chattanooga, TN, Portland, ME
In-Office Expectation: 4 days in office, 1 day remote.
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."
