Product Engineering (Fabric Data Engineering)

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.

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.

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.

The Product Engineering (Fabric Data Engineering) role combines platform engineering, data engineering, dimensional modeling, Gold-layer delivery, and AI-augmented analytics enablement within Microsoft Fabric. This role is accountable for designing and operating the team’s Fabric workspace, OneLake/Lakehouse architecture, CI/CD release process, Bronze ingestion patterns, Silver/Gold transformation pipelines, Delta table performance strategy, security model, and observability framework. The role also owns the end-to-end data product lifecycle from raw ingestion through trusted dimensional models and Power BI semantic models, ensuring Auto and Property insurance data is accurate, reusable, performant, governed, and ready for business self-service, regulatory reporting, Copilot-assisted analytics, and downstream application/API consumption. Accountabilities: Design /Code and own the Microsoft Fabric workspace, OneLake, Lakehouse, and Warehouse architecture, including Bronze-layer ingestion patterns for policy, claims, billing, and third-party vendor data feeds. Establish and enforce Fabric data build standards, governance practices, reusable engineering patterns, naming conventions, and code-review expectations across the delivery team. Build and maintain Azure DevOps CI/CD pipelines across development, test, and production environments, including approval gates, service principal management, deployment parameterization, and repeatable release processes. Design, build, and optimize Silver-layer cleansing, deduplication, conformance, and reconciliation logic to create trusted, audit-ready datasets for downstream analytics. Design and maintain Gold-layer dimensional models, star schemas, Slowly Changing Dimension Type 2 history tracking, incremental load patterns, and business-ready marts using Kimball and analytics-engineering principles. Implement automated data-quality controls, including row-count validation, measure reconciliation, SCD2 integrity checks, lineage validation, and