Sr Data Engineer
Cox Automotive6 days ago
Atlanta, GA, USASenior
Responsibilities
- Design, build, and operate metadata-driven pipelines that ingest data from enterprise applications, databases, third-party APIs, and files into Snowflake through AWS.
- Deliver end-to-end data features including source onboarding, raw-to-hub modeling, SQL transformations, validation, and controlled multi-environment release.
- Build governed Snowflake consumption layers including conformed views, business models, marts, role-based access, PII masking, and data-quality verification.
- Extend shared libraries and frameworks for SLA monitoring, asset registration, alerting, connection management, and configuration-driven code generation.
- Define and enforce reconciliation, validation, peer-review, data-quality, freshness, duplicate, orphan, and row-count checks.
- Lead production readiness and troubleshoot stale or partial tables, replication and ingestion failures, permissions, authentication, and reporting issues.
- Migrate legacy code into domain-owned repositories with CI/CD, clear ownership, and catalog metadata.
- Use AI-assisted development responsibly and help establish team guardrails for reusable skills, agents, testing, and review.
- Partner with product owners, architects, business teams, and AI teams to deliver documented and governed datasets.
- Mentor junior and offshore engineers, review pull requests, contribute to engineering standards, and maintain documentation, runbooks, and release-train work items.
Requirements
- Currently authorized to work in the United States for any employer without current or future sponsorship; OPT, CPT, STEM/OPT, and visa sponsorship are not accepted.
- Located in Atlanta, Georgia, or willing to relocate at personal expense.
- Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent practical experience.
- At least 4 years of data engineering experience building production ETL/ELT pipelines, with strong Python and advanced SQL.
- Deep Snowflake experience with schema and view design, MERGE and history-table patterns, bulk loading, external stages, role-based access, masking policies, warehouse sizing, and query profiling.
- Strong production experience with AWS data services covering serverless compute, object storage, orchestration, database migration and change data capture, NoSQL, query and catalog services, event scheduling, secrets management, and IAM.
- Experience with CloudFormation or Terraform, Git branching strategies, and automated deployment of database objects.
- Experience ingesting heterogeneous data from relational databases, change data capture, ERP and CRM systems, SaaS APIs, and flat files.
- Knowledge of dimensional, denormalized, conformed, raw, hub, and mart data modeling for analytics.
- Experience with data-quality validation, reconciliation, SLA and freshness monitoring, alerting, observability, and root-cause analysis.
- Knowledge of PII identification and masking, least-privilege access, metadata, lineage, and data governance practices.
- Ability to work in an Agile Release Train, use an Agile tracking tool, write user stories and acceptance criteria, and communicate status and risk.
- Experience mentoring engineers and reviewing code across onshore and offshore teams.
- Preferred: AI-assisted engineering tools, spec-driven development, reusable skills or agents, Snowflake AI features, dynamic tables, Model Context Protocol, dbt, Apache Airflow, data catalog and governance tooling, BI semantic layers, relevant domain knowledge, AWS or SnowPro certifications, and large-scale migration experience.
Benefits
- Atlanta, Georgia location or relocation at the employee’s own expense.
- The posting does not state compensation, insurance, retirement, leave, or other benefits.
About Cox Automotive
Cox Automotive is the world’s largest automotive services and technology provider. Fueled by the largest breadth of first- and third-party data fed by 2.3 billion online interactions a year, Cox Automotive tailors leading solutions for car shoppers, auto manufacturers, dealers, lenders and fleets. The company has 29,000+ employees on four continents and a portfolio of industry-leading brands that include Autotrader®, Kelley Blue Book®, Manheim®, vAuto®, Dealertrack®, NextGear Capital™, CentralDispatch® and Cox Fleet®. Cox Automotive is a subsidiary of Cox Enterprises Inc., a privately owned, Atlanta-based company with $23 billion in annual revenue. Cox Automotive has been included on Glassdoor’s Best Companies in Tech & AI 2026 and Best Place to Work in 2026 lists.