Senior Data Engineer: Snowflake, AWS & AI Pipelines

Cox Automotive; Atlanta (GA); On-site; USD 102,000 - 169,000; Full time

Job summary

Cox Automotive’s Enterprise Platforms Data & Analytics group is seeking a hands-on data engineering leader to design, build, and operate production data pipelines and governed views in Snowflake. You will collaborate with onshore and offshore teams to ensure high data quality and robust governance across BI and AI workloads.

You will own end-to-end delivery from requirements to production, extend shared libraries, and mentor engineers while leveraging AI-assisted development responsibly.

Qualifications

• Bachelor's degree in CS, IS, or equivalent
• 4+ years in data engineering building production ETL/ELT pipelines with Python and SQL
• Strong AWS data services in production: serverless, storage, orchestration, CDC, IAM
• Snowflake: schema/view design, masking, RBAC, performance tuning
• IaC and release automation: CloudFormation or Terraform; CI/CD pipelines
• Ingesting from heterogeneous sources: relational DBs, ERP/CRM, SaaS APIs, flat files
• Data modeling for analytics: dimensional/denormalized, conformed layers
• Data quality and observability: validation, reconciliation, SLA, freshness monitoring
• Data security and governance: PII masking, least privilege, lineage

Responsibilities

• Design, build, and operate metadata-driven ingestion and egress pipelines into Snowflake via an AWS framework
• Own end-to-end delivery from requirements to production with CI/CD
• Build governed Snowflake layers: conformed/base views, models, marts, RBAC
• Harden shared libraries and frameworks for onboarding sources via config
• Define data-quality standards and gate promotions to production
• Lead production readiness and support escalations with teams
• Migrate legacy code into domain-owned repos with clear ownership
• Use AI-assisted development while maintaining reviews and tests
• Collaborate with Product Owners and AI teams to deliver governed datasets
• Mentor engineers and review code across onshore/offshore
• Produce docs, runbooks, and release-train artifacts

Skills

Python

SQL

Snowflake

AWS

ETL/ELT

Data modeling

Data quality

CI/CD

Agile

Mentoring

Education

Bachelor's degree or equivalent

Tools

dbt

Apache Airflow

Snowflake

Job description

Cox Automotive’s Enterprise Platforms Data & Analytics group is seeking a hands-on data engineering leader to design, build, and operate production data pipelines and governed views in Snowflake. You will collaborate with onshore and offshore teams to ensure high data quality and robust governance across BI and AI workloads.

You will own end-to-end delivery from requirements to production, extend shared libraries, and mentor engineers while leveraging AI-assisted development responsibly.