Sr Data Engineer

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

Compensation

Compensation includes a base salary in the range of $101,500.00 - $169,100.00. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate’s knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program.

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 growing portfolio of 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. This engineer is a hands‑on technical leader on one of the Data & Analytics delivery pods. You will build and ship production pipelines and governed views, raise the quality bar through validation and peer review, help production support teams resolve complex data incidents, and mentor a mixed onshore and offshore team. The work sits at the point where data engineering meets AI: the datasets you deliver are the foundation for BI today and for AI-assisted analytics tomorrow, and you will use AI-assisted development responsibly to deliver them faster.

WHAT YOU'LL DO

• Design, build, and operate metadata-driven ingestion and egress pipelines that land data from enterprise applications, databases, and third‑party APIs into Snowflake, using a shared, configuration-driven AWS framework (serverless compute, orchestration, change data capture, object storage, metadata registries, and infrastructure-as-code)
• Own end‑to‑end delivery of features from refined requirement to production: source onboarding, raw-to-hub modeling, SQL transformations, validation, and release through a controlled multi‑environment CI/CD flow
• Build governed consumption layers in Snowflake: conformed and base views, business‑specific models, marts, and role‑based access, with PII masking and data‑quality verification shipped alongside every view
• Extend and harden shared libraries and frameworks (SLA monitoring, asset registration, alerting, connection management, and code generation) so new sources onboard through configuration rather than custom code
• Define and enforce data‑quality, reconciliation, and peer‑validation standards, including row‑count, orphan, duplicate, and freshness checks that gate every promotion to production
• Lead production readiness and support escalations alongside production support teams: diagnose stale or partially loaded tables, replication and ingestion failures, role and permission regressions, authentication changes, and month‑end reporting issues
• Drive the migration of legacy code into domain‑owned repositories with clear ownership, CI/CD, and catalog metadata
• Use AI‑assisted development (coding assistants, spec‑driven development, reusable skills) to raise throughput without lowering the review and testing bar, and help formalize guardrails for the team
• Partner with Product Owners, architects, and consuming business and AI teams to translate business questions into reliable, documented, governed datasets that serve both BI and AI workloads
• Mentor junior and offshore engineers, review pull requests against architecture and design standards, and contribute to shared standards for ingestion, modeling, governance, and cataloging
• Produce documentation, runbooks, and operational playbooks, and keep work items, features, and dependencies accurate for the Release Train

WHO YOU ARE

Required Skills Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship. No OPT, CPT, STEM/OPT or visa sponsorship now or in future. Must be located in Atlanta GA or be willing to relocate at own expense Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent practical experience Must have a 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 REQUIRED: strong experience with AWS data services in production: serverless compute, object storage, workflow orchestration, database migration/CDC, NoSQL, query and catalog services, event scheduling, secrets management, and IAM Infrastructure‑as‑code and release automation: CloudFormation or Terraform, Git branching strategies, and CI/CD pipelines with automated deployment of database objects Ingesting from heterogeneous sources: relational databases and change data capture, ERP and CRM systems, SaaS APIs, and flat files Data modeling for analytics: dimensional and denormalized models, conformed layers, and the difference between raw, hub, and mart responsibilities Data quality and observability: validation frameworks, reconciliation, SLA and freshness monitoring, alerting, and root‑cause analysis on late or partial loads Data security and governance: PII identification and masking, least‑privilege access, and metadata and lineage practices Ability to work in an Agile Release Train with 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; comfortable leading work across onshore and offshore teams Preferred Experience 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 dbt, Apache Airflow or similar orchestration and integration platforms Experience with data catalog and governance tooling BI semantic‑layer experience and an understanding of how data models feed self‑service analytics Domain knowledge in automotive, finance, sales, marketing, or contact‑center data AWS certifications (Solutions Architect, Data Engineer) or SnowPro certification Experience in large‑scale platform migrations and legacy‑code modernization Drug Testing To be employed in this role, you’ll need to clear a pre‑employment drug test. Cox Automotive does not currently administer a pre‑employment drug test for marijuana for this position. However, we are a drug‑free workplace, so the possession, use or being under the influence of drugs illegal under federal or state law during work hours, on company property and/or in company vehicles is prohibited.

Benefits

• The Company offers eligible employees the flexibility to take as much vacation with pay as they deem consistent with their duties, the company’s needs, and its obligations
• Seven paid holidays throughout the calendar year
• Up to 160 hours of paid wellness annually for their own wellness or that of family members
• Employees are also eligible for additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave
• Health care insurance (medical, dental, vision)
• Retirement planning (401(k))
• Paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO)
• For more details on what benefits you may be offered, visit our benefits page

About Us

Through groundbreaking technology and a commitment to stellar experiences for drivers and dealers alike, Cox Automotive employees are transforming the way the world buys, owns, sells – or simply uses – cars. Cox Automotive employees get to work on iconic consumer brands like Autotrader and Kelley Blue Book and industry‑leading dealer‑facing companies like vAuto and Manheim, all while enjoying the people‑centered atmosphere that is central to our life at Cox. Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page. Cox is an Equal Employment Opportunity employer – All qualified applicants/employees will receive consideration for employment without regard to that individual’s age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Cox provides reasonable accommodations when requested by a qualified applicant or employee with disability, unless such accommodations would cause an undue hardship. EOE, including disability/vets Cox brings together the world’s greatest minds to help breathe life into new possibilities – and drive innovation for a better future. That’s why we look for individuals who share our pioneering spirit, have imaginative ideas and are fearless when it comes to tackling the world’s biggest challenges. Our people love technology – and they love making a difference. They have a passion for finding new solutions and working with brilliant colleagues. Every day they dedicate themselves to a huge range of exciting projects, contributing to the Cox vision around the globe. From engineering new sustainability solutions that conserve water and energy to creating the infrastructure for the smart cities of tomorrow, there’s no challenge too great for our pioneers. And there’s no shortage of opportunities for you to make a difference. Come and experience the dynamic, collaborative and creative environments where your ideas are welcome and new discoveries are waiting. To help you grow to your full potential, we strive to support our employees in their career aspirations and promote the freedom to explore new horizons.