Analyst - Business Intelligence

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 employees and leaders
• Investigate, track, prioritize, and communicate data and reporting related issues.
• Cross-train junior consultants

Preferred Qualifications:

Education and Experience

• Bachelor’s degree or 4 years equivalent experience
• 4 years of hands-on reporting and data engineering
• Experience with data visualization and translating business requirements to technical/data requirements
• Agile/Scrum experience preferred

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
• Intermediate to Advanced SQL Coding/Tableau knowledge Required
• Advanced proficiency in querying, compiling, analyzing, and integrating information from different sources to make data informative (ETL – Extract, Transform and Load/Building SSIS (SQL Server Integration Services) package required
• Comprehensive knowledge of data reporting and business knowledge (financial skills, follow the numbers)
• Demonstrated ability to work with numbers and develop medium to high complexity formula
• Exceptional interpersonal skills to work effectively in a virtual team environment
• Strong oral and written communication skills

Primary Skills

Shift Time

Shift B (India)

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

Experience Level

Entry Level