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 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
• Partner with team members, and business partners, to ensure complete post-implementation validation and user acceptance testing (UAT)
• Lead and/or collaborate with cross-functional teams to set up recurring reports and dashboards, and support end-users throughout the reporting product lifecycle
• Assists in developing analytics “story” and visual presentation strategies to ensure data is conveyed in meaningful and interpretive formats for all audience levels.
• Assists in identifying actionable insights and recommendations to influence the direction of the business by effectively communicating results across functional groups.
• Inspire trust and confidence throughout the organization by leveraging strategic and diplomatic relationship building skills

Education and Technical skills

• 4 year Bachelors Degree (Preferred)
• Advanced knowledge of SQL, Power BI and Excel
• Experience with ETL and developing SSIS packages
• Good verbal and written communication

Functional Skills

• Intermediate to advanced ability to build reports and/or technical tools, using a variety of data reporting and visualization software
• Intermediate to advanced technical knowledge with data management processes (i.e.; data flow within systems, data mapping, meta data, etc.) and/or experience with integrating data from multiple sources, including relational databases, unstructured data, and/or other enterprise data stores

Supervisory Responsibilities

• This job does not have supervisory duties.

Education & Experience (in lieu)

• In lieu of the above education requirements, an equivalent combination of education and experience may be considered.

Primary Skills

Business Analysis, Business Case Analyses, Data Analytics

Shift Time

Recruiter Info

Dipti Murudkar

dsudh@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.