Business Intelligence Consultant II

At Allstate, great things happen when our people work together to protect families and their belongings from lifes 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

Bachelors 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 Serviceworkspaces, 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 Jhaajhat@allstate.comAbout 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 corporations 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 organizations 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.