O'Reilly Auto Parts

Business Intelligence Engineer

O'Reilly Auto Parts published 10 months ago


Mid-Level, Senior, Full-time

No office location

About this job

Job type: Full-time
Experience level: Mid-Level, Senior
Role: System Administrator
Industry: Automotive
Company size: 10k+ people
Company type: Public


Job description

The BI Engineer oversees the full life cycle development, implementation, production support, and performance tuning of the

Business Intelligence Reporting environments, and support the integration with other applications. They design and implement reporting and analytical solutions, including both the design of tables and the processes used to populate those tables with data from internal and external sources. The data they provide helps business teams drive improvement in key business metrics, customer experience, and business results. BI Engineers produce Technical Design Specifications that direct ETL developers on requirements for the ETL processes.

Members of this role understand how data is turned into information and knowledge and how the knowledge supports and enables key business processes. They must have an in-depth understanding of the business environment, and strong analytical and communication skills. Individuals must work well within a team environment.


  • Design BI application technical solution based on business requirement and design
  • Executing deliverables as assigned including but not limited to:

·        Performance Tuning

·        Data Modeling

·        Data Transformation Specifications

·        Application Object Creation

·        Schema Object Creation

·        BI Tool Administrative Tasks

·        Designing, Developing, Testing, and Deploying Dashboards and Report Solutions

·        Organizes information by developing data dictionary and metadata structures, recommends changes in databases and data warehouse schemas, translates user requirements into data structure and elements, prepares prototypes, mockups, workflow diagrams, and flowcharts.

·        Enhances department reputation by accepting ownership of BI systems, accomplishes new and diverse project requests, and explores opportunities to add value to BI applications.

·        Validates Data to ensure data Quality


  • Evaluate user requirements
  • Create technical design/solutions to meet business needs for Data Warehouse, ETL and BI solutions

·        Day to day support of the data warehouse, associated data marts, ETL sub systems and in finding ways to stabilize the system resulting in higher performance and data accuracy



  • Bachelor’s Degree or equivalent work experience
  • Excellent analytical and problem solving skills
  • Proficient in SQL Development
  • Develop reports, cubes, dashboards, scorecards on Microstrategy
  • Strong written and verbal communication skills are essential to interact with business analysts, peers, and management
  • Must be well organized, detail oriented and able to self-prioritize work
  • Must exhibit a high degree of professionalism


  • 5 years of experience with MicroStrategy or other BI Tool
  • 5 years of experience in a BI position
  • Exposure to data modeling tools like Visio, Embarcadero, Erwin
  • Microstrategy
  • Teradata
  • MDM

Life at O'Reilly Auto Parts

About O'Reilly Auto Parts

O'Reilly Auto Parts is a Fortune 500 company with 60 straight years of continuous growth and over 80,000 team members at more than 5,200 stores and 28 distribution centers in 47 states. We are determined to be the leader in the auto parts industry and believe that our team members are the most important asset in our business.


  • Work/life balance
  • Diverse tech stacks and cross-training
  • Competitive compensation
  • Team member discounts
  • Comprehensive insurance coverage
  • 401K
  • Paid vacation
  • Remote work
  • Collaborative and solution-oriented teams
  • Educational Assistance

Joel Test

Source control
One-step build
Daily builds
Bug database
Bugs fixed before writing new code
Up-to-date schedule
Quiet working conditions
Best tools that money can buy
Code screening
Hallway usability testing
Learn more about O'Reilly Auto Parts
Business Intelligence Engineer at O'Reilly Auto Parts