Data Engineer
đź“Ť
Canada
🧪
Entry level
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 Claims Intelligence team within Strategy, Design, and Delivery collaborates primarily with the Claims department, leveraging data and analytics to support strategies and solutions that drive profitable growth. The Claims Intelligence Data 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.
This position reports to the Manager, Claims Intelligence. You will be accountable for supporting the achievement of ACG’s short and long term Mission, Vision, and Strategic Objectives by:
Report Re-Design
Customer Centricity, Digital Literacy, Inclusive Leadership, Learning Agility, Results-Oriented
Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.
You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live.
Good Hands. Greater Together.®
Job Description
The Claims Intelligence team within Strategy, Design, and Delivery collaborates primarily with the Claims department, leveraging data and analytics to support strategies and solutions that drive profitable growth. The Claims Intelligence Data 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.
This position reports to the Manager, Claims Intelligence. You will be accountable for supporting the achievement of ACG’s short and long term Mission, Vision, and Strategic Objectives by:
Report Re-Design
- 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
- Experience in the insurance industry, especially with claims data
- Post-Secondary degree in a quantitative study such as statistics, actuarial science, economics, computer science
- Experience with Tableau Prep, Python, or R
- Experience with SAS
Customer Centricity, Digital Literacy, Inclusive Leadership, Learning Agility, Results-Oriented
Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good.
You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live.
Good Hands. Greater Together.®