Foundry Data Integrations Engineer II

Lear Corporation
Southfield, United States of America
10 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior

Job location

Southfield, United States of America

Tech stack

Microsoft Excel
API
Agile Methodologies
Information Engineering
Data Integration
ETL
IBM DB2
Relational Databases
Database Queries
Hive
JSON
Python
PostgreSQL
MariaDB
Microsoft SQL Server
MySQL
Oracle Applications
Performance Tuning
SQL Databases
Data Streaming
Systems Integration
Data Ingestion
Git Flow
Information Technology
Api Design
REST
Webhooks

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

Requirements

  • 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

About the company

Lear For You We work hard for the people who work for us. We champion our teams. We foster collaboration, inclusion, respect and excellence. What we are trying to say is we want to be more for you. We are your path to a better career, a better future, and a better you. Our teams have invented groundbreaking technologies, flawlessly manufactured millions of products and earned a long list of awards. Year after year, we are one of the World's Most Admired Companies. Our teams are the secret to our success. They are empowered, inventive and inclusive. Passionate about their craft. Driven to succeed. Because we all understand that we must work together to win. Are you ready for a better career? A better future? We're Lear For You. Lear For You We work hard for the people who work for us. We champion our teams and foster collaboration, inclusion, respect and excellence. Because we want to be more for you. A path to a better career. A better future. Our teams have invented groundbreaking technologies, manufactured millions of products and earned a long list of awards. Year after year, we're named one of the World's Most Admired Companies. They're the secret to our success-empowered, inventive and inclusive. Passionate about their craft. Driven to succeed. Because we win together. Are you ready for a better career? A better future?

Apply for this position