Data Engineer

KLA Industries, Inc.; Pittsburgh (Allegheny County); Hybrid; USD 90,000 - 140,000; Full time

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

Data Engineer

Build the Data Foundation Behind Smarter Decisions

Pittsburgh, PA | Full-Time | Primarily On-Site

Our client is seeking a hands-on Data Engineer who loves turning complex, disconnected data into reliable intelligence. This is an opportunity to make a visible impact on a growing industrial organization—building the pipelines and warehouse foundations that power meaningful reporting and better business decisions.

Why This Opportunity Stands Out

Own critical data pipelines from source systems to analytics-ready datasets.

Work closely with a business intelligence team on high-impact reporting initiatives.

Bring your SQL and Oracle expertise to real operational challenges in a manufacturing-oriented environment.

What You’ll Do

Design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse.

Integrate data from Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and other systems.

Write and tune complex SQL queries, stored procedures, and scripts for performance and reliability.

Monitor data loads, diagnose failures, and resolve discrepancies independently.

Strengthen data quality through validation, logging, and error handling.

Partner with BI developers, analysts, and business stakeholders to deliver trusted reporting data.

Document data flows and transformation logic; contribute to warehouse architecture, dimensional modeling, and code reviews.

What You Bring

5+ years in data engineering, ETL development, or a closely related role.

Strong hands-on SQL development and performance-tuning skills.

Experience with Oracle databases and sound ETL/ELT and data warehousing fundamentals.

Ability to troubleshoot pipeline failures and data accuracy issues with minimal direction.

Bachelor’s degree in a related discipline or equivalent professional experience.

Extra Experience We’d Love to See

WhereScape RED or TimeXtender; Microsoft Fabric, Lakehouse, or Dataverse.

D365 Finance & Operations, SSIS, Informatica, Power BI, or DBA experience.

Dimensional modeling and manufacturing, mining, or industrial data environments.

Work Arrangement

This position is based on-site in Pittsburgh, with two remote days per month available after the initial ramp-up period.