Data Engineer I

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.
Job Description
Our Data & Analytics team partners closely with business stakeholders to deliver trusted data, analytics, and insights that support operational and strategic decision-making. We design, build, and maintain a modern data warehouse that serves as the foundation for reporting, analytics, and data-driven solutions across our line of business.
We are seeking a Data Engineer I to join our team and help develop scalable data solutions that transform raw data into actionable insights. This role is ideal for someone early in their data engineering career who wants hands-on experience with modern cloud technologies, AI-assisted development workflows, and data warehousing practices, working alongside experienced engineers, analysts, and business partners to build pipelines, enhance our Data Vault-based warehouse, and deliver high-quality data assets.
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 (list any requirements of discipline here). 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, 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