Workforce Planning Analyst

O'Reilly Auto Parts; United States; On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Wages and Paid Time Off

Stock Purchase Plan

401k with Employer Contributions

Medical, Dental, Vision Insurance

Tuition Assistance

Career Growth

Job summary

O'Reilly Auto Parts is seeking a workforce planning professional to analyze payroll budgets, staffing forecasts and schedules. The role involves configuring and testing changes to the workforce management system and providing cross-department reporting.

Ideal candidates will have strong Excel/Access, SQL skills and Automotive Aftermarket experience, with the ability to analyze data and present actionable recommendations.

Qualifications

• High school diploma or equivalent.
• Bachelor’s degree in Business, Finance, or Accounting.
• 2 years in Automotive Aftermarket with understanding of programming standards, procedures and processes.
• Advanced SQL skills and database knowledge.
• Strong Excel and Access proficiency.
• Analytical mindset with ability to report findings and recommendations.

Responsibilities

• Gather and analyze payroll budgets, staffing forecasts, and work schedules.
• Perform ad-hoc what-if analyses to identify trends and opportunities.
• Analyze critical workforce metrics and vendor updates for forecasting.
• Configure, test and validate changes to the workforce management system.
• Provide reporting to multiple departments and support timekeeping/scheduling.
• Respond to JIRA tickets and issues related to scheduling and timekeeping.

Skills

Excel

Access

SQL

Analytical thinking

Problem solving

Teamwork

Communication

Education

High school diploma or equivalent

Bachelor’s degree in Business, Finance, or Accounting

2 years in Automotive Aftermarket with programming knowledge

Advanced education in Project Management

Tools

SQL

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

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

Attention to detail, self-starter and the ability to learn independently

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

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)

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.

O'Reilly Auto Parts is a leading automotive aftermarket retailer with over 6,100 locations in North America, dedicated to exceptional service and quality products.

233 S Patterson Ave, Springfield, MO 65802, US