[Hiring] Lead Data Engineer @Cox

Role Description

Lead Data Engineer positions offered by Cox Automotive Corporate Services, LLC (Atlanta, Georgia). Responsibilities include:

• Designing simple and scalable solutions to complex problems.
• Delivering leading edge software products for customers.
• Serving as a technical leader in a collaborative team environment.
• Contributing to the engineering efforts of data scrum teams.
• Engineering right-sized solutions for complex business problems.
• Building patterns to support data pipelines, data warehousing, and data transformations.
• Applying knowledge of modern software design, best practices, design patterns, and frameworks.
• Using new technologies and developing innovative solutions.
• Performing data analytics, database design, and development.
• Influencing technical solutions while coaching newer or junior members on Scrum team.
• Constructing and managing services which extract data from disparate databases, transform the data, and load into data warehouse.
• Collaborating with team members on best practices, code reviews, internal tools, and process improvements.
• Developing high performing, scalable, and secure solutions.
• Diagnosing, designing, and implementing solutions to key technology or application problems.
• Investigating, evaluating, and presenting new emerging technologies for use with data solutions and integrations.
• Mentoring and assisting other engineers in area of ownership and expertise.
• Designing and maintaining data pipelines and databases.
• Translating business requirements and data mappings into data integrations and ingestions code solutions.
• Recommending and coding efficient and effective data integration and ingestion solutions for challenging problems.
• Working closely with product managers and engineers to design, implement, test, and continually improve scalable data solutions and services running on DBT & Snowflake cloud platforms.
• Implementing system data integration and ingestion fixes for the data platform and environment.
• Ensuring root cause resolution to identified problems.
• Monitoring and supporting the Data Solutions jobs and processes to meet the daily SLA.
• Leading team on Data Integration solutions.

Qualifications

• Bachelor’s or foreign equivalent degree in Computer Science, Electronic Engineering, or related field.
• 6 years of experience working in data engineering.

Requirements

• 6 years of experience in each of the following:
• Building and deploying large-scale data processing pipelines.
• Identifying performance bottlenecks and optimizing ETL processes.
• Designing and implementing scalable data pipelines.
• Performing programming and scripting in SQL, PL/SQL, and Python.
• Automating using Python.
• Performing ETL and data warehousing using Informatica PowerCenter for ETL processes, as well as Exadata and on-premise data warehouse solutions.
• In lieu of a bachelor’s degree and 6 years of experience as stated, the employer will accept:
• A master’s or foreign equivalent degree in the aforementioned fields and 4 years of experience as stated.
• A Ph.D. or foreign equivalent degree in the aforementioned fields and 1 year of experience as stated.
• 1 year of experience:
• Warehousing cloud data in Snowflake.
• Performing data transformation and modeling in dbt (Data Build Tool) and schema design, including star schema.
• Developing data pipelines, including ETL/ELT pipeline development, using dBT Labs and ELT tool.

Benefits

• Flexibility to take as much vacation with pay as deemed consistent with duties and company needs.
• Seven paid holidays throughout the calendar year.
• Up to 160 hours of paid wellness annually for personal or family wellness.
• Additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave.