Data Analytics Consultant II - Turn Insights into Impact

Allstate; United States; Remote; USD 70,000 - 121,000; Full time

Job summary

Allstate is seeking a Data Analytics Consultant II / Senior Consultant I to transform data into actionable insights and influence distribution strategy. The role spans defined analyses, dashboard development, and stakeholder collaboration to improve agency performance and drive growth.

Candidates should bring 1+ years (II) or 3+ years (Senior) of analytics experience, strong SQL, and Power BI expertise. This high-visibility team emphasizes storytelling and measurable impact across business units.

Qualifications

• 1+ years of experience in analytics, reporting, BI, or 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.
• Present findings through clear visualizations, data storytelling, and business-focused recommendations.

Skills

SQL

Power BI

Data visualization

Data storytelling

Stakeholder communication

Education

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

Tools

Microsoft Fabric

Azure

Data lakehouse

Python

R

Job description

Allstate is seeking a Data Analytics Consultant II / Senior Consultant I to transform data into actionable insights and influence distribution strategy. The role spans defined analyses, dashboard development, and stakeholder collaboration to improve agency performance and drive growth.

Candidates should bring 1+ years (II) or 3+ years (Senior) of analytics experience, strong SQL, and Power BI expertise. This high-visibility team emphasizes storytelling and measurable impact across business units.