Analyst - Operational Reporting Enablement

Allstate Corporation; Canada; On-site; CAD 67,000 - 110,000; Full time

Benefits offered by this job

Flexible Work Arrangements

Employee discounts

Good Office program

Student Loan Matching

Retirement Savings

Wellness allowance

Personal reflection day

Tuition Reimbursement

Community involvement

Job summary

Allstate Canada Group is currently modernizing its data environment with new Policy, Claims and Billing systems and ongoing support for legacy platforms. We are hiring an Analyst - Operational Reporting Enablement to join our team and provide technical expertise to acquire, investigate, manipulate and analyze data to support business plans and results.

The role requires deep understanding of data structure, data quality, and insurance processes, plus experience with SAS/SQL and Power BI to

Qualifications

• Demonstrated experience applying analytical techniques to solve business problems and support data‑driven decision making.
• Strong business acumen with the ability to communicate insights to both technical and non-technical stakeholders.
• Proficient in data visualization using Power BI and comfortable with SQL/SAS data development.
• Hands-on with modern analytics ecosystems (data lakes/warehouses) and ETL concepts.
• Excellent problem-solving and collaboration skills; detail-oriented with quality controls.

Responsibilities

• Interpret data from multiple source systems and translate it to backend data models.
• Collaborate with Claims, Policy and Finance to meet operational reporting needs.
• Design requirements for enhanced reporting data, analytics, and solutions.
• Monitor data quality and perform validation, reconciliation, and audit support.
• Develop and test SAS/SQL programs for complex analyses.
• Analyze change requests and assess impact on data layers and reporting.
• Work with DBAs and other IT teams to implement data improvements.
• Develop expertise across the data and analytics ecosystem to guide decisions.
• Create data visualizations and communicate insights using Power BI.

Skills

Analytical mindset

Business acumen

Communication

Data governance

Stakeholder management

Tools

SAS

SQL

Power BI

Excel

VBA

Python

Job description

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

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. Serving Canadians since 1953, Allstate strives to reassure both customers and employees with its “You’re in Good Hands®” promise and is proud to have been named a Best Employer in Canada for nine consecutive years. Allstate is committed to making a positive difference in the communities in which it operates through partnerships with charitable organizations, employee giving and volunteerism. To learn more, visit www.allstate.ca. For safety tips and advice, visit www.goodhandsadvice.ca. Through our Employee Value Proposition, 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 with a requirement to go into our office based on business need.

• 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

Allstate Canada Group is currently going through an important transformation of its Data environment with the implementation of a new Policy, Claims and Billing systems while continuing to support legacy platforms. We are growing our team and are actively looking to hire an Analyst - Operational Reporting Enablement to join our team! Reporting to the Manager, Operational Reporting Enablement, you will be providing key technical expertise to acquire, investigate, manipulate and analyze data to support Allstate Canada Group’s business plans and results. The candidate will require an in-depth understanding of the data structure and environment and understand the implications from the day-to-day insurance business. This role enables accurate, traceable, and auditable data and analytics to support ongoing, ad‑hoc, and go‑live reporting needs for internal and external stakeholders. The candidate will require an in-depth understanding of the data structure and environment as well as the implications of insurance business processes on regulatory reporting outcomes. The candidate will also foster efficiency, bring forward creative solutions, and create awareness of opportunities to strengthen data quality and enablement across reporting initiatives. A proactive approach, strong collaboration skills, and the ability to think beyond standard approaches are expected.

Accountabilities

• Interpret the data from the user interface of the different source systems and master how it translates into the backend database
• Build strong relationships with Claims, Policy and Finance teams to enable their needs in operational reporting and analytics needs
• Help design and provide requirements for new or enhanced operational reporting data, analytics, and supporting reporting solutions
• Monitor and ensure data quality of curated operational reporting data sets using appropriate validation, reconciliation, and audit‑support methods
• Be heavily involved in testing of newly integrated data sources and/or environments
• Develop and improve SAS/SQL programs to perform various complex analyses
• Analyze change requests in the source systems or projects, assess their impact to operational reporting data layers and downstream reporting
• Collaborate with DBAs, other IT teams, Architecture as required
• Implement internal data process improvement: automating manual processes, optimizing data delivery, redesign/restructure database for more efficiency
• Develop expertise and aim to become a subject matter expert on the entire data and analytics ecosystem
• Develops a solid tactical understating of how the business works, what their operational processes look like, and provides directions as to where data and analytics could be leveraged to make more effective data-driven decisions.
• Understands data visualization and develops solutions using tools such as Power BI in order to effectively communicate and support the translation of data and analytics insights in business terms to key stakeholders.

Qualifications

• Demonstrated experience applying analytical techniques to solve business problems and support data‑driven decision making, with a strong focus on accuracy and reliability
• Strong business acumen and the ability to communicate insights in both technical and non‑technical terms.
• Skilled in data visualization tools - Power BI
• Proactive, curious mindset with the ability to quickly learn and navigate new data models and evolving environments.
• Hands‑on experience with modern analytics ecosystems and methodologies (e.g., data lakes, data warehouses, data marts, ETL processes, data modeling, and data governance).
• Proficiency in SQL/SAS programming for data development, cleansing, validation, integrity checks, reconciliation, and process optimization.
• Skilled in MS Office tools, including Word, PowerPoint, Excel, and VBA.
• Excellent analytical and problem‑solving abilities, with strong communication, collaboration, and stakeholder management skills; detail‑oriented with a disciplined approach to quality, controls, and documentation.

Bonus Qualifications

• Proficiency in Microsoft Fabric and Python programming - understand data ingestion, data transformation, and data modeling

Allstate Canada Group has policies and practices that provide workplace accommodations.

Compensation

Expected compensation for this role ranges from $ 67,200.00 - 109,725.00 annually. Actual salary offered to successful candidates will vary based on their skills and experience.

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. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.

Allstate Canada Group uses AI technology tools to assist in screening, selecting, assessing, and scheduling interviews with candidates as part of the recruitment process. This job posting is for a current open role within the organization.

At Allstate, we work hard to help people live a good life every day. Allstaters are dedicated to serving clients, customers, and communities, which allows employees to find meaning and value in their work. Allstate offers an environment that fosters innovative thinking where you’ll be able to explore your ideas and feel proud of the work you do. Allstate helps protect nearly 16 million households with auto, home, life, and retirement products. We want every professional connected to Allstate to be committed to giving our customers the best and that means finding the best talent. We want you to be our next great addition.

About Us