BI Developer Consultant II

At Allstate, great things happen when our people work together to protect families and their belongings from life's uncertainties. For over 90 years, our innovative drive has kept us one step ahead of our customers" evolving needs. We have advocated for safety measures like seat belts, airbags, and graduated driving laws. Allstate is an industry leader in pricing sophistication, telematics, and more recently, device and identity protection. The Business Intelligence Developer Consultant II is responsible for contributing to the development, testing, implementation, and maintenance of complex Business Intelligence solutions and reports. This involves utilizing the Microsoft SQL Server BI stack and/or other tools to aggregate data from multiple sources into an efficient data warehouse. Additionally, designing reporting solutions for very large multidimensional databases is a key aspect of this role. Key Responsibilities: - Translate complex business needs into technical specifications - Conduct developer testing and troubleshooting - Identify and support improvements of existing BI systems and processes - Collaborate with teams to integrate systems - Proactively ask questions and escalate open issues in an agile manner - Improve efficiency, reduce costs, and ensure compliance with regulations - Develop standard reports and functional dashboards based on business requirements - Partner with technical and non-technical stakeholders to identify business problems - Maintain and support data analytics platforms Education: - Preferred: 4-year Bachelor's Degree Experience: - Preferred: 2 or more years of relevant experience Supervisory Responsibilities: - This job does not have supervisory duties Education & Experience (in lieu): - An equivalent combination of education and experience may be considered in lieu of the above education requirements Primary Skills: - Data Warehousing (DW), Microsoft Power Business Intelligence (BI), Microsoft Power Business Intelligence (BI) Dataflows, Microsoft Power Business Intelligence (BI) Data Visualization, Microsoft Power Business Intelligence (BI) Desktop, Microsoft Power Business Intelligence (BI) Premium, Microsoft Power Business Intelligence (BI) Security, Microsoft SQL Server Shift Time: - General Shift (India) Recruiter Info: - Diksha Prasad - Email: dprbd@allstate.com About Allstate: 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, The Allstate Corporation owns and operates 18 companies in the United States, Canada, Northern Ireland, and India. Allstate India Private Limited is a subsidiary of The Allstate Corporation and plays a critical role in strategic business services. With offices in Bengaluru and Pune, Allstate India offers expertise in technology, innovation, accounting, imaging services, policy administration, global operations, and more.,