BI Developer Analyst III/Consultant I

Allstate; Pune District; On-site; INR 1,200,000 - 1,500,000; Full time

Job summary

Allstate in Pune seeks a business analytics and reporting specialist to support the Property Claims analytics stack. You will drive dashboards, data quality, and operational insights for leadership and vendor partners, partnering with tech teams to translate needs into reliable, governed solutions.

The role emphasizes reporting outcomes and data-driven decision support over hands-on engineering, with exposure to API integrations and cloud data platforms as added advantages.

Qualifications

• Proven experience in business reporting, MIS, analytics, or systems support.
• Strong SQL querying skills and ability to validate reports.
• Understanding of data flows, data quality controls, and reporting lifecycle management.
• Ability to collaborate with business and technology teams to deliver outcomes.
• Excellent analytical, problem-solving, and communication skills.
• Experience supporting multiple systems and coordinating issue resolution in fast-paced environments.
• Knowledge of API integration; experience with Big Data & Cloud is a plus.

Responsibilities

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

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

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.