Lead Data Engineer

CAI Cox Automotive Corp Svcs., LLC; Atlanta (GA); Hybrid; USD 160,056 - 183,326; Full time

Benefits offered by this job

Health care insurance

Retirement planning (401(k))

Flexible vacation

Paid wellness days

Seven paid holidays per year

Job summary

CAI Cox Automotive Corp Svcs., LLC is seeking a Lead Data Engineer in Atlanta, GA, to design scalable solutions to complex data challenges. You'll lead a team within data scrum environments, ensuring effective data pipelines and warehousing processes while utilizing modern technologies.

The ideal candidate has over 6 years of experience in data engineering, is proficient in SQL and Python, and is familiar with tools like Informatica and Snowflake. This hybrid role allows for remote work a few days a week.

Qualifications

• 6 years of experience in data engineering.
• Experience building and deploying large-scale data processing pipelines.
• Experience identifying performance bottlenecks and optimizing ETL processes.

Responsibilities

• Engineer solutions for complex business problems.
• Perform data analytics and database design.
• Mentor and assist other engineers.

Skills

Data engineering

SQL

Python

ETL processes

Data warehousing

Automation

DBT

Snowflake

Education

Bachelor’s degree in Computer Science or related field

Tools

Informatica PowerCenter

Exadata

Job description

Lead Data Engineer – Cox Automotive Corporate Services, LLC (Atlanta, GA)

Design simple and scalable solutions to complex data problems, deliver leading‑edge software products, and serve as a technical leader within collaborative data scrum teams.

Responsibilities

• Engineer right‑sized solutions for complex business problems focused on building patterns to support data pipelines, data warehousing, and data transformations.
• Apply modern software design practices, design patterns, and frameworks, ensuring application performance and maintainability.
• Use new technologies and develop innovative solutions.
• Perform data analytics, database design, and development.
• Construct and manage services that extract, transform, and load data from disparate databases into a data warehouse.
• Collaborate with team members on best practices, code reviews, internal tools, and process improvements.
• Develop high‑performing, scalable, and secure solutions.
• Diagnose, design, and implement solutions to key technology or application problems.
• Investigate, evaluate, and present emerging technologies for data solutions and integrations.
• Mentor and assist other engineers within areas of ownership and expertise.
• Design and maintain data pipelines and databases.
• Translate business requirements and data mappings into data integration and ingestion code solutions.
• Recommend and code efficient data integration and ingestion solutions for challenging problems.
• Work closely with product managers and engineers to design, implement, test, and continually improve scalable data solutions and services running on DBT & Snowflake cloud platforms.
• Implement system data integration and ingestion fixes for the data platform and environment.
• Ensure root cause resolution for identified problems.
• Monitor and support data solution jobs and processes to meet daily SLA.
• Lead the team on data integration solutions.

Qualifications

• Bachelor’s (or equivalent) degree in Computer Science, Electronic Engineering, or related field; or Master’s (or equivalent) with 4 years of experience; or Ph.D. (or equivalent) with 1 year of experience.
• 6 years of experience in data engineering.
• Experience building and deploying large‑scale data processing pipelines.
• Experience identifying performance bottlenecks and optimizing ETL processes.
• Experience designing and implementing scalable data pipelines.
• Programming and scripting in SQL, PL/SQL, and Python.
• Automation using Python.
• ETL and data warehousing using Informatica PowerCenter for ETL processes, as well as Exadata and on‑premise data warehouse solutions.
• 1 year of experience warehousing data in Snowflake.
• 1 year of experience performing data transformation and modeling in dbt (Data Build Tool) and schema design, including star schema.
• 1 year of experience developing data pipelines, including ETL/ELT pipeline development, using dBT Labs and ELT tools.

Compensation

• Base salary range: $160,056 – $183,326 per year.
• Potential eligibility for additional compensation, such as incentive programs.

Benefits

• Health care insurance (medical, dental, vision).
• Retirement planning (401(k)).
• Paid time off: flexible vacation, paid wellness days, bereavement leave, voting leave, jury duty leave, volunteer time off, military leave, and parental leave.
• Seven paid holidays per year.

Telecommuting

Hybrid work environment; remote work permitted part of the week. Must reside within commuting distance of the Atlanta, GA office.

Equal Employment Opportunity Statement

Cox is an Equal Employment Opportunity employer. All qualified applicants and employees will receive consideration for employment without regard to age, race, color, religion, national origin, gender, gender identity, sexual orientation, disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Cox provides reasonable accommodations when requested by a qualified applicant or employee with a disability, unless such accommodations would cause undue hardship.