Product Intelligence Senior Consultant @ Allstate
Your Application Journey
Email Hiring Manager
Job Details
About Product Intelligence Senior Consultant
At Allstate, great things happen when people collaborate to protect families. For over 90 years, our innovative drive has kept us ahead in evolving customer needs. In this role, you will work as a Power BI Developer - Microsoft Fabric & Data Engineering specialist, collaborating with clients to break down business problems into solvable components and deliver analytical product support.
Key Responsibilities
- Design and develop intuitive, scalable Power BI dashboards and reports.
- Integrate diverse data sources including Oracle, SQL Server, and Microsoft Fabric Lakehouses/Data Warehouses.
- Collaborate with cross-functional teams to define KPIs and deliver actionable insights.
- Support data engineering by delivering clean, validated, and transformed datasets.
- Build self-service analytics and troubleshoot data quality issues.
- Monitor report performance, apply Power BI best practices, and maintain documentation.
- Drive automation by implementing automated data solutions and staying current with emerging technologies.
Experience & Tools
A minimum of 2 years experience with Microsoft Fabric workspace management and dataflows, strong proficiency in handling large datasets, and excellent analytical abilities are required. Additional desired skills include:
- 3+ years of Power BI development experience.
- Solid experience with Spark (Databricks, Synapse, or Fabric Spark preferred).
- Advanced SQL skills across platforms.
- Proficiency with DAX and Power Query (M).
Additional Information
This is an experienced professional role that does not include supervisory duties. Compensation ranges from $66,800 to $120,650 per year, based on experience and qualifications. A background investigation is required. Note: Allstate does not sponsor employment-based visas for this position.
Key skills/competency
Power BI, Microsoft Fabric, Data Engineering, SQL, Python, Spark, DAX, Power Query, Data Visualization, Data Integration
How to Get Hired at Allstate
🎯 Tips for Getting Hired
- Customize your resume: Highlight your Power BI and data engineering projects.
- Research Allstate: Understand their innovative heritage and values.
- Tailor your application: Emphasize experience with Microsoft Fabric and SQL.
- Prepare for technical interviews: Review Power BI dashboards, DAX, and data integration concepts.