People Analytics Workday Senior Consultant

Allstate; United States; Remote; USD 70,000 - 121,000; Full time

Job summary

Allstate is seeking a People Analytics Workday Senior Consultant to deliver governed, actionable data solutions across the organization. You will design Workday reports, write SQL against enterprise sources like Dremio, and partner with HR, Legal, and Compliance to meet sensitive data requests.

In this role, you will transform complex requirements into scalable analytics products while ensuring privacy and governance standards.

Qualifications

• 3+ years developing and supporting Workday Reporting solutions.
• Strong SQL skills and experience with enterprise data platforms such as Fabric, Dremio, and Scality.
• Experience working with HR or People data.
• Strong systems thinking, business problem-solving, and root cause analysis capabilities.
• Proven experience gathering business requirements and translating them into scalable reporting solutions.
• Excellent stakeholder management, communication, and influencing skills.
• Ability to manage multiple priorities and deadlines in a fast-paced environment.

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

Skills

Workday reporting

SQL

Data analysis

Stakeholder management

HR data

Power BI

Problem solving

Tools

Dremio

Fabric

Scality

Power BI

Job description

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 People data.
• Strong systems thinking, business problem-solving, and root cause analysis capabilities.
• Proven experience gathering business requirements and translating them into scalable reporting solutions.
• Excellent stakeholder management, communication, and influencing skills.
• Ability to manage multiple priorities and deadlines in a fast-paced environment.

Preferred Skills

• Experience supporting Legal, Compliance, Audit, or Employee Relations reporting requests.
• Knowledge of Workday security concepts and HR data governance principles.
• Experience with Power BI or other business intelligence tools.
• Understanding of HR processes and workforce data.
• Experience working in a consulting, analytics, or HR technology environment.

Compensation

Compensation offered for this role is 70,100.00 - 121,475.00 annually and is based on experience and qualifications.

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. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger – a winning team making a meaningful impact.

Allstate generally does not sponsor individuals for employment-based visas for this position.

Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component.

Allstate provides a comprehensive technology setup, including a laptop, monitors, headset, keyboard, and mouse. Employees eligible to work from home also receive a monthly connectivity reimbursement to help offset internet costs. When working from home, you must have a dedicated, private workspace free from distractions, along with appropriate desk and seating. Reliable internet is required, with minimum speeds of 50 MB download and 5 MB upload.

To help create a more personal and engaging experience, we ask that you join with your camera on if your interview is virtual. Please also have a Valid Photo Identification available at the start of your interview. If you require any accommodations or have questions ahead of your interview please reach out to your recruiter. Note: Internal candidates are only asked to join on video; a Valid Photo Identification is not needed for the interview.

At Allstate, we work hard to help people live a good life every day. Allstaters are dedicated to serving clients, customers, and communities, which allows employees to find meaning and value in their work. Allstate offers an environment that fosters innovative thinking where you’ll be able to explore your ideas and feel proud of the work you do. Allstate helps protect nearly 16 million households with auto, home, life, and retirement products. We want every professional connected to Allstate to be committed to giving our customers the best and that means finding the best talent. We want you to be our next great addition.