BI Developer Consultant II

Allstate India; Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Allstate India is seeking a Business Intelligence Developer Consultant II to design, develop, test, and maintain BI solutions and reports using the Microsoft SQL Server BI stack and related tools. The role focuses on aggregating data from multiple sources into a data warehouse and delivering dashboards that meet business requirements.

The candidate should have 2+ years of BI experience, strong analytical skills, and proficiency in Power BI and Microsoft Fabric.

Qualifications

• 2+ years of experience in BI development or related field.
• Experience with BI solutions and reports using SQL Server BI stack or similar.
• Strong analytical and problem solving skills.

Responsibilities

• Translate complex business needs into technical specifications.
• Develop, test, and maintain BI reports and dashboards.
• Optimize SQL queries and data transformations for performance.
• Collaborate with stakeholders to understand data needs and deliver solutions.
• Maintain data analytics platforms and support data warehousing initiatives.

Skills

SQL

Analytical skills

Problem solving

Communication

Education

Bachelor's degree

Tools

Microsoft Fabric

Power BI

Data warehousing

Job description

At Allstate, great 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 Responsibilities

• This job does not have supervisory duties.

Education & Experience (in lieu)

• In lieu of the above education requirements, an equivalent combination of education and experience may be considered.

About Allstate

Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.

The Allstate Corporation is one of the largest publicly held insurance providers in the United States. Ranked No. 84 in the 2023 Fortune 500 list of the largest United States corporations by total revenue, The Allstate Corporation owns and operates 18 companies in the United States, Canada, Northern Ireland, and India. Allstate India Private Limited, also known as Allstate India, is a subsidiary of The Allstate Corporation. The India talent center was set up in 2012 and operates under the corporation's Good Hands promise. As it innovates operations and technology, Allstate India has evolved beyond its technology functions to be the critical strategic business services arm of the corporation. With offices in Bengaluru and Pune, the company offers expertise to the parent organization’s business areas including technology and innovation, accounting and imaging services, policy administration, transformation solution design and support services, transformation of property liability service design, global operations and integration, and training and transition.

Learn more about Allstate India here.