Sr Data Engineer

Cox Communications • Atlanta, GA

2d • Hybrid

About The Position

Cox Automotive’s Enterprise Platforms Data & Analytics organization builds and operates pipelines, Snowflake data layers, and governed data products that support Finance, Sales, Marketing, Service, and AI initiatives. Data arrives from enterprise sources through a metadata-driven AWS framework, is modeled into conformed and mart layers, and is provided to BI tools, downstream applications, and AI agents under governance and PII controls.

The Sr Data Engineer is a hands-on technical leader on a Data & Analytics delivery pod. The role builds production pipelines and governed views, ensures quality through validation and peer review, supports resolution of complex production data incidents, and mentors onshore and offshore engineers. It also uses AI-assisted development responsibly to improve delivery while maintaining review and testing standards.

Requirements

• Must be authorized to work in the United States for any employer without current or future sponsorship; OPT, CPT, STEM/OPT, and visa sponsorship are not available.
• Must be located in Atlanta, Georgia, or be 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 experience in Data Engineering building production ETL/ELT pipelines, with strong Python and advanced SQL.
• Strong Snowflake experience, including schema and view design, MERGE and history-table patterns, bulk loading and external stages, role-based access, masking policies, warehouse sizing, and query profiling.
• Production experience with AWS data services, including serverless compute, object storage, workflow orchestration, database migration and change data capture, NoSQL, query and catalog services, event scheduling, secrets management, and IAM.
• Experience with infrastructure-as-code and release automation using CloudFormation or Terraform, Git branching strategies, and CI/CD pipelines that automate database-object deployment.
• Experience ingesting heterogeneous sources, including relational databases and CDC, ERP and CRM systems, SaaS APIs, and flat files.
• Experience with analytics data modeling, including dimensional and denormalized models, conformed layers, and the roles of raw, hub, and mart layers.
• Experience with data quality and observability, including validation frameworks, reconciliation, SLA and freshness monitoring, alerting, and root-cause analysis of late or partial loads.
• Experience with data security and governance, including PII identification and masking, least-privilege access, and metadata and lineage practices.
• Ability to work in an Agile Release Train using an Agile tracking tool, write clear user stories and acceptance criteria, and communicate status and risk to Product and Engineering leadership.
• Experience mentoring engineers and reviewing code, and comfort leading work across onshore and offshore teams.
• Must clear a pre-employment drug test.

Nice To Haves

• Hands-on experience with AI-assisted engineering tools and spec-driven development, including building reusable skills or agents for data tasks.
• Familiarity with Snowflake AI features, dynamic tables, and Model Context Protocol (MCP) access patterns for exposing governed data to AI agents.
• Experience with dbt, Apache Airflow, or similar orchestration and integration platforms.
• Familiarity with data catalog and governance tooling.
• BI semantic-layer experience and understanding of how data models feed self-service analytics.
• Domain knowledge in automotive, finance, sales, marketing, or contact-center data.
• AWS Solutions Architect or Data Engineer certification, or SnowPro certification.
• Experience with large-scale platform migrations and legacy-code modernization.

Responsibilities

• Design, build, and operate metadata-driven ingestion and egress pipelines that move data from enterprise applications, databases, and third-party APIs into Snowflake using a shared, configuration-driven AWS framework.
• Own feature delivery from refined requirements through production, including source onboarding, raw-to-hub modeling, SQL transformations, validation, and controlled multi-environment CI/CD release.
• Build governed Snowflake consumption layers, including conformed and base views, business-specific models, marts, role-based access, PII masking, and data-quality verification.
• Extend and harden shared libraries and frameworks for SLA monitoring, asset registration, alerting, connection management, and code generation.
• Define and enforce data-quality, reconciliation, and peer-validation standards, including row-count, orphan, duplicate, and freshness checks that gate production promotion.
• Lead production readiness and support escalations with production support teams, diagnosing stale or partially loaded tables, replication and ingestion failures, permission regressions, authentication changes, and reporting issues.
• Drive migration of legacy code into domain-owned repositories with clear ownership, CI/CD, and catalog metadata.
• Use AI-assisted development tools and practices to improve throughput while maintaining review and testing standards, and help formalize team guardrails.
• Partner with Product Owners, architects, and business and AI consumers to turn business questions into reliable, documented, governed datasets for BI and AI workloads.
• Mentor junior and offshore engineers, review pull requests against architecture and design standards, and contribute to shared ingestion, modeling, governance, and cataloging standards.
• Produce documentation, runbooks, and operational playbooks, and maintain accurate work items, features, and dependencies for the Release Train.

Benefits

• Flexible paid vacation.
• Seven paid holidays per calendar year.
• Up to 160 hours of paid wellness time annually for personal or family wellness.
• Bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave.
• Potential eligibility for medical, dental, and vision insurance.
• Potential eligibility for a 401(k) retirement plan.
• Potential eligibility for sick leave, parental leave, flexible vacation or wellness days, and/or PTO.
• Position may be eligible for additional compensation through an incentive program.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior