Workforce Planning Analyst

O'Reilly Auto Parts; Springfield (MO); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

401k with employer contributions

Medical, Dental, & Vision insurance

Paid time off

Tuition assistance

Career growth opportunities

Job summary

O'Reilly Auto Parts is seeking a Workforce Analytics Analyst to analyze payroll budgets, staffing forecasts, and work schedules to ensure excellent customer service and profitability. The role focuses on data-driven decision making, system configuration, and testing related to the workforce management platform.

The ideal candidate will have strong Excel/Access/SQL skills, a Bachelor’s degree in business or related field, and experience with forecasting.

Qualifications

• Bachelor's degree or higher in business, finance, or accounting.
• Strong Excel/Access and SQL data analysis skills.
• Experience with workforce management or forecasting is preferred.
• Excellent communication and documentation skills.

Responsibilities

• Gather and analyze data from multiple sources to inform payroll budgets, staffing forecasts, and schedules for customer service and profitability.
• Perform ad-hoc what-if analyses to identify trends and opportunities in workforce planning.
• Analyze key metrics imported from systems into the workforce management system and adjust as needed.
• Collaborate with field management on event analysis, planning, exclusions, and forecast adjustments.
• Configure system settings, conduct user acceptance testing, and support adoption by users.
• Work with IT and vendor teams to test changes and ensure proper access, views, and reporting.
• Provide reporting from the WFM system to multiple departments and respond to tickets.

Skills

Data analysis

Excel

Access

SQL

Teamwork

Problem solving

Education

Bachelor's degree in Business, Finance, or related field

Job description

Analyze, evaluate and make recommendations relative to payroll budgets, staffing levels, schedule adherence, work volume and overall workforce management system performance to ensure excellent customer service and operational goals are met. Work with development teams, project managers and other internal and external parties to identify, implement and test configuration related to the workforce management software. Perform periodic application configuration and testing for existing and new stores added to the system. Review, analyze and make recommendations related to implementation of changes by the application vendor during routine software updates/releases. Analyze various workforce management data points for accuracy.

Essential Job Functions

• Gather and analyze data from multiple internal and external sources and make well informed recommendations regarding payroll budgets, staffing forecasts, and work schedules to insure excellent customer service and profitability goals are met.
• Performs complex ad-hoc what-if analysis to identify trends, patterns and opportunities within the scope of workforce planning
• Periodically analyzes key metrics imported from systems of record into the workforce management system (i.e. store operating hours, store type, adjustment drivers, goals, etc.)
• Works with field management on event analysis, planning, exclusions and special circumstances that impact forecasting and scheduling. This will include analyzing and maintaining ongoing adjustments/exceptions in the workforce management system.
• Responsible for setting up system configuration, user acceptance testing and supporting user adoption
• Work with development teams, project managers, and other internal and external teams to implement and test changes to the workforce management system.
• Work with IT teams to insure team member profiles, data views, reports and access levels are configured correctly, including user acceptance testing.
• Provide support for analyzing and responding to JIRA tickets and various reported issues related to the scheduling and timekeeping system.
• Review, analyze and make recommendations related to implementation of changes implemented by the application vendor during routine software updates/releases.
• Provides reporting from the workforce management system to support multiple departments within the company.
• Supports key areas of workforce management, including but not limited to budgeting, forecasting and scheduled hours allocation.
• Provides phone support to stores and other departments regarding budgeting, forecasting and scheduling.
• Works well under challenging working conditions, while meeting deadlines.
• Other duties as assigned.

Skills/Education/Knowledge/Experience/Abilities

Required

• High school diploma or equivalent
• Must possess a high degree of proficiency with Microsoft Excel and Access
• Must work well in a team environment
• Problem solver and critical thinker
• Excellent documentation, communication and organizational skills
• Ability to analyze data, identify trends and patterns, and report on findings with recommendations
• Previous data analytics experience
• Attention to detail, self-starter and the ability to learn independently

Desired

• Bachelor’s degree in Business, Finance, or Accounting
• 2 years in Automotive Aftermarket with general understanding of programming standards, procedures and processes
• Knowledge of database structures, computer flow charts, program logic and code
• Previous experience in workforce management/planning
• Self-motivated to a high level of achievement, excellent written/verbal communicator, analytical and able to make/recommend decisions in the best interest of O'Reilly Auto Parts
• Is committed to any additional training as necessary to stay abreast of technology and apply it as it relates to workforce planning
• Advanced skill set using SQL to perform queries and build comparisons
• Advanced education and demonstrated experience in Project Management

O'Reilly Auto Parts has a proven track record of growth and stability. O'Reilly is full of successful career stories and believes in a strong promote-from-within philosophy, encouraging you to grow your career along with the organization.

Total Compensation Package

• Competitive Wages & Paid Time Off
• Stock Purchase Plan & 401k with Employer Contributions Starting Day One
• Medical, Dental, & Vision Insurance with Optional Flexible Spending Account (FSA)
• Team Member Health/Wellbeing Programs
• Tuition Educational Assistance Programs
• Opportunities for Career Growth

O'Reilly Auto Parts is an equal opportunity employer.

The Company does not discriminate on the basis of race, religion, color, national origin or ancestry (including immigration status or citizenship), sex, sexual orientation, gender identity, pregnancy (including childbirth, lactation, and related medical conditions,) age (40 and over), veteran status, uniformed service member status, physical or mental disability, genetic information (including testing or characteristics) or another protected status as defined by local, state, or federal law, as applicable.

Qualified individuals with a disability may be entitled to reasonable accommodation under the Americans with Disabilities Act.

If you require a reasonable accommodation during the application or employment process, please send an email to: [e-mail] or call [phone] option , and provide your requested accommodation, and position details.