Lead Data Engineer

Company:

Cox Automotive - USA

Job Family Group:

Engineering / Product Development

Job Profile:

Lead Data Engineer

Management Level:

Manager - Non People Leader

Travel %:

No

Work Shift:

Day (United States of America)

Job Description:

Cox Automotive is seeking a Lead Data Engineer for a full-time employee position based in our Carmel, IN office. This will be "hybrid", work-from-home role requiring the selected candidate to come into our Carmel office approximately once a week, and potentially up to 10 times a month.

We are migrating from MS SQL Server to Snowflake and seeking a Lead Data Engineer with extensive experience supporting enterprise data initiatives on DBT & Snowflake cloud platforms.

What you'll be doing:

• 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.
• The selected candidate will have a robust background in software development, coding, and hands-on experience to steer our Infrastructure Automation practice. This role will be integral to transforming the way Cox Automotive designs, delivers, and manages infrastructure within our strategic on-premises data centers.
• Responsible for technical design, writing, support and operations of efficient, scalable, and extensible data integrations and ingestions.
• Lead and participate in architecture and design efforts.
• Implement enhancements for prioritized data integration and ingestions work efforts partnering with the business to ensure they meet the specified requirements.
• Create and own the technical product backlogs for products, help the team to close the backlogs in right time.
• 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 critical and non-critical system data integration and ingestion fixes for the data platform and environment. Ensuring root cause resolution to identified problems. Monitor and support the Data Solutions jobs and processes to meet the daily SLA.
• Recommend and code efficient and effective data integration and ingestion solutions for challenging problems for medium to large work efforts of medium to high complexity.
• Translate business requirements, data mappings into data integrations and ingestions code solutions.
• Design and maintain data pipelines and databases.
• Lead data curation efforts and ensure the quality of datasets.
• Manage data-related software systems.
• Work effectively with Technology Operations/Infrastructure teams to ensure continued operations and maintenance of the data integrations and ingestions as well as the data platform and environment.
• Full lifecycle application development related to middleware and enterprise data movement.
• Advance the cloud architecture for data stores.
• Mentor and assist other engineers in or out of your areas of ownership and expertise.
• Investigate, evaluate, and present new emerging technologies for use with data solutions and integrations.
• Develop scalable production ready data integration and processing solutions.
• Convert large volumes of structured and unstructured customer data.
• Choose and use the right analytical libraries, programming languages, and frameworks for each task.

What we require from you:

• Bachelor's degree in Computer Science or related field plus 7+ years of relevant work experience; or a Master's degree plus 5+ years of relevant work experience; or a PhD plus 5+ years of relevant experience
• In lieu of a degree, qualified candidates would require 14+ years of relevant professional experience
• Solid experience supporting Snowflake Data Warehouse
• Previous experience with DBT
• Solid MS SQL Server skills including reporting experience using SSIS/SSRS
• Good to have AWS and Azure cloud implementation experience.
• Good to have Reporting development and Production support.

Drug Testing:

To be employed in this role, you'll need to clear a pre-employment drug test. Cox Automotive does not currently administer a pre-employment drug test for marijuana for this position. However, we are a drug-free workplace, so the possession, use or being under the influence of drugs illegal under federal or state law during work hours, on company property and/or in company vehicles is prohibited.

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.