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. 

Turn Data into Insights. Turn Insights into Impact.

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.

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.

• 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.

• 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.

• →

  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

• →

  Complete analyses, recurring reporting, dashboard enhancements, and performance measurement assignments.

• →

  Work with stakeholders to clarify business questions, gather requirements, and translate needs into analytical outputs.

• →

  Apply established analytical methods, data standards, and governance practices.

• →

  Identify meaningful trends and communicate practical recommendations to team members and business partners.

• →

  Present findings to team members, project partners, and business stakeholders.

• →

  Complete complex analyses, recurring reporting, dashboard enhancements, and performance measurement assignments.

• →

  Partner with business leaders and cross-functional stakeholders to frame problems and identify opportunities.

• →

  Connect insights across datasets, initiatives, and performance indicators to explain business drivers.

• →

  Develop recommendations that influence strategy, priorities, and business action.

• →

  Anticipate data quality, governance, and measurement risks and guide practical solutions.

• →

  Contribute analytics best practices and help strengthen the quality and consistency of team deliverables.

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

    • Experience in insurance, sales, distribution, or financial analytics.

    • Experience with Microsoft Fabric, Azure, or data lakehouse environments.

    • Working knowledge of Python, R, or another programming language.

    • Experience influencing business strategy through data-driven insights.

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.

For jobs in San Francisco, please click “here” for information regarding the San Francisco Fair Chance Ordinance.

For jobs in Los Angeles, please click “here” for information regarding the Los Angeles Fair Chance Initiative for Hiring Ordinance.

To view the “EEO Know Your Rights” poster click “here”. This poster provides information concerning the laws and procedures for filing complaints of violations of the laws with the Office of Federal Contract Compliance Programs.

To view the FMLA poster, click “here”. This poster summarizing the major provisions of the Family and Medical Leave Act (FMLA) and telling employees how to file a complaint.

It is the Company’s policy to employ the best qualified individuals available for all jobs. Therefore, any discriminatory action taken on account of an employee’s ancestry, age, color, disability, genetic information, gender, gender identity, gender expression, sexual and reproductive health decision, marital status, medical condition, military or veteran status, national origin, race (include traits historically associated with race, including, but not limited to, hair texture and protective hairstyles), religion (including religious dress), sex, or sexual orientation that adversely affects an employee's terms or conditions of employment is prohibited. This policy applies to all aspects of the employment relationship, including, but not limited to, hiring, training, salary administration, promotion, job assignment, benefits, discipline, and separation of employment.

Allstate provides a comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse. Employees eligible to work from home also receive a monthly connectivity reimbursement to help offset internet costs.

When working from home, you must have a dedicated, private workspace free from distractions, along with appropriate desk and seating. Reliable internet is required, with minimum speeds of 50 MB download and 5 MB upload.

To help create a more personal and engaging experience, we ask that you join with your camera on if your interview is virtual. Please also have a Valid Photo Identification available at the start of your interview.  If you require any accommodations or have questions ahead of your interview please reach out to your recruiter.

Note: Internal candidates are only asked to join on video; a Valid Photo Identification is not needed for the interview.