People Analytics Workday Senior Consultant Job South Naperville Area area,Illinois USA,IT/Tech

People Analytics Workday Senior Consultant

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 People Analytics Workday Senior Consultant is responsible for delivering accurate, actionable, and governed people data solutions across Allstate. This role combines expertise in Workday reporting, SQL-based data analysis, and stakeholder consulting to support HR, Legal, Compliance, Employee Relations, and business partners in making informed decisions through trusted people data. The successful candidate will look beyond the initial request to understand the underlying business challenge, identify root causes, and recommend scalable solutions that deliver meaningful business value.

Working across Workday and enterprise data platforms, they will transform complex requirements into reporting, analytics, and data solutions while considering upstream and downstream impacts across people, process, and technology ecosystems. This role requires strong technical expertise, analytical thinking, systems thinking, and stakeholder management skills to ensure people data is leveraged effectively, responsibly, and in compliance with privacy and governance standards.

Primary Responsibilities

Consult with stakeholders to understand business needs and recommend the most effective reporting or analytics solution.
Design, develop, and maintain scalable Workday reporting solutions and people analytics products.
Write and maintain SQL queries to extract, transform, and analyze HR data from Dremio and other enterprise sources.
Join and reconcile data across multiple systems to support reporting, investigations, and business decision-making
Troubleshoot reporting issues and resolve data discrepancies.
Partner with HR, Legal, Employee Relations, Compliance, and other stakeholders on sensitive reporting and data requests.
Document reporting methodologies, SQL logic, and data definitions to ensure transparency and repeatability.
Collaborate with dashboarding, infrastructure, product, and data engineering teams to deliver connected people data solutions.

Secondary Responsibilities

Challenge assumptions and help stakeholders identify the root business problem.
Apply systems thinking when evaluating reporting requests and recommending solutions.
Ensure accuracy, quality, and consistency of reporting outputs.
Maintain compliance with privacy, governance, security, and audit requirements.
Apply sound judgment when handling sensitive employee information.
Identify opportunities for automation, AI-enabled efficiencies, and self-service reporting.
Promote scalable and sustainable solutions over manual or one-time fixes.
Support continuous improvement of reporting processes, standards, and governance practices.

Required Skills

Demonstrated experience (3+ years) developing and supporting Workday Reporting solutions.
Strong SQL skills and experience working with enterprise data platforms such as Fabric, Dremio, and Scality.
Experience working with HR or…