Data Engineer I

CAI Cox Automotive Corp Svcs., LLC; Indianapolis (IN); Remote; USD 67,000 - 101,000; Full time

Job summary

Cox Automotive seeks a Data Engineer I to build and optimize data pipelines, develop a Data Vault warehouse, and advance ELT processes on cloud platforms. You will collaborate with analysts and stakeholders to translate data needs into scalable solutions, ensure data quality, and participate in design reviews.

Applicants should have a CS degree, strong SQL and Python skills, and familiarity with cloud data tools such as Snowflake, dbt Cloud, and Data Vault concepts.

Qualifications

• Bachelor's degree in Computer Science or related field.
• Experience writing and troubleshooting SQL queries.
• Understanding of relational database concepts, including tables, joins, keys, and normalization.
• Foundational knowledge of data integration, ETL/ELT, or data warehousing concepts.
• Experience with a programming or scripting language such as Python, SQL, PowerShell, or similar.
• Strong analytical, problem-solving, and troubleshooting skills.
• Ability to work effectively in a collaborative team environment.
• Strong verbal and written communication skills.

Responsibilities

• Build, test, and maintain data pipelines that ingest, transform, and deliver data from operational and third-party source systems.
• Contribute to the ongoing development of our Data Vault-based data warehouse.
• Develop and optimize ELT processes using modern cloud data platforms and transformation tools.
• Partner with analysts and business stakeholders to translate data requirements into scalable technical solutions.
• Monitor and improve data quality, reliability, and performance across warehouse and reporting solutions.
• Participate in code reviews, testing activities, and technical design discussions.
• Create and maintain technical documentation for data flows, transformations, and business rules.
• Support production processes and assist in troubleshooting data-related issues.
• Use AI-assisted development tools like Claude Code as part of daily engineering work - pipeline development, code review, testing, and documentation.
• Continuously learn and apply emerging technologies, tools, and engineering best practices.

Skills

SQL

Python

ETL/ELT

Data Warehousing

Data Modeling

Education

Bachelor's degree in Computer Science

Tools

Snowflake

dbt Cloud

Data Vault 2.0

AWS

Azure

Microsoft Fabric

Microsoft SQL Server

Git

CI/CD

Claude Code

Job description

Company Cox Automotive - USA Job Family Group Engineering / Product Development Job Profile Data Engineer I Management Level Individual Contributor Flexible Work Option Can work remotely but need to live in the specified city, state, or region Travel % No Work Shift Day Compensation Compensation includes a base salary in the range of $67,100.00 - $100,700.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.

What You’ll Do

• Build, test, and maintain data pipelines that ingest, transform, and deliver data from operational and third-party source systems.
• Contribute to the ongoing development of our Data Vault-based data warehouse.
• Develop and optimize ELT processes using modern cloud data platforms and transformation tools.
• Partner with analysts and business stakeholders to translate data requirements into scalable technical solutions.
• Monitor and improve data quality, reliability, and performance across warehouse and reporting solutions.
• Participate in code reviews, testing activities, and technical design discussions.
• Create and maintain technical documentation for data flows, transformations, and business rules.
• Support production processes and assist in troubleshooting data-related issues.
• Use AI-assisted development tools like Claude Code as part of daily engineering work - pipeline development, code review, testing, and documentation.
• Continuously learn and apply emerging technologies, tools, and engineering best practices.

Our Team

Our team delivers the data foundation that enables analytics, reporting, and data-driven decision-making across the business. We build and maintain a Data Vault-based warehouse that integrates data from numerous operational systems and provides trusted, analytics-ready data to stakeholders across the organization.

Our technology stack includes

Warehousing & Transformation: Snowflake, dbt Cloud, Data Vault 2.0
Cloud Platforms: AWS, Microsoft Azure, Microsoft Fabric
Source Systems: Microsoft SQL Server
Engineering Practices: Git-based source control, CI/CD
AI-Assisted Development: Claude Code

Required Qualifications

• Bachelor's degree in Computer Science.
• The right candidate could also have a different combination, such as 4 years' experience in a related field.
• Experience writing and troubleshooting SQL queries.
• Understanding of relational database concepts, including tables, joins, keys, and normalization.
• Foundational knowledge of data integration, ETL/ELT, or data warehousing concepts.
• Experience with a programming or scripting language such as Python, SQL, PowerShell, or similar.
• Strong analytical, problem-solving, and troubleshooting skills.
• Ability to work effectively in a collaborative team environment.
• Strong verbal and written communication skills.
• Demonstrated ability to learn new technologies and adapt to changing business and technical requirements.
• Availability for rotational on-call duties outside of standard business hours may be required.

Preferred Qualifications

• Internship, co-op, academic project, or professional experience related to data engineering, analytics, software engineering, or business intelligence.
• Experience working with cloud platforms such as AWS or Microsoft Azure.
• Familiarity with Snowflake, Microsoft Fabric, or other cloud-based data platforms.
• Experience using dbt or similar data transformation frameworks.
• Understanding of data warehousing methodologies, including Data Vault, dimensional modeling, or star schema design.
• Experience developing or supporting data pipelines and data integration processes.
• Familiarity with source control systems such as Git, GitHub, or Azure DevOps.
• Exposure to CI/CD concepts and modern software development practices.
• Experience with analytics and reporting tools such as Power BI.
• Relevant certifications in Microsoft Azure, AWS, Snowflake, Microsoft Fabric, or related technologies.

Who You Are

• You're curious, analytical, and motivated to learn.
• You enjoy working with data, solving problems, and collaborating with others to deliver solutions that create business value.
• You're excited to build a strong foundation in modern data engineering while contributing to a team that shapes how data is leveraged across the business.

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 and 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. EOE, 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.