AI-Driven Data Engineer, Snowflake & AWS Pipelines

CAI Cox Automotive Corp Svcs., LLC; Atlanta (GA); On-site; USD 102,000 - 169,000; Full time

Benefits offered by this job

Health insurance

401(k) retirement plan

Paid time off

Vacation flexibility

Paid holidays

Wellness hours

Job summary

Cox Automotive’s Enterprise Platforms Data & Analytics team in Atlanta seeks a hands-on data engineer to own and ship production pipelines in Snowflake, using an AWS framework and governance. You will mentor onshore and offshore engineers and partner with product and AI teams to deliver reliable datasets for BI and AI workloads.

Expect a base salary range of $101,500 to $169,100 with potential incentive compensation, and a collaborative, metric‑driven environment that emphasizes data quality,

Qualifications

• Authorized to work in the United States without visa sponsorship.
• Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent practical experience.
• Minimum 4 years of experience in Data Engineering with production ETL/ELT pipelines, strong Python and SQL.
• Deep Snowflake knowledge: schema/view design, MERGE/history tables, masking, performance.
• Strong hands-on AWS data services in production: serverless, storage, orchestration, CDC, IAM.
• IaC & release automation: CloudFormation or Terraform, CI/CD pipelines.
• Ingesting from relational databases, ERP/CRM, SaaS APIs, and flat files.
• Data modeling for analytics: dimensional/denormalized, raw/hub/mart layers.
• Data quality, observability: validation, SLA, freshness and alerting.
• Data security/governance: PII masking, least-privilege, metadata lineage.
• Ability to work in an Agile Release Train; write user stories & acceptance criteria.
• Mentoring engineers and leading onshore/offshore teams.

Responsibilities

• Design, build, and operate metadata-driven ingestion/egress pipelines to Snowflake via AWS framework.
• Own end-to-end feature delivery: onboarding, modeling, transformations, validation, CI/CD.
• Build governed Snowflake views/models/marts with PII masking and data quality checks.
• Extend shared libraries for scalable source onboarding via configuration.
• Define data quality, reconciliation, and peer validation standards with SLA checks.
• Lead production readiness and resolve escalations with teams across locales.
• Migration of legacy code to domain-owned repos with CI/CD and catalog metadata.
• Use AI-assisted development to raise throughput while maintaining reviews.
• Collaborate with Product Owners and AI teams to deliver governed datasets for BI/AI workloads.
• Mentor junior engineers and contribute to engineering standards.
• Produce docs, runbooks, and track features/dependencies for Release Train.

Skills

Python

SQL

Snowflake

AWS

Data modeling

CI/CD

Mentoring

Education

Bachelor’s degree in Computer Science, Information Systems, or related field

Tools

dbt

Apache Airflow

Terraform

CloudFormation

Git

Snowflake AI features

Job description

Cox Automotive’s Enterprise Platforms Data & Analytics team in Atlanta seeks a hands-on data engineer to own and ship production pipelines in Snowflake, using an AWS framework and governance. You will mentor onshore and offshore engineers and partner with product and AI teams to deliver reliable datasets for BI and AI workloads.

Expect a base salary range of $101,500 to $169,100 with potential incentive compensation, and a collaborative, metric‑driven environment that emphasizes data quality,