200+ applicants
O'Reilly Auto Parts · 6 days ago
Data Engineer II
United States
Full-time
Remote
Mid, Senior Level
5+ years exp
Wonder how qualified you are to the job?
Maximize your interview chancesAutomotiveManufacturing
Hiring Manager
Rick N.
Insider Connection @O'Reilly Auto Parts
Responsibilities
Data Architecture Design: Lead the design, implementation, and maintenance of scalable data warehouse solutions.
ETL Process Management: Oversee the development and management of ETL processes using Informatica Intelligent Cloud Services (IICS)/FiveTran.
Cloud Data Platforms: Architect and manage cloud data warehouses using Snowflake/BigQuery.
Data Transformation: Utilize dbt to model, transform, and document data pipelines.
SQL Development: Develop, optimize, and maintain complex SQL queries and scripts.
Python Development: Develop, optimize, and maintain data processing scripts and applications using Python.
Data Visualization: Create and manage data visualizations using tools such as DOMO, Tableau, Power BI, or Looker.
Orchestration and Scheduling: Implement and manage orchestration/scheduling tools such as Apache Airflow, Prefect.
Team Leadership: Mentor and guide junior data engineers.
Cross-functional Collaboration: Work closely with data analysts, data scientists, and other stakeholders.
Performance Tuning: Monitor and enhance the performance of data systems.
Documentation and Standards: Maintain comprehensive documentation for data models, ETL processes, and data infrastructure.
Security and Compliance: Implement and manage data security protocols.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
Minimum of 5-7 years of experience in data engineering, data warehousing, and ETL development, with at least 2 years.
Expertise in designing and managing data warehouses.
Advanced proficiency in ETL tools like Informatica Intelligent Cloud Services (IICS), Fivetran, Azure Data Factory, Google Cloud Dataflow etc.
Extensive hands-on experience with Snowflake for data warehousing and management.
Proficient in dbt for data modeling and transformation.
Strong knowledge of Google BigQuery and its ecosystem.
Proficiency in SQL and database management.
Advanced skills in developing, optimizing, and maintaining complex SQL queries and scripts.
Advanced skills in Python for data processing and automation.
Experience with data visualization tools such as DOMO, Tableau, Power BI, or Looker.
Experience with orchestration/scheduling tools such as Apache Airflow, Prefect, or similar.
Experience with data observability tools to monitor data pipeline health and ensure data quality.
Knowledge of data governance principles and experience in implementing governance policies and procedures.
Experience with CI/CD practices for data engineering workflows.
Proven ability to lead and mentor a team of engineers, manage projects, and deliver results.
Strong problem-solving skills with the ability to analyze complex data requirements and develop efficient solutions.
Excellent written and verbal communication skills to effectively collaborate with team members and stakeholders.
Preferred
Experience with other cloud platforms (e.g., GCP, AWS, Azure) and their data services.
Knowledge of data governance and data quality frameworks.
Experience with version control systems like Git.
Company
O'Reilly Auto Parts
O’Reilly Automotive, Inc. is a specialty retailer of automotive aftermarket parts, tools, supplies, equipment and accessories.
10,001+ employees
Funding
Current Stage
Public CompanyTotal Funding
unknown1993-04-30IPO· nasdaq:ORLY
Leadership Team
Greg Johnson
President, Chief Executive Officer
Tom McFall
CFO
Recent News
The City Menus
2024-05-24
aftermarketNews
2024-05-24
Amarillo Country Radio
2024-05-24
Company data provided by crunchbase
