Store Operations Data Analyst — Insightful Dashboards & Decisions

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

Benefits offered by this job

Competitive wages

PTO

Stock & 401k

Health insurance

Wellbeing programs

Tuition assistance

Career growth

Job summary

O’Reilly Auto Parts is seeking a Store Operations Data Analyst to partner with field and corporate leadership to organize and present key business insights using data analysis and visualization tools. You will analyze KPIs for stores and team members, compliance, and other business needs to support operational decisions.

You will design and improve reports and dashboards, train end users, and communicate findings to mid- and senior management.

Qualifications

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

Responsibilities

• Make use of all available datasets to accomplish business objectives.
• Initiate and monitor systems, process, and recurring reports in accordance with production schedule 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, 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, ad hoc data feeds, Access or Postgres databases to provide insights.
• Training end users on new reports and dashboards.

Skills

Analytical skills

SQL/MySQL

Relational databases

ETL processes

Excel

Access

Word

Data visualization

Communication

Education

Bachelor’s or Associate degree

Tools

SQL/MySQL

Excel

Access

Word

Data warehouse

Job description

O’Reilly Auto Parts is seeking a Store Operations Data Analyst to partner with field and corporate leadership to organize and present key business insights using data analysis and visualization tools. You will analyze KPIs for stores and team members, compliance, and other business needs to support operational decisions.

You will design and improve reports and dashboards, train end users, and communicate findings to mid- and senior management.