Data Analytics Consultant II: Influence Distribution Strategy

Allstate Insurance; Illinois; On-site; USD 70,000 - 121,000; Full time

Job summary

Allstate Insurance is seeking an Analytics Consultant II or Senior Consultant I to turn data into insights that drive distribution strategy and business outcomes. You will build and refine dashboards, perform analyses, and tell data-driven stories to stakeholders across sales, strategy, and leadership.

Ideal candidates will have hands-on experience with SQL, Power BI, and large datasets, plus strong communication to translate complex findings into practical actions that improve agency

Qualifications

• 1+ years of experience in analytics, reporting, business intelligence, or a related discipline.
• Working knowledge with SQL.
• Experience building dashboards and reports using Power BI or a similar tool.
• Ability to communicate findings clearly to technical and non-technical audiences.
• Ability to organize work, manage priorities, and deliver multiple assignments.

Responsibilities

• Analyze business questions and deliver actionable insights.
• Compile, organize, query, and analyze large datasets from multiple sources.
• Identify trends, risks, opportunities, and performance drivers.
• Build and enhance Power BI dashboards, reports, KPI scorecards, and performance measurement tools.
• Use SQL to query and manipulate data and create analytics-ready datasets.
• Apply data quality and governance best practices.
• Monitor business performance and evaluate key initiatives.
• Partner with stakeholders to identify opportunities and solve business challenges.
• Present findings through clear visualizations, data storytelling, and business-focused recommendations.
• Manage multiple analytics assignments and contribute to continuous improvement and analytics best practices.

Skills

SQL

Power BI

Data Visualization

Data Analytics

Azure SQL

Python

Education

Bachelor's degree in Business, Analytics, Finance, Statistics, or Computer Science

Tools

Microsoft Fabric

Azure

Data Lakehouse

Python

R

Job description

Allstate Insurance is seeking an Analytics Consultant II or Senior Consultant I to turn data into insights that drive distribution strategy and business outcomes. You will build and refine dashboards, perform analyses, and tell data-driven stories to stakeholders across sales, strategy, and leadership.

Ideal candidates will have hands-on experience with SQL, Power BI, and large datasets, plus strong communication to translate complex findings into practical actions that improve agency