Data Engineer II

Company:

Cox Automotive - USA

Job Family Group:

Engineering / Product Development

Job Profile:

Data Engineer II

Management Level:

Individual Contributor

Travel %:

Yes, 5% of the time

Work Shift:

Day (United States of America)

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. Must be located in the Atlanta, Georgia area.

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.

Qualifications:

• Bachelor's degree in Computer Science or related field and 2 years working experience
• Must be located in the Atlanta, Georgia area.
• Working experience with data modelling, data access, schemas, and data storage techniques within Snowflake
• Working experience working with relational databases such as SQL, MySQL, Postgres/PostgreSQL
• Working experience with Sisense, Tableau or Microsoft PowerBI platforms
• Working experience with batch and real-time data processing framework
• 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 system
• 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

Desirable:

• Scrum Developer Certification or equivalent
• Working experience with SQL Server Integration Services
• 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.

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.