Business Intelligence Consultant Ii

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