Store Operations Data Analyst

Summary

O'Reilly Auto Parts is an automotive parts retailer with a strong focus on operational performance and business growth. The Store Operations Data Analyst analyzes store and team-member performance data, develops and maintains reports and dashboards, troubleshoots reporting environments, and presents insights and recommendations to leadership.

Responsibilities

• 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

• 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
• 2 year or 4 year degree, preferably in Business, CIS, Computer Science, Economics or Mathematics
• 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

Qualifications

Must Haves

• 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

Nice to Haves

• 2 year or 4 year degree, preferably in Business, CIS, Computer Science, Economics or Mathematics
• 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

Benefits

• 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