Business Intelligence Consultant II

At Allstate, great things happen when our people work together to protect families and their belongings from life’s uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers’ evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection. 

Job Description

Responsible for delivery and support of reporting solutions to enable data-based decision making. This role conducts operational data analysis and provides ongoing and ad-hoc reports to support the operational and sales support channels. The consultant will have a passion for problem solving, comfort with ambiguity and the ability to think conceptually, analytically, and creatively.

Job Description

Key Responsibilities

• Leverage data & analytical skills to identify opportunities to influence process improvement and growth & cost drivers

• Aggregate, validate, and analyze large quantities of data

• Produce ad-hoc queries for customers as needed

• Proactively lead interactions with customers to understand, develop, document, and analyze data and reporting requirements

• Work with key stakeholders to define, document, and socialize key metrics and integrate into reporting solutions

• Uncover data anomalies & inform team regarding potential data quality and BI Solution performance issues

• Validate, troubleshoot, and resolve end-user issues with systems and reporting tools

Education

• 4 Year Bachelor’s Degree (Required)

Experience

• 1-3 years of relevant experience (Required)

Skills

• Strong technical skillset, including Microsoft Excel, SQL, or Power Platform (Required)

Supervisory Responsibilities

• This job does not have supervisory duties.

Education & Experience (in lieu)

• In lieu of the above education requirements, an equivalent combination of education and experience may be considered.

Skills

Analytcial Thinking, Business Intelligence (BI) Solutions, Data Analysis, Data-Driven Decision Making, User Acceptance Testing (UAT)

Compensation

Compensation offered for this role is $56,500.00 - 99,962.50 annually and is based on experience and qualifications.

The candidate(s) offered this position will be required to submit to a background investigation.

Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.  

You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven …