Business Intelligence Consultant II

As a Business Intelligence Consultant II at Allstate, you will be responsible for leveraging data and analytics to answer complex questions and influence business strategy through communication of findings to stakeholders. Your strong background in SQL, Data Modeling, Report Development, and Data visualization will be crucial in working 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 In this role, you will have the opportunity to contribute to the innovative operations and technology at Allstate India, a critical strategic business services arm of The Allstate Corporation. With offices in Bengaluru and Pune, you will be part of a company that offers expertise in technology and innovation, accounting and imaging services, policy administration, global operations and integration, and more.,