Senior Analyst – Microsoft Fabric Implementation

Job description

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 Qualifications: Proficiency in Microsoft Fabric: proven experience in dataset consolidation, dataflow development, and Python notebooks, enabling the design of robust data pipelines, transformation workflows, and scalable analytics solutions. Data Integration & Modeling: Strong expertise in data integration and semantic modeling, with a solid foundation in dimensional modeling, normalization, referential integrity, and star/snowflake schema design to build well-structured, scalable models for efficient BI reporting and analytics. SQL & Python: Proven ability to leverage Python within Microsoft Fabric for scalable data processing, automation, and advanced analytics, alongside strong SQL capabilities to design and optimize high-performance queries across Lakehouse and Warehouse layers, enabling efficient and reliable analytics solutions. Analytical & Problem-Solving Skills: 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 Training and Communication: Strong ability to document data processes and communicate insights clearly, while collaborating with cross-functional teams, conducting knowledge-sharing sessions and preparing training resources for stakeholders to drive effective adoption and usage. Data Governance: Strong understanding of data governance principles, including data quality, lineage, metadata management, and familiar with Informatica IDMC BI Tools: Proven experience with Power BI, specializing in semantic model development within Microsoft Fabric workspaces and advanced DAX for complex calculations and KPIs. Skilled in designing high-performance data models, optimizing query performance, and delivering interactive, scalable dashboards that drive business insights. Bonus Qualifications: Prior experience with insurance/actuarial data will be considered a plus. Microsoft Fabric Certification and demonstrating validated expertise in building data pipelines and analytics is nice to have. Allstate Canada Group has policies and practices that provide workplace accommodations. If you require accommodation, please let us know and we will work with you to meet your needs. #LI-GL1 À propos d’Allstate : Allstate du Canada, compagnie d’assurance est un chef de file dans le domaine des assurances automobile et habitation; elle offre à ses clients des produits et services de prévention et de protection qui conviennent à toutes les étapes de la vie. Au service des Canadiens depuis 1953, l’entreprise met tout en œuvre pour que non seulement ses clients, mais aussi ses employés soient en bonnes mainsMD, comme en fait foi sa présence au palmarès des Employeurs de choix au Canada pendant neuf années de suite. Allstate du Canada tient à contribuer au mieux-être des communautés dans lesquelles elle exerce ses activités au moyen de partenariats avec des organismes caritatifs et de programmes misant sur la générosité de ses employés. Pour en savoir plus, visitez le www.allstate.ca. Pour connaître nos conseils en matière de sécurité, consultez le blogue Allstate Assurance au blogue.allstate.ca. À Allstate, nous avons conscience que la qualité de nos produits découle directement du niveau de satisfaction du personnel à l’égard de l’entreprise. C’est pourquoi nous misons sur le maintien d’une culture où les employés se sentent valorisés et où ils peuvent poursuivre une carrière passionnante. Notre proposition de valeur aux employés permet ainsi de s’épanouir de façon unique. Désignation du rôle : hybride Les avantages offerts par Allstate La flexibilité des modalités de travail;