Store Operations Data Analyst

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

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.