Store Operations Data Analyst

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

Benefits offered by this job

Competitive wages

Paid Time Off

Stock Purchase Plan & 401k starting at

Medical, Dental, & Vision Insurance

Tuition/Educational Assistance

Career growth opportunities

Job summary

O’Reilly Auto Parts is seeking a Store Operations Data Analyst to work with field and corporate leadership. You will analyze store and team KPIs, build dashboards, and present insights to support operational decisions.

Responsibilities include creating reports, monitoring data quality, and training end users on new dashboards, with a focus on enabling proactive business decisions.

Qualifications

• Bachelor’s degree preferred in Business, CIS, CS, Economics or Mathematics.
• Strong analytical skills.
• Experience with relational databases, large datasets, and ETL processes.
• Experience transforming data into usable information for non-technical consumers.
• Strong interpersonal, communication, and collaborative skills.
• Able to provide a high level of customer service inside and outside the team.
• Proficient with Excel, Access, and Word.
• Flexible and adaptable to changing business problems.

Responsibilities

• Analyze performance KPIs for stores and teams to identify opportunities.
• Develop and monitor reports, dashboards, and BI visualizations.
• Document requirements for new BI dashboards and reports.
• Work with field leadership and corporate teams to deliver insights.
• Troubleshoot reporting database environments and reports.
• Train end users on new reports and dashboards.
• Use data sources including data warehouse and adhoc CSV/Excel feeds.
• Communicate abnormalities and insights to stakeholders.

Skills

Strong analytical skills

SQL/MySQL

Relational databases/ETL

Excel/Access/Word

Interpersonal communication

Customer service

Adaptability

Collaboration

Education

Bachelor's degree preferred (Business, CIS, CS, Economics or Mathematics)

Tools

PostgreSQL

Access

BI tools

CSV/Excel data feeds

Job description

The Store Operations Data Analyst works with field and corporate leadership to organize and present key business insights using data analysis and visualization tools. The goal of a Store Operations Data Analyst is to understand specific business problems or performance opportunities and deliver meaningful insights from all available data to help our field leadership teams and other key stakeholders make important operational decisions. Perform analyses of performance KPIs of stores and team members, compliance, and other business needs as assigned. Strive to continually improve our reporting systems and analytical capabilities for both corporate and field team members. Present information and recommendations to mid-management and senior level management.

Essential Job Functions

• Make use of all available datasets to accomplish business objectives.
• Initiate and monitor systems, process, and recurring reports in accordance with production schedule (weekly, monthly quarterly etc.), to ensure accuracy and timely execution.
• Document requirements for the creation of new dashboards, visualizations and reports in BI tools.
• Use existing data, processes, and reports to fulfill the needs of field leadership, stores as well as any departments supported by the store operations data analysis team.
• Assist with design and creation of new dashboards and reports as assigned.
• Provide insight into existing operational reports, TN applications, dashboards, and identify opportunities for improvement.
• Communicate with responsible parties when abnormalities are identified.
• Troubleshooting the reporting database environment and reports.
• Learn and use all data sources and software used by Store Operations data analysis team, including BI tools, data warehouse, adhoc data feeds such as CSV or Excel files, Access or Postgres databases to provide insights to the store operations department and other supported departments.
• Training end users on new reports and dashboards.

Skills/Education/Knowledge/Experience/Abilities

Required:

• 2 year or 4 year degree, preferably in Business, CIS, Computer Science, Economics or Mathematics.
• Strong analytical skills.
• Complex query statement construction experience (SQL/MySQL).
• Acute attention to detail prior experience working with relational databases, large datasets, and ETL processes.
• Experience transforming data into usable information for non-technical consumers.
• Strong interpersonal, communication, and collaborative skills.
• Able to provide a high level of customer service inside and outside the team.
• Proficient with Excel, Access, and Word.
• Flexible and adaptable to new direction as business problems change.

Desired

• DOMO or other Bi Tools experience
• Excellent verbal/writing skills.
• Self-motivated Ability to work with limited supervision.
• Collaboration and creativity, Commitment to participate in additional training.
• Experience in Automotive Retail or Service Industries.

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.