Senior Data Engineer — AI-Driven Snowflake Platform

Cox Enterprises, Inc.; Atlanta (GA); On-site; USD 140,000 - 190,000; Full time

Job summary

Cox Automotive's Enterprise Platforms Data & Analytics organization owns the pipelines, Snowflake data layers, and governed data products that feed Finance, Sales, Marketing, Service, and the company's AI initiatives.

Data lands in Snowflake from dozens of enterprise sources through a metadata-driven AWS framework, is modeled into conformed and mart layers, and is exposed to BI tools, downstream applications, and AI agents under strict governance and PII controls.

Qualifications

• Authorized to work in the United States without sponsorship.
• Must be located in Atlanta or willing to relocate at own expense.
• Bachelor's degree in Computer Science, Information Systems, or related field, or equivalent practical experience.
• Minimum of 4 years experience in Data Engineering, building production ETL/ELT pipelines, with strong Python and advanced SQL.
• Snowflake depth: schema and view design, MERGE and history-table patterns, bulk loading and external stages, role-based access, masking policies, warehouse sizing, and query profiling.
• Mandatory AWS data services experience in production: serverless compute, object storage, orchestration, CDC, NoSQL, IAM.
• Infrastructure-as-code and release automation: CloudFormation or Terraform, Git branching strategies, and CI/CD pipelines.
• Experience ingesting from heterogeneous sources: relational DBs, ERP/CRM, SaaS APIs, flat files.
• Data modeling for analytics: dimensional and denormalized models, conformed layers, raw/hub/mart.

Responsibilities

• Design, build, and operate metadata-driven ingestion and egress pipelines into Snowflake using a shared AWS framework.
• Own end-to-end delivery of features from requirements to production within multi-environment CI/CD.
• Build governed consumption layers in Snowflake with masking and data-quality checks.
• Extend and harden libraries and frameworks for onboarding sources via configuration.
• Define data-quality and reconciliation standards with SLA and freshness monitoring.
• Lead production readiness and support escalations with onshore and offshore teams.
• Migrate legacy code into domain-owned repos with CI/CD and catalog metadata.
• Use AI-assisted development to raise throughput while maintaining review/testing rigor.
• Partner with Product Owners, architects, and AI teams to create reliable datasets for BI and AI workloads.
• Mentor junior engineers and contribute to shared data ingestion and governance standards.
• Create documentation, runbooks, and release-train artifacts.

Skills

Python

Advanced SQL

Data Modeling

Mentoring

Agile

Education

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

Tools

Snowflake

AWS

Terraform/CloudFormation

Git CI/CD

dbt

Apache Airflow

Job description

Cox Automotive's Enterprise Platforms Data & Analytics organization owns the pipelines, Snowflake data layers, and governed data products that feed Finance, Sales, Marketing, Service, and the company's AI initiatives.

Data lands in Snowflake from dozens of enterprise sources through a metadata-driven AWS framework, is modeled into conformed and mart layers, and is exposed to BI tools, downstream applications, and AI agents under strict governance and PII controls.