Lead Data Engineer

Company Cox Automotive - USA Job Family Group Engineering / Product Development Job Profile Lead Data Engineer Management Level Manager - Non People Leader Flexible Work Option Hybrid - Ability to work remotely part of the week Travel % No Work Shift Job Description Cox Automotive Corporate Services, LLC Lead Data Engineer Job Description: Lead Data Engineer positions offered by Cox Automotive Corporate Services, LLC (Atlanta, Georgia). Design simple and scalable solutions to complex problems and deliver leading edge software products for our customers. Serve as a technical leader in a collaborative team environment and contribute to the engineering efforts of data scrum teams. Engineer right-sized solutions for complex business problems focused on building patterns to support data pipelines, data warehousing, and data transformations. Apply knowledge of modern software design, best practices, design patterns, and frameworks, with an understanding of application performance and maintainability. Use new technologies and develop innovative solutions. Perform data analytics, database design and development. Influence technical solutions while coaching newer or junior members on Scrum team. Construct and manage services which extract data from disparate databases, transform the data and load into 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 new emerging technologies for use with data solutions and integrations. Mentor and assist other engineers in area of ownership and expertise. Design and maintain data pipelines and databases. Translate business requirements, data mappings into data integrations and ingestions code solutions. Recommend and code efficient and effective 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 to identified problems. Monitor and support the Data Solutions jobs and processes to meet the daily SLA. Lead team on Data Integration solutions. Minimum Requirements: Requires a bachelor’s or foreign equivalent degree in Computer Science, Electronic Engineering, or related field and 6 years of experience working in data engineering. Must have 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; and 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, or a Ph.D. or foreign equivalent degree in the aforementioned fields and 1 year of experience as stated. Must also have 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; and, Developing data pipelines, including ETL/ELT pipeline development, using dBT Labs and ELT tool. Position reports to Atlanta, GA office. Telecommuting permitted in accordance with company policy, but must live within commuting distance of stated office. Compensation includes a base salary of $160,056-$183,326. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate’s knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program. The Company offers eligible employees the flexibility to take as much vacation with pay as they deem consistent with their duties, the company’s needs, and its obligations; seven paid holidays throughout the calendar year; and up to 160 hours of paid wellness annually for their own wellness or that of family members. Employees are also eligible for 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. #GMREQ About Us Through groundbreaking technology and a commitment to stellar experiences for drivers and dealers alike, Cox Automotive employees are transforming the way the world buys, owns, sells – or simply uses – cars. Cox Automotive employees get to work on iconic consumer brands like Autotrader and Kelley Blue Book and industry-leading dealer-facing companies like vAuto and Manheim, all while enjoying the people-centered atmosphere that is central to our life at Cox. Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page. Cox is an Equal Employment Opportunity employer – All qualified applicants/employees will receive consideration for employment without regard to that individual’s age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental 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 disability, unless such accommodations would cause an undue hardship. EOE, including disability/vets Cox brings together the world’s greatest minds to help breathe life into new possibilities – and drive innovation for a better future. That’s why we look for individuals who share our pioneering spirit, have imaginative ideas and are fearless when it comes to tackling the world’s biggest challenges. Our people love technology – and they love making a difference. They have a passion for finding new solutions and working with brilliant colleagues. Every day they dedicate themselves to a huge range of exciting projects, contributing to the Cox vision around the globe. From engineering new sustainability solutions that conserve water and energy to creating the infrastructure for the smart cities of tomorrow, there’s no challenge too great for our pioneers. And there’s no shortage of opportunities for you to make a difference. Come and experience the dynamic, collaborative and creative environments where your ideas are welcome and new discoveries are waiting. To help you grow to your full potential, we strive to support our employees in their career aspirations and promote the freedom to explore new horizons.