Pittsburgh Data Engineer: ETL & Data Warehouse Specialist

Key People; Pittsburgh (Allegheny County); On-site; USD 110,000 - 140,000; Full time

Job summary

Key People is seeking a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines that feed an enterprise data warehouse. You will integrate data from Oracle, Ross ERP, and Dynamics 365 Finance & Operations, writing complex SQL and tuning performance in a manufacturing-oriented environment.

You will monitor loads, diagnose issues, and strengthen data quality while collaborating with BI developers and business stakeholders to deliver trusted reporting data.

Qualifications

• 5+ years in data engineering, ETL development, or related role.
• Hands-on SQL development and performance tuning.
• Experience with Oracle databases and ETL/ELT fundamentals.
• Ability to troubleshoot pipeline failures with minimal direction.
• Bachelor’s degree or equivalent professional experience.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines to feed a 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.
• Monitor data loads, diagnose failures, and resolve discrepancies.
• Strengthen data quality through validation, logging, and error handling.
• Document data flows and contribute to warehouse architecture and dimensional modeling.

Skills

SQL development

Performance tuning

ETL/ELT development

Data warehousing fundamentals

Education

Bachelor’s degree or equivalent experience

Tools

Oracle databases

WhereScape RED

TimeXtender

Microsoft Fabric

Power BI

SSIS

Informatica

Dataverse

Job description

Key People is seeking a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines that feed an enterprise data warehouse. You will integrate data from Oracle, Ross ERP, and Dynamics 365 Finance & Operations, writing complex SQL and tuning performance in a manufacturing-oriented environment.

You will monitor loads, diagnose issues, and strengthen data quality while collaborating with BI developers and business stakeholders to deliver trusted reporting data.