Lead Data Engineer

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. #J-18808-Ljbffr CAI Cox Automotive Corp Svcs., LLC