View Job

Sr Data Engineer

Cox Automotive | Draper UT 84020 USA | Part Time | Posted: 11/19/2019

Job Descriptiontop

Dealertrack, a Cox Automotive brand, is looking for a Senior Data Engineer with experience writing complex ETL code using a custom AWS ETL orchestration method via AWS PaaS services like, Step Functions, Lambda, RedShift, DynamoDB and S3 to join our engineering team in Salt Lake City, UT.


The Senior Data Engineer focuses on data pipeline development. This individual works with both batch and streaming data processing architectures. The focus is to work with data modelers to build transformations using the existing AWS based ETL orchestration layer to build data marts in a way that accommodates change to the source data.

The Job:
  • Build and maintain scalable data pipelines within the AWS Cloud.

    • Develop C# AWS Lambda functions for processing big data streams.

    • Develop complex SQL scripts for Enterprise Data Warehouse ETL jobs.

    • Develop and maintain Terraform configurations to support the data pipeline infrastructure.

  • Ensure data quality/integrity from various sources.
    • Data reconciliation between DB2 and AWS S3.

    • Data reconciliation of Enterprise Data Warehouse and source systems.

    • Monitoring change data capture tool for uptimes and record count validation.

  • Mentor junior members of the team.
    • Ensure standardized coding practices.

    • Work with junior members on new AWS technologies.

    • Encourage AWS Certification training.

  • Additional responsibilities include:
    • Support other Dealertrack engineering teams as needed.

    • Enhance exiting cutting-edge AWS data pipelines.
    • Develop as a core member of an Agile team, using Agile tools and methodology.

    • Possesses an extremely flexible attitude. Willing to work with multiple types of technologies and languages with an open mind and without technology bias.

    • Continuous interest in updating skill sets and knowledge of trends in the Big Data Technology space.


What We Look For:

  • Bachelor’s degree in Computer Science or a related discipline; Advanced degree preferred

  • 5-8 years relevant professional development experience.
  • Working knowledge of cloud architecture. AWS experience preferred.
  • Deep understanding of traditional OOP principles. Must have working experience in C#.

  • Strong SQL skills with deep understanding of complex SQL scripts.
  • Knowledge of Big Data technologies: AWS Redshift, AWS EMR, AWS Kinesis, AWS Lambda, Hadoop file system, Apache Spark, Apache Flink, Apache NiFi.

  • Experience working in an Agile environment. Rally experience preferred.

Our Engineering Teams:

At Dealertrack, we offer the chance to do your best work and lead the digital revolution of the auto industry with gusto. Our Engineering professionals are energetic influencers who have built a world-class software platform, for auto dealers, from the ground up. Collaboration is woven into the fabric of everything we do; from 24-hour Hackathons to sprint reviews and scrum teams, you'll be immersed in an environment that nurtures individualism, creative problem-solving, and intellect.


Who We Are + What We Do:

As part of the Cox Automotive family, Dealertrack is building a connected suite of software solutions and services to help automotive dealers thrive in today’s digital retailing environment. From digital marketing to credit applications and financing, our integrated approach is making buying, selling and shopping for a car more efficient and enjoyable for everyone involved.

About Cox Automotive

Cox Automotive Inc. makes buying, selling and owning cars easier for everyone, while also enabling mobility services. The global company’s 34,000-plus team members and family of brands, including Autotrader®, Clutch Technologies,®, Dealertrack®, Kelley Blue Book®, Manheim®, NextGear Capital®, VinSolutions®, vAuto® and Xtime®, are passionate about helping millions of car shoppers, tens of thousands of auto dealer clients across five continents and many others throughout the automotive industry thrive for generations to come. Cox Automotive is a subsidiary of Cox Enterprises Inc., a privately-owned, Atlanta-based company with revenues exceeding $20 billion.

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.

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.


Job Detailstop

Location Draper, UT, 84020, United States
Categories Information Technology

Location Maptop

Contact Informationtop

Contact Name -
How to apply Employer provided a link where your application will be accepted. Click on the link below and follow instructions.
Apply Click Here (apply to job)
Job Code 8442_1913921

Featured Employers - view all