Additional Information
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
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. 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
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 days.
Tuition Reimbursement.
Working within the community and giving back.
Job description:
Reporting to the Manager, Analytics and Data Enablement, you will lead Microsoft Fabric-based data modeling initiatives, leveraging the medallion architecture (Bronze, Silver, Gold layers) to efficiently manage and transform data across its lifecycle. You will apply advanced analytics and integration capabilities to design, build, and maintain robust semantic models, automate end-to-end data pipelines, and ensure high-quality, trusted data assets. 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:
Design, build and maintain semantic models (Lakehouses, Warehouses) that integrate data from multiple sources, ensuring consistency, quality, and governance. Extract, transform, and load (ETL) raw data using Fabric Dataflows, Pipelines, or T-SQL
Collaborate closely with Data Engineers, Data Analysts, and Operational Analytics teams to ensure semantic data models are effectively aligned with business requirements and scalable technical capabilities.
Implement and enhance internal data processes by automating manual workflows, optimizing data delivery, and redesigning database structures to improve efficiency and scalability.
Utilize Fabric's integrated tools (SQL, Python, KQL, DAX, Power BI) to explore, analyze, and interpret data, answering "why" and "what next" questions rather than just "what happened".
Build interactive dashboards, summaries, and reports in Power BI to communicate insights to stakeholders.
To convert legacy SAS/SQL processes into Microsoft Fabric data pipelines and curated datasets to enhance scalability, performance, and data delivery efficiency.
Proven expertise in building modern data platforms including data integration, semantic modeling, and scalable pipelines for delivering curated datasets.
Leverage Fabric IQ Data Agents, Copilot, and AI workflows to auto-generate DAX, summaries, and dashboards, and to explore data through natural language
Allstate · Canadian Head Office