Data Engineer II

Company

Cox Automotive - USA

Job Family Group

Engineering / Product Development

Job Profile

Data Engineer II

Management Level

Individual Contributor

Flexible Work Option

Hybrid - Ability to work remotely part of the week

Travel %

No

Work Shift

Day

Compensation

Compensation includes a base salary of $87,200.00 - $130,800.00. 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.

Job Description

​The Data Engineer II is responsible for processing structured and unstructured data, validating data quality, and developing and supporting data products. The Data Engineer also plays a role in Agile planning, providing advice and guidance, and monitoring emerging technologies. 

 
KEY RESPONSIBILITIES: 
Process Structured and Unstructured Data 

• Gathers and processes raw, structured, semi-structured, and unstructured data using batch and real-time data processing frameworks. 

• Understands and enforces appropriate data master management techniques. 

Data Validation and Quality 

• Ensures data quality and implements tools and frameworks for automating the identification of data quality issues. 

• Work with internal and external data providers on data validation providing feedback and making customized changes to data feeds and data mappings. 

Agile Planning 

• Understands the challenges that the analytics organization faces in their day-to-day work and partner with them to design viable data solutions. 

• Recommends improvements to processes, technology, and interfaces that improve the effectiveness of the team and reduce technical debt. 

Product Development 

• Implements and optimizes data solutions in enterprise data warehouses and big data repositories. 

• Installs, maintains, monitors, and supports business intelligence, distributed computation, and big data analytics tools. 

Application Support 

• Provides ongoing support, monitoring, and maintenance of deployed products. 

Emerging Technology Monitoring 

• Actively participates in the engineering community, staying up to date on new data technologies and best practices and shares insights with others in the organization. 

Min Qualifications: 

• Bachelor’s degree in a related discipline and 2 years’ experience in a related field. The right candidate could also have a different combination, such as a master’s degree and up to 2 years’ experience; or 6 years’ experience in a related field

• Requires 2+ years of experience with data modeling, data access, schemas, and data storage techniques within  Snowflake 

• Excellent communication skills to work effectively with teams throughout organization

• 2+ years experience in design, development, and implementation of highly scalable, high-volume software systems and components, client-facing web applications, and major Internet-oriented applications and systems 

• Strong knowledge working with relational databases such as SQL, MySQL, Postgres/PostgreSQL 

• Working experience with business intelligence tools and platforms 

• 2+ years of experience working with cloud-based data platforms (e.g. Oracle, Snowflake, AWS, GCP, Azure, or other combinations)  

• Working experience with application lifecycle methodologies (e.g. waterfall, agile, iterative) 

• Experience with ETL processes and tools 

Preferred Qualification: 

• Scrum Developer Certification or equivalent  

• Experience with Sisense, Tableau or Microsoft PowerBI platforms  

• Experience with AWS data tools (Database Migration Service)  

• Experience with SQL Server Integration Services  

• Experience with the Snowflake ecosystem  

• Experience with AWS data tools (Database Migration Service)  

 

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.

Benefits

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.

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.

Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship.