Analyst, Regulatory Reporting Enablement

Allstate • Quebec, QC

2d • Hybrid

About The Position

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, Regulatory Reporting Enablement to join our team! Reporting to the Manager, Regulatory Reporting Enablement, you will be providing key technical expertise to acquire, investigate, manipulate and analyze data to support Allstate Canada Group’s compliant regulatory reporting. 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.

Requirements

• 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 such Power BI and Fabric
• 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 SAS/SQL 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.

Responsibilities

• 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, Finance and External Reporting teams to enable compliant regulatory reporting and analytics needs
• Help design and provide requirements for new or enhanced regulatory reporting data, analytics, and supporting reporting solutions
• Monitor and ensure data quality of curated regulatory 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 analysis and support traceable, auditable reporting results
• Analyze change requests in the source systems or projects, assess their impact to regulatory 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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed