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 effective 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
Solid 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