At Allstate, the business problem is to enable clients with trusted, actionable data to break down business problems into solvable components by providing analytical product support for a variety of internal customers and external recipients through the delivery of analytical visualization reports, Ad Hoc requests and data quality efforts.
Requirements
- 3+ years of Power BI development experience (Preferred)
- Strong proficiency in Microsoft Fabric workspace management and dataflows (Preferred)
- Solid experience with Spark (Databricks, Synapse, or Fabric Spark preferred)
- Advanced SQL skills across platforms (including Oracle and T-SQL) (Preferred)
- Proficiency with DAX and Power Query (M) (Preferred)
- Experience working with large datasets and optimizing queries for performance (Preferred)
- Understanding of data lakehouse architecture, medallion models, and delta tables (Preferred)
Responsibilities
- Build intuitive, scalable Power BI dashboards and reports that enable business users to explore and understand new product features and functionalities prior to implementation.
- Connect to diverse data sources (e.g., Oracle/ADW, SQL Server, Microsoft Fabric Lakehouses/Data Warehouses) and perform complex joins, transformations, and data modeling to support analytics needs.
- Partner with internal teams and business stakeholders to gather requirements, define KPIs, and deliver actionable insights tailored to various personas and role levels.
- Deliver clean, validated, and transformed datasets for modeling and analysis, leveraging tools such as SQL, Python, and Microsoft Fabric pipelines.
- Build and maintain self-service and ad hoc reporting solutions that support dynamic segmentation and empower users to make data-driven decisions.
- Troubleshoot data quality issues, identify root causes, and document resolutions while contributing to internal knowledge bases like the PI Wiki.
- Monitor report performance, apply Power BI best practices, and ensure version control and documentation are consistently maintained.
Other
- This is an experienced professional job.
- This job does not have supervisory duties.
- The candidate(s) offered this position will be required to submit to a background investigation.
- Allstate generally does not sponsor individuals for employment-based visas for this position.
- In lieu of the above education requirements, an equivalent combination of education and experience may be considered.
