Senior Data Engineer (Foundations)

Stellantis
Lake Angelus, MI, United States
1 day ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
2 years minimum
Working hours
Regular working hours
Job source

Tech stack

Artificial Intelligence Airflow Amazon Web Services Data Analysis ARM Architecture Automation of Tests Microsoft Azure BigQuery Code Generation Information Systems Continuous Integration Directed Acyclic Graph (Directed Graphs)
+27 more
Information Engineering Software Design Patterns DevOps Programming Tools Github Python (Programming Language) Software Architecture Cloud Services Microsoft Copilot SQL Databases Unstructured Data Trunk-based Development GitHub Copilot Retrieval-Augmented Generation Large Language Models Claude Code Snowflake Multi-Cloud AI Coding Agents Git Microsoft Fabric Information Technology Production Code Teamcity Data Delivery Terraform Databricks

Job description

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

Requirements

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

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…