Data Engineer

Overview

Auto Plus is a leading automotive aftermarket parts distributor in the US. We bring together unmatched expertise with best-in-class parts and customer service for the most reliable automotive aftermarket parts store experience. Headquartered in Kennesaw, Georgia, Auto Plus has more than 4,000 Team Members with decades of experience in the automotive aftermarket industry, united to deliver on our Auto Plus Promise: We exceed expectations with expertise at every turn. Auto Plus has more than 300 locations, including corporate-owned stores, independent Auto Plus member locations and commercial parts-focused Pep Boys retail stores, and 21 distribution centers. We aspire to be the most trusted business partner and employer in the automotive aftermarket.

Position Summary

The Data Engineer is responsible for designing and developing data pipelines and integrations. The position will understand the business needs current and future to help deliver and guide a data strategy around data pipelines.

This position is located at our corporate office in Kennesaw, GA. There is the option to work remote 1 or 2 days each week.

Duties and Responsibilities

• Develop ETL and ELT solutions leveraging various on-site and cloud resources
• Lead technical direction for obtaining and implementing data pipeline and data technologies
• Help evaluate current and future staffing needs
• Document and define goals and standards for data pipeline integration and data models
• Drive the creation of new standards and best practices as technology evolves as well as communicate and drive adoption across the company
• Provide continuous operational support for data pipelines
• Monitor and maintain uptime of data pipelines and integrations
• Other duties as assigned

Knowledge, Skills, and Abilities

• Bachelor degree in Information Technology or related field or equivalent work experience is required
• 5 years of experience in the curation of data pipelines and integrations is required
• 3 years of experience working with cloud data technologies is required; AWS is preferred
• Expertise with SQL, database design/structures, ETL/ELT design patterns, and datamart structures such as Star and Snowflake schemas is required
• Deep understanding of data management and data governance best practices is required
• Knowledge of Oracle and/or SQL Server is required
• Deep understanding of query tuning and optimizing SQL is required
• Proficient understanding of data pipeline, transformation, and modeling of data processes is required
• Experience working with large datasets or database systems is required
• Excellent verbal and written communication skills and interpersonal skills
• Must be able to effectively collaborate with business groups and internal IT resources
• Must be a self-starter and able to work independently
• Must be able to understand and translate business objectives into actionable results
• Experience in data lake patterns and process is a plus
• Experience with SAP is a plus
• Experience with Power BI, DOMO, Redshift, Fivetran, Glue, Pentaho and/or DMS is a plus
• Ability to occasionally work on-call after normal working hours is required
• Must not require sponsorship now or at any time in the future

Physical Demands/Work Environment
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

Physical Demands

• Repetitive movement of hands and fingers, typing or writing
• Occasional standing and walking
• Talk and hear