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
Business Analytics Consultants (BACs) use a mix of business consulting, technical, and solution implementation skills to help Allstate maximize (and accelerate) the business value of data & analytics. BACs work alongside data, analytics, business, and technology stakeholders as integrators and translators to effectively, efficiently, and consistently implement work across the company. The BAC Consultant II position is a consultant position that will use business and technical acumen to aid in the development of analytical processes and solutions for the business vertical in which they are aligned to. The Consultant is responsible for clear communication among stakeholders and ensuring the project(s)/product(s) are fulfilling all agreed upon criteria when delivered. The consultant will identify potential business problems that can be solved with data and analytics-based solutions and looks for recommendations. Additionally, the BAC Consultant will be exposed to the ins and outs of developing data strategies for predictive analytic applications, fundamental skills of big data, data science and statistical learning methods, and agile delivery methodologies.
Who is Allstate:
Allstate Insurance Company of Canada is a leading home and auto insurer focused on providing its customers prevention and protection products and services for every stage of life. The company is proud to have been named a Best Employer in Canada for nine consecutive years and prioritizes supporting employees and fostering an inclusive, welcoming corporate culture. Allstate is committed to making a positive difference in the communities in which it operates through partnerships with charitable organizations, employee giving and volunteerism. Serving Canadians since 1953, Allstate strives to provide reassurance with its “You’re in Good Hands®” promise.
Through our Employee Value Proposition, Opportunity, Flexibility, Community, Diversity and Family, we have worked hard to develop and nurture a culture where employees feel valued, experience personal growth, have career options and truly enjoy the work they do.
Role Designation: Hybrid 1-2 Days in Office
Benefits to joining Allstate
Flexible Work Arrangements
Employee discounts (15% on auto and property insurance, plus many other products and services)
Good Office program (receive up to 400$ back after purchasing office equipment)
Student Loan Payment Matching Program for Government Student loans
Comprehensive Retirement Savings Program with employer matched contributions
Annual Wellness allowance to support employees with improving health and wellbeing
Personal reflection day
Tuition Reimbursement
Working within the community and giving back!
Job Description:
Our team is growing and we are actively looking to hire Senior Analyst, Data Engineering to join our team! Reporting to the Manager, Data Engineering, you will be providing key technical expertise to acquire, investigate, manipulate, and analyze data and report to support Allstate Canada Group’s business plans and results.
Accountabilities:
Develop and maintain regular actuarial data base for use by other functions of ACG
Implement String matching algorithms in Python to maintain customer data.
Implement internal data process improvement: automating manual processes, optimizing data delivery, redesign/restructure database for more efficiency
Support data preprocessing and feature engineering for data science and modeling projects
Develop and maintain databases and build necessary data pipelines for projects and department functions.
Identify various manual processes and queries in the Data and BI areas, design and develop ETL Jobs to automate them.
Design and implement Data Integration and ETL processes with SSIS packages to make data available for reporting/analytics purpose
Responsible for monitoring and ensuring data quality of the curated data sets using proper reconciliation methods
Design integrated data pipelines to extract large volume of data from diverse data sources and deliver curated common data layers
Develop and improve SAS/SQL programs to perform various analysis.
Analyze change requests in the source systems or projects, assess their impact on existing data layers, and suggest and carry out the appropriate changes
Collaborate with DBAs, other IT teams, Architecture teams and vendor teams as required
Collaborate with stakeholders to identify needs and opportunities to build reports and dashboards
Design and build advanced data platform that supports 360-degree view of the customer and enable customer journey analysis
Qualifications:
Bachelor’s degree (Computer Science/Engineering/Math/Stats/Finance or similar) preferred
3-5 years of experience using Base SAS/EG, SAS Macro, SQL, SSIS & MS SQL Server
2-3 years of experience with data wrangling with Python specifically String-matching algorithms such as Fuzzy matching, hash functions and regular expressions.
Prior experience in the planning and execution of large-scale critical data transformation and enterprise data hub initiatives.
Strong data modeling fundamentals including experience with dimensional modeling, normalization, referential integrity, star, and snowflake schemas, etc.
Experience building and maintaining conceptual, logical, and physical data models for reporting and analytics use cases.
Experience with analytics platforms and methodologies (data lake, data warehouse, data marts, ETL, data modelling, data governance, etc.)
Experience in SAS/SQL programming for developing data, cleansing, performing data validation, required data integrity checks, auditing data and improve efficiency of programs
Experience in building ETL/ELT mappings, SSIS packages, data pipelines and Workflows
Strong knowledge of Enterprise automation software packages for data orchestration
Good understanding of SAS administration, maintenance, configuration, performance tuning and support
Experience in troubleshooting performance issues and errors while handling high volume of source data.
Ability to articulate ideas in both technical and business friendly language
Proficient in MS Word, Excel, Access, VBA, and PowerPoint
Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
Strong knowledge of Tableau and/or other visual analytics tools is preferred
Experience with insurance/actuarial data will be considered a plus
Allstate Canada Group has policies and practices that provide workplace accommodations. If you require accommodation please let us know and we will work with you to meet your needs.
Skills
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.®
Providing protection to help people achieve their hopes and dreams has always been Allstate’s purpose. It’s the why behind everything we do.
Our purpose points us to our destination, but Our Behaviors help us get there.
Collaborate:
Being united helps us reach collective goals and brings out the best in each of us individually. It gives us more opportunities to learn, grow and add value to what we do each day.
Challenge Ideas:
In a world where change is certain, we want to lead it positively. So we rely on the collective expertise of our employees to consider different options and create the best path forward toward progress — in our industry and beyond.
Provide Clarity:
When expectations are clear, goals are easier to meet. We’re working together in new ways to make sure we know where we’re going and the role we all play in getting there. To save time and focus on what matters most: helping people achieve their hopes and dreams.
Provide Feedback:
Every bold idea deserves the chance to grow to excellence. Candid, helpful feedback empowers us to keep making things better for our customers, our communities and fellow employees.
What We Do:
As an expert on our products and services, you can give customers personalized attention and innovative solutions to make their lives easier.
How We Support You:
Starting day one, you’ll have access to resources and incentives to keep you feeling challenged and excited about your careers.
Make An Impact:
As a member of our sales team, you’ll bring a sense of ease and support to customers looking for a better understanding of their protection options. Whether in the field or talking to customers over the phone, you’ll continue to build trust in who we are and what we do.
You’re in Good Hands ® is more than a promise we make to our customers. It’s a promise we make our employees, too.
As part of our team, we want you to love where you work, and that starts by giving you the freedom to be yourself. Our workplace flexibility and focus on inclusion creates an environment where you can connect and belong. Our goal is for you to feel trusted, heard and empowered to express yourself. When you thrive, we all thrive. And this year, we’re proud to share that we’ve been recognized by Forbes as one of America’s Best Employers For Diversity, and one of America’s Best Large Employers.
When you join us, you’ll have the opportunity to push your skills to the next level each day. Our dedication to continuous learning ensures that you have access to development programs designed to propel your career forward. As you learn and grow, so do we.
Working here also means getting the chance to do meaningful work and make a real impact in your community. We have been driving change for over 90 years, but the mark we leave on the world, can be even greater when we work together.
Good Hands. Greater Together.
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
Business Analytics Consultants (BACs) use a mix of business consulting, technical, and solution implementation skills to help Allstate maximize (and accelerate) the business value of data & analytics. BACs work alongside data, analytics, business, and technology stakeholders as integrators and translators to effectively, efficiently, and consistently implement work across the company. The BAC Consultant II position is a consultant position that will use business and technical acumen to aid in the development of analytical processes and solutions for the business vertical in which they are aligned to. The Consultant is responsible for clear communication among stakeholders and ensuring the project(s)/product(s) are fulfilling all agreed upon criteria when delivered. The consultant will identify potential business problems that can be solved with data and analytics-based solutions and looks for recommendations. Additionally, the BAC Consultant will be exposed to the ins and outs of developing data strategies for predictive analytic applications, fundamental skills of big data, data science and statistical learning methods, and agile delivery methodologies.
Who is Allstate:
Allstate Insurance Company of Canada is a leading home and auto insurer focused on providing its customers prevention and protection products and services for every stage of life. The company is proud to have been named a Best Employer in Canada for nine consecutive years and prioritizes supporting employees and fostering an inclusive, welcoming corporate culture. Allstate is committed to making a positive difference in the communities in which it operates through partnerships with charitable organizations, employee giving and volunteerism. Serving Canadians since 1953, Allstate strives to provide reassurance with its “You’re in Good Hands®” promise.
Through our Employee Value Proposition, Opportunity, Flexibility, Community, Diversity and Family, we have worked hard to develop and nurture a culture where employees feel valued, experience personal growth, have career options and truly enjoy the work they do.
Role Designation: Hybrid 1-2 Days in Office
Benefits to joining Allstate
Flexible Work Arrangements
Employee discounts (15% on auto and property insurance, plus many other products and services)
Good Office program (receive up to 400$ back after purchasing office equipment)
Student Loan Payment Matching Program for Government Student loans
Comprehensive Retirement Savings Program with employer matched contributions
Annual Wellness allowance to support employees with improving health and wellbeing
Personal reflection day
Tuition Reimbursement
Working within the community and giving back!
Job Description:
Our team is growing and we are actively looking to hire Senior Analyst, Data Engineering to join our team! Reporting to the Manager, Data Engineering, you will be providing key technical expertise to acquire, investigate, manipulate, and analyze data and report to support Allstate Canada Group’s business plans and results.
Accountabilities:
Develop and maintain regular actuarial data base for use by other functions of ACG
Implement String matching algorithms in Python to maintain customer data.
Implement internal data process improvement: automating manual processes, optimizing data delivery, redesign/restructure database for more efficiency
Support data preprocessing and feature engineering for data science and modeling projects
Develop and maintain databases and build necessary data pipelines for projects and department functions.
Identify various manual processes and queries in the Data and BI areas, design and develop ETL Jobs to automate them.
Design and implement Data Integration and ETL processes with SSIS packages to make data available for reporting/analytics purpose
Responsible for monitoring and ensuring data quality of the curated data sets using proper reconciliation methods
Design integrated data pipelines to extract large volume of data from diverse data sources and deliver curated common data layers
Develop and improve SAS/SQL programs to perform various analysis.
Analyze change requests in the source systems or projects, assess their impact on existing data layers, and suggest and carry out the appropriate changes
Collaborate with DBAs, other IT teams, Architecture teams and vendor teams as required
Collaborate with stakeholders to identify needs and opportunities to build reports and dashboards
Design and build advanced data platform that supports 360-degree view of the customer and enable customer journey analysis
Qualifications:
Bachelor’s degree (Computer Science/Engineering/Math/Stats/Finance or similar) preferred
3-5 years of experience using Base SAS/EG, SAS Macro, SQL, SSIS & MS SQL Server
2-3 years of experience with data wrangling with Python specifically String-matching algorithms such as Fuzzy matching, hash functions and regular expressions.
Prior experience in the planning and execution of large-scale critical data transformation and enterprise data hub initiatives.
Strong data modeling fundamentals including experience with dimensional modeling, normalization, referential integrity, star, and snowflake schemas, etc.
Experience building and maintaining conceptual, logical, and physical data models for reporting and analytics use cases.
Experience with analytics platforms and methodologies (data lake, data warehouse, data marts, ETL, data modelling, data governance, etc.)
Experience in SAS/SQL programming for developing data, cleansing, performing data validation, required data integrity checks, auditing data and improve efficiency of programs
Experience in building ETL/ELT mappings, SSIS packages, data pipelines and Workflows
Strong knowledge of Enterprise automation software packages for data orchestration
Good understanding of SAS administration, maintenance, configuration, performance tuning and support
Experience in troubleshooting performance issues and errors while handling high volume of source data.
Ability to articulate ideas in both technical and business friendly language
Proficient in MS Word, Excel, Access, VBA, and PowerPoint
Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
Strong knowledge of Tableau and/or other visual analytics tools is preferred
Experience with insurance/actuarial data will be considered a plus
Allstate Canada Group has policies and practices that provide workplace accommodations. If you require accommodation please let us know and we will work with you to meet your needs.
Skills
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.®
Providing protection to help people achieve their hopes and dreams has always been Allstate’s purpose. It’s the why behind everything we do.
Our purpose points us to our destination, but Our Behaviors help us get there.
Collaborate:
Being united helps us reach collective goals and brings out the best in each of us individually. It gives us more opportunities to learn, grow and add value to what we do each day.
Challenge Ideas:
In a world where change is certain, we want to lead it positively. So we rely on the collective expertise of our employees to consider different options and create the best path forward toward progress — in our industry and beyond.
Provide Clarity:
When expectations are clear, goals are easier to meet. We’re working together in new ways to make sure we know where we’re going and the role we all play in getting there. To save time and focus on what matters most: helping people achieve their hopes and dreams.
Provide Feedback:
Every bold idea deserves the chance to grow to excellence. Candid, helpful feedback empowers us to keep making things better for our customers, our communities and fellow employees.
What We Do:
Your ability to quickly and calmly make smart decisions can make a huge difference in how confident customers feel throughout the claims process. And as you support our customers, we’re there to support you.
How We Support You:
We empower your success starting day one. You’ll have access to everything you need to grow professionally while helping our customers get their lives back on track.
Make An Impact:
Helping customers with their claims is about learning their stories, not just processing their paperwork. You can take pride in the fact that you’re providing invaluable guidance and helping to build continued trust in our company.
You’re in Good Hands ® is more than a promise we make to our customers. It’s a promise we make our employees, too.
As part of our team, we want you to love where you work, and that starts by giving you the freedom to be yourself. Our workplace flexibility and focus on inclusion creates an environment where you can connect and belong. Our goal is for you to feel trusted, heard and empowered to express yourself. When you thrive, we all thrive. And this year, we’re proud to share that we’ve been recognized by Forbes as one of America’s Best Employers For Diversity, and one of America’s Best Large Employers.
When you join us, you’ll have the opportunity to push your skills to the next level each day. Our dedication to continuous learning ensures that you have access to development programs designed to propel your career forward. As you learn and grow, so do we.
Working here also means getting the chance to do meaningful work and make a real impact in your community. We have been driving change for over 90 years, but the mark we leave on the world, can be even greater when we work together.
Good Hands. Greater Together.
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
Business Analytics Consultants (BACs) use a mix of business consulting, technical, and solution implementation skills to help Allstate maximize (and accelerate) the business value of data & analytics. BACs work alongside data, analytics, business, and technology stakeholders as integrators and translators to effectively, efficiently, and consistently implement work across the company. The BAC Consultant II position is a consultant position that will use business and technical acumen to aid in the development of analytical processes and solutions for the business vertical in which they are aligned to. The Consultant is responsible for clear communication among stakeholders and ensuring the project(s)/product(s) are fulfilling all agreed upon criteria when delivered. The consultant will identify potential business problems that can be solved with data and analytics-based solutions and looks for recommendations. Additionally, the BAC Consultant will be exposed to the ins and outs of developing data strategies for predictive analytic applications, fundamental skills of big data, data science and statistical learning methods, and agile delivery methodologies.
Who is Allstate:
Allstate Insurance Company of Canada is a leading home and auto insurer focused on providing its customers prevention and protection products and services for every stage of life. The company is proud to have been named a Best Employer in Canada for nine consecutive years and prioritizes supporting employees and fostering an inclusive, welcoming corporate culture. Allstate is committed to making a positive difference in the communities in which it operates through partnerships with charitable organizations, employee giving and volunteerism. Serving Canadians since 1953, Allstate strives to provide reassurance with its “You’re in Good Hands®” promise.
Through our Employee Value Proposition, Opportunity, Flexibility, Community, Diversity and Family, we have worked hard to develop and nurture a culture where employees feel valued, experience personal growth, have career options and truly enjoy the work they do.
Role Designation: Hybrid 1-2 Days in Office
Benefits to joining Allstate
Flexible Work Arrangements
Employee discounts (15% on auto and property insurance, plus many other products and services)
Good Office program (receive up to 400$ back after purchasing office equipment)
Student Loan Payment Matching Program for Government Student loans
Comprehensive Retirement Savings Program with employer matched contributions
Annual Wellness allowance to support employees with improving health and wellbeing
Personal reflection day
Tuition Reimbursement
Working within the community and giving back!
Job Description:
Our team is growing and we are actively looking to hire Senior Analyst, Data Engineering to join our team! Reporting to the Manager, Data Engineering, you will be providing key technical expertise to acquire, investigate, manipulate, and analyze data and report to support Allstate Canada Group’s business plans and results.
Accountabilities:
Develop and maintain regular actuarial data base for use by other functions of ACG
Implement String matching algorithms in Python to maintain customer data.
Implement internal data process improvement: automating manual processes, optimizing data delivery, redesign/restructure database for more efficiency
Support data preprocessing and feature engineering for data science and modeling projects
Develop and maintain databases and build necessary data pipelines for projects and department functions.
Identify various manual processes and queries in the Data and BI areas, design and develop ETL Jobs to automate them.
Design and implement Data Integration and ETL processes with SSIS packages to make data available for reporting/analytics purpose
Responsible for monitoring and ensuring data quality of the curated data sets using proper reconciliation methods
Design integrated data pipelines to extract large volume of data from diverse data sources and deliver curated common data layers
Develop and improve SAS/SQL programs to perform various analysis.
Analyze change requests in the source systems or projects, assess their impact on existing data layers, and suggest and carry out the appropriate changes
Collaborate with DBAs, other IT teams, Architecture teams and vendor teams as required
Collaborate with stakeholders to identify needs and opportunities to build reports and dashboards
Design and build advanced data platform that supports 360-degree view of the customer and enable customer journey analysis
Qualifications:
Bachelor’s degree (Computer Science/Engineering/Math/Stats/Finance or similar) preferred
3-5 years of experience using Base SAS/EG, SAS Macro, SQL, SSIS & MS SQL Server
2-3 years of experience with data wrangling with Python specifically String-matching algorithms such as Fuzzy matching, hash functions and regular expressions.
Prior experience in the planning and execution of large-scale critical data transformation and enterprise data hub initiatives.
Strong data modeling fundamentals including experience with dimensional modeling, normalization, referential integrity, star, and snowflake schemas, etc.
Experience building and maintaining conceptual, logical, and physical data models for reporting and analytics use cases.
Experience with analytics platforms and methodologies (data lake, data warehouse, data marts, ETL, data modelling, data governance, etc.)
Experience in SAS/SQL programming for developing data, cleansing, performing data validation, required data integrity checks, auditing data and improve efficiency of programs
Experience in building ETL/ELT mappings, SSIS packages, data pipelines and Workflows
Strong knowledge of Enterprise automation software packages for data orchestration
Good understanding of SAS administration, maintenance, configuration, performance tuning and support
Experience in troubleshooting performance issues and errors while handling high volume of source data.
Ability to articulate ideas in both technical and business friendly language
Proficient in MS Word, Excel, Access, VBA, and PowerPoint
Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
Strong knowledge of Tableau and/or other visual analytics tools is preferred
Experience with insurance/actuarial data will be considered a plus
Allstate Canada Group has policies and practices that provide workplace accommodations. If you require accommodation please let us know and we will work with you to meet your needs.
Skills
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.®
Providing protection to help people achieve their hopes and dreams has always been Allstate’s purpose. It’s the why behind everything we do.
Our purpose points us to our destination, but Our Behaviors help us get there.
Collaborate:
Being united helps us reach collective goals and brings out the best in each of us individually. It gives us more opportunities to learn, grow and add value to what we do each day.
Challenge Ideas:
In a world where change is certain, we want to lead it positively. So we rely on the collective expertise of our employees to consider different options and create the best path forward toward progress — in our industry and beyond.
Provide Clarity:
When expectations are clear, goals are easier to meet. We’re working together in new ways to make sure we know where we’re going and the role we all play in getting there. To save time and focus on what matters most: helping people achieve their hopes and dreams.
Provide Feedback:
Every bold idea deserves the chance to grow to excellence. Candid, helpful feedback empowers us to keep making things better for our customers, our communities and fellow employees.
You’re in Good Hands ® is more than a promise we make to our customers. It’s a promise we make our employees, too.
As part of our team, we want you to love where you work, and that starts by giving you the freedom to be yourself. Our workplace flexibility and focus on inclusion creates an environment where you can connect and belong. Our goal is for you to feel trusted, heard and empowered to express yourself. When you thrive, we all thrive. And this year, we’re proud to share that we’ve been recognized by Forbes as one of America’s Best Employers For Diversity, and one of America’s Best Large Employers.
When you join us, you’ll have the opportunity to push your skills to the next level each day. Our dedication to continuous learning ensures that you have access to development programs designed to propel your career forward. As you learn and grow, so do we.
Working here also means getting the chance to do meaningful work and make a real impact in your community. We have been driving change for over 90 years, but the mark we leave on the world, can be even greater when we work together.
Good Hands. Greater Together.
Benefits
Experience the benefits that make Allstate a great place to work.
*Benefits vary based on position.
- Medical, dental and vision coverage
- HSAs and FSAs
- Wellbeing programs
- Free therapy sessions
- 401(k) plan
- Pension plan
- Free financial counseling
- Paid time off
- Work flexibility
- Talent shares
- Tuition reimbursement
- Learning opportunities
For a full description of Allstate’s benefits, visit allstate.jobs/benefits/
Start making a difference
Realize your full potential by doing
work that matters.
Grow your career in meaningful ways.
We want to make sure you have every opportunity to grow, explore new horizons and follow your passion in a meaningful career. It’s an exciting time to join Allstate. Help us shape the future.
Similar opportunities
![Echo](https://cdn-static.findly.com/wp-content/uploads/sites/3135/2024/05/15123552/Echo.png)
Let’s stay in touch
If you are interested in being notified of future opportunities at The Allstate Corporation, please click the link below to join our careers community.