Business Intelligence and Data Analytics Consultant II - Remote

Allstate Corporation
Washington, CA, United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Starter
Experience required
2 years minimum
Compensation
$60,000.0 - $97,000.0
Working hours
Regular working hours

Tech stack

Data Analysis Data Visualization Oracle (Applications) Power BI SQL Databases Tableau (Software) Data Analytics Database Tools and Utilities

Job description

Business Intelligence and Data Analytics Consultant II is responsible for leveraging data and analytics to answer moderately complex questions and influence business strategy through communication of findings to management. The position is also responsible for developing standards of practice around data retrieval, data manipulation, data reporting and data analytics., * Influences strategy through data and analytics.

  • Utilizes data and analytics expertise to coach and develop less experienced analysts.
  • Communicates and presents project information to team and provides presentations/updates to management.
  • Establishes, modifies, documents and communicates standards of practice around data retrieval, data manipulation, data quality, data reporting and data analytics.
  • Compiles, cleans, organizes and analyzes moderately complex data to understand business results.
  • Monitors and evaluates business initiatives against key performance indicators and communicates results and recommendations to management.
  • Makes the business insights derived from data analytics accessible to those without technical skills.
  • Provides technical expertise in advanced Power BI dashboard development, including building and enhancing line-of-business reporting for Claims and expanding analytical insights across existing projects.
  • Partners with stakeholders to present findings, articulate reporting products, and translate technical insights into clear business recommendations.

Requirements

  • 2 or more years of experience.
  • 4-year Bachelor’s degree.
  • Prior experience with reporting and visualization tools such as Power BI or Tableau.
  • Power BI technical expertise preferred, including experience building dashboards, enhancing reporting capabilities, and developing analytical insights for business stakeholders.
  • Experience with data languages and database tools such as SQL, DAX, M Code, or Oracle preferred; candidates do not need to have experience with all.
  • Ability to present technical products, reporting outputs, and analytical recommendations to stakeholders in a clear and business-oriented manner.
  • Claims experience is preferred., Business Analysis, Business Case Analyses, Business Intelligence (BI), Business Model Development, Data Analysis, Data Analytics, Data Visualization, Microsoft Power Business Intelligence (BI), Oracle, Reporting, SQL Database Queries

Benefits & conditions

Compensation offered for this role is 60,000.00 - 97,125.00 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. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger - a winning team making a meaningful impact.

Allstate generally does not sponsor individuals for employment-based visas for this position.

Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on allstate.wd5.myworkdayjobs.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:44 min

Replacing complex BI dashboards with live LLM queries

Jordan Tigani Jordan Tigani · WWC Europe 2026

1:14 min

Evolution of distributed SQL database architectures

Wei Hu Wei Hu · WWC 2024

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

2:36 min

Integrating business experts and conceptualizing analytical use cases

Stefan Donsa Stefan Donsa +1 · LIVE

1:36 min

Evolution from key-value stores to distributed SQL

Wei Hu Wei Hu · WWC 2025

Videos

See all

Related articles

See all