Data Analytics - Consultant II​/Senior Consultant

Position: Data Analytics - Consultant II / Senior Consultant I

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 Data Analytics Consultant II / Senior Consultant I Turn Data into Insights. Turn Insights into Impact. MULTI-LEVEL OPPORTUNITY This position is posted at two levels. Final placement, title and compensation will be based on the selected candidate’s skills, experience, and qualifications. An offer may be made at either Data Analytics Consultant II or Data Analytics Senior Consultant I level.

The Opportunity Join a high-visibility analytics team that helps shape distribution strategy across Allstate. You will use data, reporting, visualization, and storytelling to influence decisions, improve performance, and help leaders solve business challenges. The scope and level of ownership will vary by job level, as outlined below.

About the Distribution Analytics Team

Team partners with sales, strategy, and business leaders to deliver analytics, reporting, and actionable insights that improve agency performance and support profitable growth. We do more than build dashboards. We help the business understand what is happening, why it is happening, and what actions to take next. Key stakeholder groups include Field Sales Organization, Distribution Strategy and Business Architecture, Program and Deployment teams, and Distribution and Agency leadership partners.

Which

Level Best Fits You?

Consultant II:
Best suited for an analytics professional who can independently deliver defined analyses and reporting, partner with stakeholders, and translate data into practical recommendations.

Senior Consultant I:
Best suited for an experienced analytics professional who can lead more complex or ambiguous work, shape analytical direction, and influence business decisions through recommendations and storytelling.

What Success Looks Like

You enjoy digging into data, finding meaningful insights, and building clear visualizations. You balance analytical thinking with strong communication and can turn findings into recommendations that help the business take action. At either level, you will contribute to better decisions and improved business performance, with the Senior Consultant I role carrying broader complexity, ownership, and influence.

Common Core 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.

Level-Specific Scope and Responsibilities Consultant II:

Responsible for leveraging data and analytics to answer complex questions and influence distribution strategy. Responsibilities:
Complete analyses, recurring reporting, dashboard enhancements, and performance measurement assignments. Work with stakeholders to clarify business questions, gather requirements, and…