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 Reports, Automation, & Dashboard Sr Consultant I will be responsible for the accurate, consistent, and timely data engineering of visual Claims reporting and results. The analyst will ensure data integrity by implementing systematic improvements that automate, streamline, and modernize the reporting, data visualization, and business intelligence processes to facilitate the communication of one version of the truth across the enterprise Key Responsibilities Lead the development of data and information delivery solutions in response to business reporting requests and issues. Extract, Transform and Load data pulling from a variety of data tables/sources including but not limited to MSSQL, SQL Server Integration Services (SSIS), stored procedures, Oracle, Dremio, Python and C# Independently design SSIS (SQL Server Integration Services) package to build medium to high complexity Claims reports Partner with team members, and business partners, to ensure complete post-implementation validation and user acceptance testing Lead and/or collaborate with cross-functional teams to set up recurring reports and dashboards, and support end-users throughout the reporting product lifecycle Inspire trust and confidence throughout the organization by leveraging strategic and diplomatic relationship building skills Maintain adherence to Information Security Standards for . 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 corporations 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 .