Reporting Automation & Dashboard Senior Consultant II

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 DescriptionThe Reports, Automation, & Dashboard Sr Consultant II will be responsible for the accurate, consistent, and timely reporting of enterprise financial and The Reports, Automation, and Dashboard Senior Consultant II is responsible for designing, building, and modernizing enterprise financial and operational reporting solutions using Microsoft Fabric and Power BI. This role focuses on delivering accurate, consistent, and timely insights by implementing scalable data models, governed semantic layers, and automated reporting solutions that ensure a single, trusted version of the truth across the organization. The consultant partners closely with business stakeholders, data engineering, and analytics teams to translate complex business requirements into performant, reusable, and well-governed reporting assets spanning Lakehouse, semantic models, and Power BI dashboards.Key ResponsibilitiesDesign, build, and maintain high-complexity Power BI dashboards and reports backed by governed semantic models and curated data sourcesDevelop and manage end-to-end reporting solutions using Microsoft Fabric components, including Lakehouse (Bronze/Silver/Gold), notebooks, pipelines, and semantic modelsIndependently design and implement financial and operational reporting logic that centralizes metrics, KPIs, and calculations for enterprise reusePartner with business stakeholders to translate requirements into scalable data and reporting designs that prioritize usability, performance, and governanceLead cross-functional collaboration with data engineeri