Senior Data Engineer (Snowflake & DBT)

Description

Cox Automotive is seeking a Senior Data Engineer for a full-time employee position based in 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 data from MS SQL Server to Snowflake and seeking a Senior Data Engineer with extensive hands on experience with DBT (Data Build Tool), Airflow, Data Vault & Snowflake cloud platforms.

What you'll be doing :

• 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.

• 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.

• Translate business requirements, data mappings into data integrations and ingestions code solutions.

• Design and maintain data pipelines using DBT and Data Vault.

• 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.

• Develop scalable production ready data integration and processing solutions.

What we require from you :

• Bachelor’s degree in Computer Science or related field plus 4+ years of relevant work experience; or a Master's degree plus 2+ years of relevant work experience; or a PhD plus 0-1 years of relevant experience

• In lieu of a degree, qualified candidates would require 8+ years of relevant professional experience

• Solid experience supporting Snowflake Data Warehouse

• Previous experience with DBT, Airflow

• 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 Cox Automotive

At Cox Automotive, people of every background are driven by their passion for mobility, innovation and community. We transform the way the world buys, sells, owns and uses cars, accelerating the industry with global powerhouse brands like Autotrader, Kelley Blue Book, Manheim and more. What’s more, we do it all with an emphasis on employee growth and happiness. Drive your future forward and join Cox Automotive today! 

About Cox

Cox empowers employees to build a better future and has been doing so for over 120 years. With exciting investments and innovations across transportation, communications, cleantech and healthcare, our family of businesses – which includes Cox Automotive and Cox Communications – is forging a better future for us all. Ready to make your mark? Join us today! 

----------

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.

Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.