ESG Data Analyst

O'Reilly Automotive Stores; Springfield (MO); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Competitive Wages

PTO

Stock Purchase Plan

401k

Insurance (Medical/Dental/Vision)

Tuition Assistance

Career Growth

Job summary

O'Reilly Automotive Stores is seeking a data-driven ESG data analyst to lead collection, auditing, analysis, and reporting of sustainability metrics for GHG tracking and disclosures. The role collaborates across functions to ensure timely, accurate ESG data and supports external reporting with robust dashboards and insights.

The position requires a Bachelor's degree and advanced Excel, SQL, Python or R skills, with experience in data visualization and cross-team communication.

Qualifications

• Bachelor’s degree in a field related to data, IT, finance, or accounting.
• Advanced Excel skills including queries, formulas, pivots, and macros.
• Experience in data management, analysis, and visualization.
• Proficiency with SQL, Python, or R for data manipulation and analysis.
• Familiarity with ESG reporting concepts and data governance.
• Strong communication and multitasking abilities.

Responsibilities

• Collaborate cross-functionally to collect, organize, and analyze data needed for internal and external ESG reporting and disclosures
• Define and implement a process to ensure timely, accurate ESG data collection for reporting
• Update and maintain ESG data repositories
• Perform ESG data audits for precision, quality, completeness, and audit readiness using quality assurance processes
• Coordinate with third-party data assurance providers as necessary to support audit readiness
• Identify and recommend best practices to improve quality, precision, accuracy, and data granularity
• Work with consultants and third-party suppliers to execute continuous improvement
• Calculate and track GHG emissions (Scope 1, 2, 3) using GHG protocol standards
• Partner with ESG leadership to track progress toward GHG reduction targets
• Support Energy Management Committee groups to identify and measure energy reduction initiatives
• Model energy savings and financial impact of initiatives
• Draft and submit internal and external ESG reporting including the CDP response
• Provide project support for ESG team including market research and benchmarking
• Create insights and recommendations to influence decisions
• Advise on ESG reporting methodologies and disclosure frameworks
• Track evolving guidance and requirements
• Build data visualizations, models, and dashboards to communicate sustainability performance
• Complete all other duties as assigned

Skills

Data analysis

ESG reporting

Excel

SQL

Python

R

Data visualization

Communication

Time management

Education

Bachelor’s degree in a relevant field

Tools

Microsoft Excel

SQL

Python

R

Pivot tables

Macros

Microsoft Office

Job description

Lead the collection, auditing, analysis, and reporting of ESG data to support accurate sustainability disclosures and greenhouse gas tracking.

Responsibilities

• Collaborate cross-functionally to collect, organize, and analyze data needed for internal and external ESG reporting and disclosures
• Define and implement a process to ensure timely, accurate ESG data collection for reporting
• Update and maintain ESG data repositories
• Perform ESG data audits for precision, quality, completeness, and audit readiness using quality assurance processes
• Coordinate with third-party data assurance providers as necessary to support audit readiness
• Identify and recommend best practices to improve quality, precision, accuracy, and data granularity
• Work with consultants and third-party suppliers as necessary to execute continuous improvement
• Calculate and track Scope 1, Scope 2, and Scope 3 greenhouse gas (GHG) emissions using GHG protocol standards
• Partner with the ESG Director and ESG Reporting Manager to track progress toward GHG reduction targets for Scopes 1, 2, and 3
• Support Energy Management Committee working groups to identify, implement, track, and measure energy reduction initiatives
• Model energy savings and financial impact of initiatives to measure progress toward GHG reduction targets
• Collaborate with the ESG Reporting Manager, ESG Reporting Committee, and other stakeholders to draft and submit internal and external ESG reporting and disclosures, including the annual Impact report and the Company’s CDP response
• Provide project and initiative support for the ESG team, including benchmark analysis, market research, and other requested projects
• Create guidance and support to provide meaningful insights and recommendations that influence decisions
• Advise on ESG data reporting methodology, frameworks, and disclosure systems including GHG Protocol, CDP, TCFD, ISSB, and SBTi
• Track and stay current with evolving guidance and reporting requirements
• Build and maintain data visualizations, models, and dashboards to communicate sustainability performance and meet business needs
• Complete all other duties as assigned

Requirements

• Bachelor’s degree or certificate in a relevant field such as Data/Computer Science, Management Information Systems, Accounting, Finance, Economics, Statistics, etc.
• Advanced Microsoft Excel skills, including retrieving and manipulating data using Microsoft Query, formulas, pivot tables, and macros
• Experience with data management, analysis, and visualization
• Scripting experience with tools such as SQL, Python, or R (R or Python preferred)
• Experience with at least one object oriented statistical language (for example R or Python) and working with structured and unstructured databases
• Analytical skills with experience in data manipulation and statistical analysis
• Proficiency in Microsoft Office Suite (Word, PowerPoint, Outlook)
• Ability to communicate effectively with various levels of the organization
• Strong time management skills, managing multiple projects with different objectives, milestones, and deliverables

Preferred / Desired

• 2-3 years of relevant professional experience
• Knowledge of GHG Protocol Corporate Standard
• Familiarity with ESG reporting frameworks such as CDP, TCFD, and SBTi
• Experience in carbon accounting, including GHG inventory development
• Experience translating GHG emissions findings into actionable recommendations for target setting and decarbonization

Technologies

• Microsoft Excel, Microsoft Query
• SQL
• Python, R
• Pivot tables, macros
• Microsoft Office Suite (Word, PowerPoint, Outlook)
• GHG Protocol, CDP, TCFD, ISSB, SBTi

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

Location: Springfield, MO (onsite)

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