Senior Data Engineer (Foundations)

Posted 7 Days Ago
Auburn Hills, MI, USA
In-Office
Senior level
Automotive
The Role
Designs and maintains a shared data ingestion platform using Python, dlt, dbt-core, and Airflow. Builds scalable pipelines for structured and unstructured data, implements quality and lineage controls, simplifies platform architecture, and supports cloud infrastructure across AWS and Azure. The role also improves CI/CD, observability, reliability, and developer productivity through AI tooling, documentation, mentoring, and technical enablement.
Summary Generated by Built In
Job Summary & Responsibilities

The Senior Data Engineer – Platform Foundation is a hands-on, senior-level contributor embedded in the Foundations squad. You will design, build, and evolve the shared ingestion platform that underpins data delivery across the company. The platform is the product — your job is to make it reliable, extensible, and easy for other teams to adopt. 

 

The Foundations squad operates across three pillars: simplifying the overall data platform landscape by reducing complexity and consolidating redundant patterns; enabling structured and unstructured data ingestion at scale; and supporting the exposure of data products to consumers across the organization. You contribute to all three — making architectural decisions, writing production code, and enabling other teams through documentation and hands-on support. 

 

Platform Foundation Development

  • Design and implement reusable ingestion components using dlt and dbt-core, covering both structured and unstructured data sources, handling high-volume, append-heavy, and schema-drifting patterns
  • Own the Airflow platform end-to-end: extend and maintain DAGs and shared operators, handle deployments and version upgrades, and provide hands-on support to consuming teams
  • Ensure incremental loading strategies, data quality checks, and lineage metadata are first-class outputs of every pipeline

 

Platform Simplification & Architecture

  • Identify and eliminate redundant ingestion patterns across consuming teams, drive standardization onto shared Platform Foundation components
  • Collaborate with Solution Architects to evolve the platform architecture in response to new data sources and shifting business requirements
  • Support data product exposure: define and implement governed interfaces that make data reliably accessible to internal consumers
  • Contribute to Terraform-managed infrastructure; participate in multi-cloud (AWS / Azure) deployment patterns

 

AI Tooling & Developer Productivity

  • Actively use and evaluate AI-assisted development tools (GitHub Copilot, Claude Code, etc.) to accelerate platform Foundation delivery
  • Champion AI tooling adoption within the squad; share best practices and guardrails around AI-generated code review
  • Explore AI-powered capabilities (RAG pipelines, LLM-assisted data cataloguing) for internal platform documentation and self-service enablement

 

DevOps & Reliability

  • Maintain and improve CI/CD pipelines (TeamCity, GitHub Actions) for platform Foundation components
  • Define and enforce observability standards: DAG/Task-level alerting, SLA tracking
  • Participate in on-call rotation for critical ingestion pipelines; drive post-incident improvements

 

Team Enablement & Stakeholder Management

  • Produce platform Foundation documentation, runbooks, and enablement materials for consuming squads
  • Translate ambiguous or moving business requirements into concrete technical designs — comfortable challenging scope when needed
  • Mentor mid-level engineers; participate in hiring and technical assessments

 

Preferred Qualifications

Basic Qualifications: 

  • Bachelor's degree in Business, Information Systems, Data/Analytics, Computer Science, or related field
  • Minimum 5 years in data engineering roles, with at least 2 years in a senior / platform-level position 
  • Proven track record building production ingestion and transformation pipelines at scale 
  • Experience contributing to a shared platform or internal developer tooling consumed by multiple teams 

 

Core Technical Skills:

  • Python: idiomatic, testable, production-grade code — not just scripting 
  • dbt-core: advanced modelling (custom materializations), testing, documentation, packages 
  • Apache Airflow: DAG design patterns, custom operators, dynamic task mapping, SLA management 
  • Cloud data platforms: comfortable with one or more major cloud warehouses (Snowflake, BigQuery, Databricks, Microsoft Fabric) 
  • SQL: complex analytical queries, window functions, query profiling 
  • Git, CI/CD: trunk-based development, automated testing gates, pipeline-as-code 

 

AI & Modern Tooling: 

  • Daily user of AI coding assistants (Copilot, Claude Code or equivalent) 
  • Understands the limits of AI-generated code — applies rigorous review, not blind trust 
  • Interest in LLM-powered data tooling (RAG pipelines, Cortex, semantic layers) is a plus 

 

Skills Required

  • Bachelor's degree in Business, Information Systems, Data/Analytics, Computer Science, or a related field
  • Minimum 5 years of experience in data engineering roles
  • At least 2 years of experience in a senior or platform-level position
  • Experience building production ingestion and transformation pipelines at scale
  • Experience contributing to a shared platform or internal developer tooling consumed by multiple teams
  • Production-grade Python development, including idiomatic and testable code
  • Advanced dbt-core modeling, custom materializations, testing, documentation, and packages
  • Apache Airflow experience with DAG design, custom operators, dynamic task mapping, and SLA management
  • Experience with one or more cloud data platforms: Snowflake, BigQuery, Databricks, or Microsoft Fabric
  • Advanced SQL, including analytical queries, window functions, and query profiling
  • Git and CI/CD experience, including trunk-based development, automated testing gates, and pipeline-as-code
  • Daily use of AI coding assistants such as GitHub Copilot, Claude Code, or equivalent
  • Ability to rigorously review AI-generated code and understand its limitations
  • Interest in LLM-powered data tooling, RAG pipelines, Cortex, or semantic layers

Stellantis Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Stellantis and has not been reviewed or approved by Stellantis.

  • Healthcare Strength — Benefits are described as broad with strong medical, dental, and vision coverage, plus life insurance, disability, wellness resources, and employee assistance programs. Coverage breadth appears especially robust for full-time roles in North America.
  • Retirement Support — Retirement savings are highlighted through 401(k) matching and company contributions in eligible roles, alongside attractive pension and retirement terms for many union-represented manufacturing employees. These elements are positioned as a core strength of the overall package.
  • Equity Value & Accessibility — Employee share ownership is emphasized, with the share-purchase program expanded to nearly the entire workforce and broad participation reported. This accessibility creates an additional wealth-building channel beyond base pay.

Stellantis Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Auburn Hills, MI
104,031 Employees

What We Do

Our storied and iconic brands embody the passion of their visionary founders and today’s customers in their innovative products and services: they include Abarth, Alfa Romeo, Chrysler, Citroën, Dodge, DS Automobiles, Fiat, Jeep®, Lancia, Maserati, Opel, Peugeot, Ram, Vauxhall and mobility brands Free2move and Leasys. Powered by our diversity, we lead the way the world moves – aspiring to become the greatest sustainable mobility tech company, not the biggest, while creating added value for all stakeholders as well as the communities in which we operate.

Similar Jobs

Acquia Logo Acquia

Senior Product Manager

AdTech • Cloud • Marketing Tech • Productivity • Software • Analytics • Automation
Easy Apply
Remote or Hybrid
United States
1100 Employees
160K-170K Annually

Rocket Logo Rocket

Systems Analyst

Fintech • Real Estate • Sales • Financial Services
In-Office
Detroit, MI, USA
14200 Employees

LogicMonitor Logo LogicMonitor

Senior Account Executive

Artificial Intelligence • Cloud • Information Technology • Machine Learning • Software
Easy Apply
Remote or Hybrid
U.S.
1100 Employees
116K-155K Annually

Magna International Logo Magna International

Program Manager

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
Grand Rapids, MI, USA
171000 Employees

Similar Companies Hiring

HERE Technologies Thumbnail
Artificial Intelligence • Automotive • Computer Vision • Information Technology • Internet of Things • Logistics • Software
Amsterdam, NL
6000 Employees
Ford Energy Thumbnail
Automotive • Software • Energy • Utilities • Manufacturing • Renewable Energy
US
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account