Reporting Automation & Dashboard Senior Consultant II
At a glance
AI generatedTL;DR
The Reports, Automation, & Dashboard Senior Consultant II will join a dynamic team to design and build enterprise financial and operational reporting solutions using Microsoft Fabric and Power BI. This role involves creating scalable data models, governed semantic layers, and automated reporting solutions to ensure accurate insights across the organization. Day-to-day responsibilities include developing high-complexity dashboards, managing end-to-end reporting solutions, translating business requirements into performant designs, and collaborating with cross-functional teams for deployment. Essential skills include 3+ years of BI experience, proficiency in Power BI and data modeling concepts, and familiarity with modern data platforms like Microsoft Fabric or Azure Synapse. The role requires strong analytical thinking, communication skills, and the ability to mentor junior consultants while driving continuous improvement initiatives focused on reporting architecture and performance optimization.
Skills
What you'll do
- Design and build high-complexity Power BI dashboards backed by governed semantic models.
- Develop end-to-end reporting solutions using Microsoft Fabric components for Lakehouse data.
- Independently design financial and operational reporting logic centralizing metrics for reuse.
- Lead cross-functional collaboration to design, build, test, and deploy reports and dashboards.
- Ensure report integrity through data modeling best practices and user acceptance testing.
What we're looking for
- 3+ years of business intelligence or analytics experience
- Expertise in Power BI including report design, DAX, semantic modeling
- Experience with Microsoft Fabric or similar Lakehouse/data warehouse technologies
- Strong data modeling skills for star schemas and reusable metrics
- Support financial/operational reporting in large enterprise environments
- Ability to work independently on multiple projects and manage stakeholders
Employer
About Allstate
The Allstate Corporation is one of the largest publicly held personal lines insurers in the US, widely recognized for its "You're In Good Hands With Allstate®" slogan.
Allstate currently has 29 open roles on FindRole.
Listed pay typically runs $100,000–$170,500 across 29 roles with salary data.
Most-posted roles
- Cloud Product Security Engineer 1
- Data Scientist – Agentic AI (Enterprise Risk Management & AI Governance) 1
- Infrastructure Security Engineer – (Network & Automation) 1
- Infrastructure Solution Engineer 1
- Lead AI Cloud Platform Engineer 1