Sr Data Engineer
Cox Enterprises, Inc.7 days ago
Atlanta, GA, USASenior
Base Salary
$102k - $169k/yr
Responsibilities
- Design, build, and operate metadata-driven ingestion and egress pipelines into Snowflake using shared AWS frameworks.
- Own end-to-end delivery from source onboarding and data modeling through SQL transformation, validation, and controlled production release.
- Build governed Snowflake views, conformed layers, 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 source onboarding.
- Define and enforce reconciliation, validation, peer-review, data-quality, freshness, and promotion standards.
- Lead production readiness and resolve escalations involving stale or partial loads, replication and ingestion failures, permissions, authentication, and reporting issues.
- Drive legacy-code migration into domain-owned repositories with clear ownership, CI/CD, and catalog metadata.
- Use AI-assisted development responsibly and help establish team guardrails for coding, review, and testing.
- Partner with product, architecture, business, and AI teams to deliver reliable, documented, governed datasets.
- Mentor junior and offshore engineers, review pull requests, contribute to shared 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 four years of data engineering experience building production ETL/ELT pipelines.
- Strong Python and advanced SQL skills with deep Snowflake experience, including schemas, views, MERGE and history-table patterns, external stages, access controls, masking, warehouse sizing, and query profiling.
- Production experience with AWS data services, including compute, 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, and automated database-object deployment pipelines.
- Experience ingesting relational, ERP, CRM, SaaS API, and flat-file data and developing dimensional, denormalized, conformed, raw, hub, and mart models.
- Experience with data-quality validation, reconciliation, observability, SLA and freshness monitoring, alerting, and root-cause analysis.
- Knowledge of PII 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, reviewing code, and leading work across onshore and offshore teams.
- Preferred qualifications include AI-assisted engineering and spec-driven development, Snowflake AI features, dynamic tables, Model Context Protocol access patterns, dbt, Apache Airflow, catalog and governance tools, BI semantic layers, relevant domain knowledge, AWS or SnowPro certifications, and large-scale platform migration experience.
Benefits
- Hybrid work arrangement with the ability to work remotely part of the week.
- Eligible employees may receive flexible paid vacation, seven paid holidays, and up to 160 hours of paid wellness time annually.
- Additional leave may include bereavement, voting, jury duty, volunteer, military, parental, sick, and other paid time off.
- Benefits may include medical, dental, and vision insurance and 401(k) retirement planning.
- The role requires a pre-employment drug test, excluding marijuana testing for this position.
About Cox Enterprises, Inc.
Cox Enterprises is a privately held, Atlanta-based company operating businesses in broadband and automotive services. Through Cox Communications, it provides internet, voice, and video to residential and business customers; through Cox Automotive, it runs marketplaces and dealer software including Autotrader, Kelley Blue Book, and Manheim. Founded in 1898, the family-owned company also invests in sustainable technologies and other growth ventures.