Foundry Data Integrations Engineer II

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

Job Description

As a member of the IT Central Foundry Center of Excellence (COE), the Foundry Data Integrations Engineer will be responsible for highly skilled, technical work focused on Foundry Data Ingestions. This role is accountable for designing, building, and supporting enterprise data integrations and ingestion pipelines within Palantir Foundry to ensure reliable, scalable, and production‑ready data across Lear's global manufacturing, supply chain, and administrative environments.

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, validation, and performance‑efficient ingestion
• Integrating data from file‑based sources including Excel spreadsheets, CSV files, and PDF documents
• Integrating relational databases including 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 operational procedures
• Partnering with engineering, finance, operations, and IT teams to onboard new data sources and support digital transformation initiatives

Your Qualifications

• Bachelor's degree in computer science, Engineering, Data Science, or a 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 working with DB2, SQL Server, PostgreSQL, MySQL, Progress, Oracle, and/or MariaDB
• Experience working 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 practices, and production support models
• Strong analytical, problem‑solving, and communication skills

Equal Opportunity Employer

Lear Corporation is committed to fair, meritbased employment practices and equal opportunity.

We provide reasonable accommodations in accordance with applicable law. For assistance during the application process, contact your recruiter directly.