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

The Distribution Insights & Analytics team within Strategy, Design, and Delivery collaborates primarily with the distribution channels, leveraging data and analytics to support strategies and solutions that drive profitable growth. The Distribution Insights Analyst's role is to quickly understand our stakeholder's data and requirements, leveraging strong analytics skills to transform available data into actionable insights.

• Replace existing stakeholder reports with automated, interactive dashboards enabling powerful data exploration and proactive self-serve analytics

• Innovate and influence the design of new dashboards with a focus on simplicity and usability

• Optimize the data pipeline by improving existing scripts / data update processes

• Provision execution of reporting into data visualization tools by gathering requirements, performing data validation, UAT testing and communicating rollout of new dashboards

• Build on and improve our existing script and report documentation

• Consolidate analytical and data requirements on project initiatives

• Consult and provide input on current data libraries and reports to help foster the implementation/creation of new initiatives

• Determine the best way to collect and aggregate data to build a easily-maintainable data model / report to support the monitoring of stakeholder initiatives and support its success
• Provide analytical assistance to business partners in enhancing operational excellence and supporting sustainable profitable growth of the business with proactive analytics

• Respond to ad-hoc insights requests from our stakeholders by pulling the right data, presenting it in a simple and usable way to answer their questions and help them make decisions

• Simplify data and insights through best practices in data-storytelling and data visualization

• Education or equivalent working experience: Post-Secondary Education, Year of Study 2nd year and above

• GPA: 3.0/4.0 and above (or equivalent)

• Exceptional analytical and critical thinking skills

• Must be able to analyze complex data with high accuracy, be open minded towards change, anticipate client needs and work with others to identify and resolve issues

• Must be able to coordinate various priorities under time pressure and ensure alignment to corporate objectives and stakeholder priorities

• Strong communication (written and verbal), collaboration and relationship-building skills

• Demonstrates strong experience in using data to tell a story influencing business decisions and driving stakeholders to action

• Demonstrates competency and proficiency in data extraction and transformation, developing optimized data models for data visualization

• Experience using Power BI and/or Tableau

• Experience with SQL

• Extensive experience with Microsoft Suite with an emphasis on Excel and O365

• Post-Secondary degree in a quantitative study such as statistics, actuarial science, economics, computer science