Foundry Data Integrations Engineer II — Ingest & API Pipelines

Lear Corporation; Southfield (MI); On-site; USD 110,000 - 150,000; Full time

Job summary

Lear Corporation is seeking a Foundry Data Ingestions Engineer to design, build, and support Palantir Foundry ingestion pipelines, enabling reliable data across Lear's global manufacturing, supply chain, and admin environments.

You will optimize SQL statements, integrate Excel/CSV/PDF sources, and manage REST APIs and event-driven data flows while collaborating with engineering, finance, operations, and IT to support digital transformation initiatives.

Qualifications

• Bachelor's degree in computer science, engineering, data science, or related field.
• 1+ year of experience working with Palantir Foundry.
• 2+ years of experience in data engineering or ETL roles with heavy SQL usage.
• Strong proficiency in SQL including complex joins, aggregations, and performance tuning.
• Hands-on experience integrating Excel files, PDFs, APIs, and relational databases.
• Experience with REST APIs and structured JSON data.
• Familiarity with webhooks and event-driven integration patterns.
• Experience with Python and Spark SQL.
• Familiarity with Git-based workflows, agile development, and production support models.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• Designing, building, and maintaining Palantir Foundry ingestion pipelines, data connections, and source-to-prepared datasets.
• Developing, optimizing, and maintaining SQL statements for extraction, transformation, aggregation, and ingestion performance.
• Integrating data from Excel, CSV, and PDF sources.
• Integrating relational databases such as DB2, SQL Server, PostgreSQL, MySQL, Progress, Oracle, and MariaDB.
• Building and supporting API-based integrations using REST and JSON.
• Supporting event-driven integrations including webhooks and trigger-based ingestion patterns.
• Monitoring ingestion health, pipeline execution, data freshness, and schema changes.
• Troubleshooting ingestion failures, connectivity issues, and data quality problems.
• Documenting integration logic, data flows, and procedures.
• Partnering with engineering, finance, operations, and IT to onboard new data sources.

Skills

SQL proficiency

Palantir Foundry

Python

Spark SQL

REST APIs

JSON data

Git workflows

Agile development

Data engineering

Communication

Education

Bachelor's degree in CS/Engineering/Data Science

Tools

DB2

SQL Server

PostgreSQL

MySQL

Oracle

MariaDB

Job description

Lear Corporation is seeking a Foundry Data Ingestions Engineer to design, build, and support Palantir Foundry ingestion pipelines, enabling reliable data across Lear's global manufacturing, supply chain, and admin environments.

You will optimize SQL statements, integrate Excel/CSV/PDF sources, and manage REST APIs and event-driven data flows while collaborating with engineering, finance, operations, and IT to support digital transformation initiatives.