Data Engineer II

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

Job summary

A leading company in automotive technology is seeking a Data Engineer II who will manage data processing, validation, and product development. This hybrid position in Atlanta involves working with emerging technologies and participating in Agile planning. Candidates should have a strong foundation in data management and experience with cloud platforms.

Benefits

Flexible vacation policy

Paid holidays

Paid wellness hours

Health care insurance

401(k) retirement planning

Qualifications

• 2+ years experience with data modeling, schemas, and storage techniques.
• Experience in highly scalable systems and components.
• Knowledge of relational databases and cloud-based platforms.

Responsibilities

• Process structured and unstructured data using various frameworks.
• Ensure data quality and implement validation tools.
• Provide ongoing support for deployed products.

Skills

Data Modeling

Data Validation

Communication

ETL Processes

Education

Bachelor’s degree in related discipline

Tools

Snowflake

SQL

AWS

Tableau

Power BI

Postgres

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 %

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.

About Us

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.