Data Engineer I: Cloud ELT Pipelines & Data Vault

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

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.