Data Engineer: ETL to Warehouse for Manufacturing

KLA Industries, Inc.

Pittsburgh (Allegheny County)

Hybrid

USD 90,000 - 140,000

Full time

2 days ago

Be an early applicant

Get a reply from this recruiter

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

KLA Industries, Inc. in Pittsburgh is seeking a hands-on Data Engineer to build pipelines and a robust data warehouse foundation for reliable reporting and smarter business decisions. You will collaborate with BI teams and stakeholders to deliver trusted data for operational insights and reporting.

The role emphasizes SQL development, Oracle integration, and manufacturing-oriented data environments, with on-site work in Pittsburgh and two remote days per month after ramp-up.

Qualifications

5+ years in data engineering, ETL/ELT, or related role.
Strong SQL development and performance tuning.
Experience with Oracle databases and data warehousing fundamentals.
Able to troubleshoot pipeline failures with minimal direction.
Bachelor’s degree in a related field or equivalent professional experience.

Responsibilities

Design, build, and optimize ETL/ELT pipelines to a data warehouse.
Integrate data from Oracle, Ross ERP, D365 Finance & Operations, and others.
Write and tune complex SQL queries, stored procedures, scripts.
Monitor data loads and diagnose failures.
Strengthen data quality with validation, logging, and error handling.
Document data flows and contribute to warehouse architecture.

Skills

SQL development

Data integration

ETL/ELT

Performance tuning

Data warehousing

Oracle

Education

Bachelor's degree

Tools

WhereScape RED

TimeXtender

Microsoft Fabric

Dataverse

SSIS

Informatica

Power BI

Job description

The role emphasizes SQL development, Oracle integration, and manufacturing-oriented data environments, with on-site work in Pittsburgh and two remote days per month after ramp-up.

Get your free, confidential resume review.

or drag and drop your file here.