BI Developer Analyst III/Consultant I

Allstate India Pvt Ltd; Pune District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Allstate India Pvt Ltd is seeking a data analytics professional to enable high-quality reporting, analytics, and operational insights for the Property Claims organization. You'll partner with delivery teams, business reporting, and technology partners to translate needs into reliable, well-governed solutions, focusing on business outcomes and data-driven decision support rather than hands-on engineering.

This role emphasizes accuracy, timeliness, and cross-functional collaboration across

Qualifications

• Strong experience in business reporting, MIS, analytics, or systems support roles.
• Advanced proficiency in SQL-based data querying and report validation.
• Strong understanding of data flows, data quality controls, and reporting lifecycle management.
• Proven ability to work across business and technology teams to deliver outcomes.
• Excellent analytical, problem-solving, and communication skills.
• Comfortable supporting multiple systems and coordinating issue resolution in a fast-paced environment.
• Understanding of API integration, working on reporting with Big Data & Cloud would be an added advantage

Responsibilities

• Serve as a primary business contact for reporting, analytics, and data-enabled operational solutions within Property Claims.
• Support business reporting platforms and data systems used for operational dashboards, management reports, and performance scorecards.
• Coordinate with internal technology teams and external vendors to ensure smooth data flows, system availability, and issue resolution.
• Manage and monitor automated reporting and data refresh processes, ensuring accuracy, timeliness, and consistency.
• Translate business requirements into clear reporting specifications, metrics definitions, and data needs.
• Partner with analytics and modeling teams to enable descriptive, performance, and forward-looking insights.
• Support onboarding of new data sources and vendors by coordinating data access, validation, and reporting readiness.
• Lead root-cause analysis for data quality or reporting issues and drive resolution with stakeholders.
• Maintain documentation for reports, metrics, data sources, and business processes.
• Identify opportunities to improve reporting efficiency, self-service analytics, and management visibility.

Skills

SQL

Power BI

Azure Data Factory

Python

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

This role is a business-facing, non-technical position focused on enabling high-quality reporting, analytics, and operational insights for the Property Claims organization. The role supports business systems, data pipelines, and reporting platforms to ensure accurate, timely, and actionable information for leadership, operations, and vendor partners. The position partners closely with delivery teams, business reporting teams, and external/internal technology partners to translate reporting and operational needs into reliable, well-governed solutions. While the role works closely with technology platforms, the emphasis is on business outcomes, system reliability, and data-driven decision support rather than hands-on engineering.

Key Responsibilities

• Serve as a primary business contact for reporting, analytics, and data-enabled operational solutions within Property Claims.
• Support business reporting platforms and data systems used for operational dashboards, management reports, and performance scorecards.
• Coordinate with internal technology teams and external vendors to ensure smooth data flows, system availability, and issue resolution.
• Manage and monitor automated reporting and data refresh processes, ensuring accuracy, timeliness, and consistency.
• Translate business requirements into clear reporting specifications, metrics definitions, and data needs.
• Partner with analytics and modeling teams to enable descriptive, performance, and forward-looking insights.
• Support onboarding of new data sources and vendors by coordinating data access, validation, and reporting readiness.
• Lead root-cause analysis for data quality or reporting issues and drive resolution with stakeholders.
• Maintain documentation for reports, metrics, data sources, and business processes.
• Identify opportunities to improve reporting efficiency, self-service analytics, and management visibility.

Analytics & MIS Focus Areas

• Operational and management reporting
• KPI tracking and performance scorecards
• Automated MIS delivery and distribution
• Executive and leadership dashboards
• Vendor and partner performance reporting
• Near real-time operational insights

Required Qualifications

• Strong experience in business reporting, MIS, analytics, or systems support roles.
• Advanced proficiency in SQL-based data querying and report validation.
• Strong understanding of data flows, data quality controls, and reporting lifecycle management.
• Proven ability to work across business and technology teams to deliver outcomes.
• Excellent analytical, problem-solving, and communication skills.
• Comfortable supporting multiple systems and coordinating issue resolution in a fast-paced environment.
• Understanding of API integration, working on reporting with Big Data & Cloud would be an added advantage

Preferred Experience

• 3+ years of experience in business analytics, reporting, MIS, or operational analytics roles.
• Experience supporting cloud-based reporting or data platforms.
• Exposure to insurance, claims, financial services, or operational environments.
• Familiarity with vendor data integrations and automated reporting processes
• Understanding of API integration, working on reporting with Big Data & Cloud would be an added advantage

Core Skills

• Business Analytics
• Business Reporting
• MIS
• Data Analysis
• Stakeholder Management
• Operational Reporting
• Dashboarding
• KPI Management
• Vendor Coordination
• System Support

Mandatory Skills

• SQL
• Power BI
• Azure Data Factory & Python (Advanced)

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. Allstaters are dedicated to serving clients, customers, and communities, which allows employees to find meaning and value in their work. Allstate offers an environment that fosters innovative thinking where you’ll be able to explore your ideas and feel proud of the work you do. Allstate helps protect nearly 16 million households with auto, home, life, and retirement products. We want every professional connected to Allstate to be committed to giving our customers the best and that means finding the best talent. We want you to be our next great addition.