Analytics Workday Senior Consultant

Job Description

The People Analytics Workday Senior Consultant is responsible for delivering accurate, actionable, and governed people data solutions across Allstate.

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

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

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

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

This job does not have supervisory duties.

• Analytical Thinking
• Cross-Functional Collaboration
• Data Validation
• Governance Reporting
• HR Governance
• Stakeholder Management
• Structured Query Language (SQL)
• Systems Thinking
• Workday Advanced Reporting
• Workday Reporting
• Workday Reporting and Analytics
• Workday Security Compensation

Expected compensation for this role ranges from $ 77,200. annually. Actual salary offered to successful candidates will vary based on their skills and experience.

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.

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 Canada Group uses AI technology tools to assist in screening, selecting, assessing, and scheduling interviews with candidates as part of the recruitment process. This job posting is for a…