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.
The Business Intelligence Consultant II is responsible for leveraging data and analytics to answer complex questions and influence business strategy through communication of findings to Stake holders. The ideal candidate will have a strong background in SQL, Data Modeling, Report Development, and Data visualization. You will work closely with stakeholders to understand business requirements and translate them into interactive reports and analytical solutions.

• Design, develop, and maintain Power BI dashboards and reports that provide actionable insights
• Write efficient, optimized and advanced SQL queries to extract and manipulate data from relational databases (e.g., Oracle, Dremio)
• Develop and maintain data models (star/snowflake schema) and Power BI datasets
• Collaborate with business stakeholders to gather and analyze reporting requirements
• Ensure data accuracy, consistency, and performance of reports and dashboards
• Implement row-level security (RLS) and data refresh schedules in Power BI Service
• Optimize and tune SQL queries and Power BI performance (DAX, visuals)
• Work with data engineers and analysts to streamline ETL processes as needed
• Document solutions, definitions, and business rules used in BI reports
• Stay current with Power BI and SQL advancements, proposing improvements as appropriate
• Monitor and evaluate business initiatives against key performance indicators and communicate results and recommendations to management
• Lead data governance efforts, including standardization of KPIs, data definitions, and documentation
• Provide mentorship and guidance to junior BI analysts, fostering a culture of continuous learning and knowledge sharing
• Identify and recommend opportunities to automate reporting and streamline data operations

Required Skills & Qualifications

• Bachelor's degree in computer science, Information Systems, Engineering, or related field
• 4-6 years of professional experience in BI development using SQL and Power BI
• Expertise in writing complex SQL queries, views, and functions
• Proficient in DAX, Power Query (M language), and Power BI Dataflows
• Strong understanding of data warehousing concepts, data modeling, and ETL pipelines
• Experience with Power BI Service: workspaces, publishing, RLS, and refresh scheduling
• Good understanding of database systems like Oracle, Dremio
• Experience with Microsoft Fabric or equivalent unified data platforms (OneLake, Synapse, Data Factory)
• Ability to work independently and manage multiple projects with minimal supervision
• Excellent communication, written, Interpretation and documentation skills

Primary Skills Analytcial Thinking, Business Intelligence (BI) Solutions, Data Analysis, Data-Driven Decision Making, User Acceptance Testing (UAT)
Shift Time Shift B (India)
Recruiter Info Annapurna Jha
ajhat@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 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 .