Operational reporting analyst transforming insurance data for Allstate Canada. Building auditable reporting, analytics and Power BI solutions across policy, claims and billing systems.
Responsibilities
Acquire, investigate, manipulate and analyze data to support Allstate Canada Group’s business plans and results
Interpret source-system user-interface data and understand its translation into backend databases
Build relationships with Claims, Policy and Finance teams to support operational reporting and analytics
Help design requirements for new or enhanced operational reporting data, analytics and reporting solutions
Monitor and ensure data quality using validation, reconciliation and audit-support methods
Test newly integrated data sources and environments
Develop and improve SAS/SQL programs for complex analyses
Assess the impact of source-system changes and projects on reporting data layers and downstream reporting
Collaborate with DBAs, IT teams and Architecture
Automate manual processes, optimize data delivery and redesign/restructure databases
Develop expertise across the data and analytics ecosystem
Identify opportunities to leverage data and analytics for more effective business decisions
Develop Power BI solutions to communicate insights to key stakeholders
Requirements
Demonstrated experience applying analytical techniques to solve business problems and support data-driven decision making
Strong business acumen and ability to communicate insights in technical and non-technical terms
Skilled in data visualization tools, including Power BI
Proactive, curious mindset with ability to learn new data models and evolving environments
Hands-on experience with 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
Strong communication, collaboration and stakeholder management skills
Detail-oriented approach to quality, controls and documentation
Bonus: Proficiency in Microsoft Fabric and Python, including data ingestion, transformation and modeling
Strong English skills required for roles open to candidates across Canada, unless otherwise indicated
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
Data analyst advising Desjardins on complex data collection, analysis, and reporting. Improving data tools and guiding stakeholders’ strategic decisions.
IT Analyst analyzing business needs, requirements, testing, and IT assets for iA Financial Group’s insurance and financial services operations. Supporting compliance, continuity, and technology initiatives across Canada.
Credit risk analyst analyzing portfolio and customer data for EQ Bank, Canada's challenger bank. Supporting fraud prevention, adjudication strategies, reporting, and risk decisions.
Due Diligence Analyst supporting risk, AML, and KYC reviews for Alpaca’s fintech and financial institution partners. Coordinating documentation and onboarding across global third - party integrations.
NOC Analyst II monitoring and troubleshooting networks and systems for VC3, an IT provider serving municipalities and organizations across the United States and Canada. Mentoring junior analysts and maintaining uptime.
IT Analyst maintaining Hydro’s infrastructure, applications, and Active Directory. Supporting business users and global IT projects for a sustainable aluminium and renewable energy company.
Service Desk Analyst providing end - user support and managing office IT equipment. Supporting BeyondTrust’s cybersecurity SaaS operations through incident, asset, vendor, and user management.
Operational Technology Analyst supporting cybersecurity, infrastructure, and process control at Domtar’s Saint - Félicien manufacturing facility. Improving reliability, security, and modernization across OT systems.