Business Intelligence Consultant

Business Intelligence Consultant I

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

Job Responsibilities / Accountabilities:

• Develop, automate, and optimize Power BI dashboards, SAS codes, and SQL programs to analyze complex datasets and answer specific business questions.
• Partner with stakeholders to gather requirements, advise on best metrics, and propose data-driven solutions that drive business forward.
• Summarize and present analytical findings, focusing on value-added insights to help partners better manage their business.
• Lead multiple project streams by providing technical direction, designing solutions, and automating quality assurance steps.
• Prioritize business needs with management and comprehensively document processes, requirements, and definitions.
• Optional: Extensive knowledge and use of Microsoft SQL Server and associated services (SSIS, SSRS, and SSAS).

Qualifications & Experience:

• University Degree (Math/Stats/Engineering or similar) preferred.
• 1-2 years of relevant experience (Marketing, Actuarial, or Analytics) with at least 2 years using Base SAS/EG, SQL, and Power BI.
• Strong proficiency in the Microsoft suite (Power Automate, Forms, Excel, PowerPoint) and a sound knowledge of relational database structures.
• Excellent analytical, problem-solving, and communication skills, including experience presenting findings to partners.
• Ability to work both independently and collaboratively to identify new techniques for improving performance and productivity.
• Experience with insurance data is considered a plus.

Primary Skills

Business Analysis, Business Case Analyses, Data Analytics

Shift Time

Recruiter Info

Dipti Murudkardsudh@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. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.

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.

Experience Level

Mid Level