Product Intelligence Senior Consultant
@ Allstate

Hybrid
$120,650
Hybrid
Full Time
Posted 22 days ago

Your Application Journey

Personalized Resume
Apply
Email Hiring Manager
Interview

Email Hiring Manager

XXXXXXXXXX XXXXXXXXXXXXX XXXXXXXX******* @allstate.com
Recommended after applying

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

Apply without a personalized resume

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.

📝 Interview Preparation Advice

Technical Preparation

Review Power BI dashboard techniques.
Practice SQL query optimization.
Familiarize with Microsoft Fabric dataflows.
Study Spark and data transformation methods.

Behavioral Questions

Describe a teamwork challenge overcome.
Explain handling multiple priorities.
Illustrate client collaboration experience.
Detail a time you optimized process efficiency.

Frequently Asked Questions