At Allstate, outstanding 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 Description
The Business Intelligence Developer Consultant II contributes to the development, testing, implementation, and maintenance of complex Business Intelligence solutions and reports through the use of the Microsoft SQL Server BI stack and/or other tools. This role supports the aggregation of data from multiple sources into an efficient data warehouse and designing reporting solutions for very large multidimensional databases.

Key Responsibilities
- Contributes to translating complex business needs to technical specifications
- Conducts developer testing and troubleshooting
- Identifies and supports improvements of existing BI systems and processes




- Collaborates with teams to integrate systems
- Escalate open issues and proactively ask questions in an agile manner
- Improves efficiency, reduces costs, and ensures compliance with regulations
- Develops standard reports and functional dashboards based on business requirements
- Partners and collaborates with technical and non-technical stakeholders to identify business problems
- Maintains and supports data analytics platforms
- Data engineering
- SQL Query performance optimization and development
- Data transformation
- Data modeling
- BI and data visualization
- Strong analytical and problem‑solving skills

Strong proficiency in Microsoft Fabric and Microsoft Power BI, with hands‑on experience building Lakehouses, pipeline activities, reports, and dashboards.

Education
• 4 year Bachelors Degree (Preferred)

Experience
• 2 or more years of experience (Preferred)

Supervisory Responsi

📌 BI Developer Consultant II (Bengaluru)
🏢 Allstate
📍 Bengaluru