Analyst, Regulatory Reporting Enablement

Allstate

Analyst supporting regulatory reporting for Allstate Canada Group while enhancing data quality and analytics. Collaborating with teams across the organization to ensure accurate and compliant reporting requirements.

Posted 4/29/2026full-timeQuebec • 🇨🇦 CanadaMid-LevelSenior💰 CA$67,200 - CA$109,725 per yearWebsite

Tech Stack

Tools & technologies

ETLSQLVBA

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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.

Benefits

Comp & perks

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!

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SASSQLdata visualizationdata modelingETL processesdata governancedata cleansingdata validationdata integrity checksprocess optimization

Soft Skills

analytical skillsproblem-solvingcommunicationcollaborationstakeholder managementattention to detailbusiness acumencuriosityadaptabilitydiscipline