Data Engineer II

CAI Cox Automotive Corp Svcs., LLC; Atlanta (GA); Hybrid; USD 89,000 - 134,000; Full time

Benefits offered by this job

Health care insurance

401(k) retirement plan

Paid time off

Job summary

Cox Automotive is seeking a Data Engineer II to process structured and unstructured data, validate data quality, and build data products. The role supports Agile planning and advises on technologies while maintaining data pipelines and BI tooling.

The candidate will work on data warehouses, big data repositories, and application support, with opportunities to explore emerging data technologies and drive data quality improvements.

Qualifications

• Minimum: authorized to work in United States without sponsorship
• Must live within commutable distance of Atlanta, GA
• Bachelor’s degree in CS or related field and 2+ years of Data Engineering experience or Master’s with 1+ year
• Professional Data Engineer experience beyond internships

Responsibilities

• Process structured and unstructured data using batch/real-time pipelines
• Ensure data quality and automate data quality issue detection
• Participate in Agile planning and design viable data solutions
• Develop and optimize data solutions in data warehouses and big data repos
• Provide ongoing product/application support for deployed data products
• Monitor emerging data technologies and share insights with the team

Skills

Data modelling

Data quality

ETL processes

Python

Agile planning

Git

Jira/Rally

Education

Bachelor’s degree in Computer Science or related field

Master’s degree in related field

Tools

Snowflake

SQL

MySQL

PostgreSQL

Tableau

Power BI

Sisense

AWS DMS

Python

Git

Jira

Rally

Job description

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 % Yes, 5% of the time Work Shift Day Compensation Compensation includes a base salary in the range of $89,400.00 - $134,000.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.

What you’ll do

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

Who you are

Minimum Qualifications:

Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship. No OPT, CPT, STEM/OPT or visa sponsorship now or in future

Must live within a commutable distance of Atlanta GA

Bachelor’s degree in Computer Science or related field and minimum 2+ years of related Data Engineering experience or Masters degree and at minimum 1 year of professional Data Engineering experience

Must have professional working experience as a Data Engineer beyond internships

Required

• Working experience with data modelling, data access, schemas, and data storage techniques within Snowflake
• Working 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
• Working experience working with relational databases such as SQL, MySQL, Postgres/PostgreSQL
• Working experience with business intelligence tools and platforms
• Working experience with data quality tools
• Working experience with application lifecycle methodologies (e.g. waterfall, agile, iterative)
• Experience with ETL processes and tools
• Experience working with Git

Preferred Qualifications

• Scrum Developer Certification or equivalent
• Working experience with Sisense, Tableau or Microsoft PowerBI platforms
• Working experience with data modeling
• Working experience with the Snowflake ecosystem
• Working experience with AWS data tools (Database Migration Service)
• Working experience with Python
• Experience working with Jira, Rally or similar tools

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

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.

EEO, including disability/vets

Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship. No OPT, CPT, STEM/OPT or visa sponsorship now or in future.

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.