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. Job Description The Data Analytics Consultant is responsible for leveraging data and analytics to answer complex questions and influence business strategy through communication of findings to senior management. The ideal candidate will have a strong background in SQL, data modeling, report development, and dashboard visualization. You will work closely with stakeholders to understand business requirements and translate them into interactive reports and analytical solutions. Job Description: The Data Analytics Consultant is responsible for leveraging data and analytics to answer complex questions and influence business strategy through communication of findings to senior management. The ideal candidate will have a strong background in SQL, data modeling, report development, and dashboard 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 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 Required Skills & Qualifications Bachelor’s degree in computer science, Information Systems, Engineering, or related field. 3+ 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. Ability to work independently and manage multiple projects with minimal supervision. Excellent communication, Interpretation and documentation skills. Primary Skills Business Analysis, Business Case Analyses, Data Analytics Shift Time Shift B (India) Recruiter Info Annapurna Jha ajhat@allstate.com About Allstate Joining our team isn’t just a job — it’s an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good. You’ll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we’ve proven that Allstate empowers everyone to lead, drive change and give back where they work and live. Good Hands. Greater Together. 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 here. Show more Show less