Industrial Data Engineer - ETL & Data Warehouse

Henderson Group Recruiting

Pittsburgh (Allegheny County)

On-site

USD 110,000 - 160,000

Full time

2 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Henderson Group Recruiting in Pittsburgh, PA, is seeking a hands-on Data Engineer who loves turning complex data into reliable intelligence. You will design and build ETL/ELT pipelines feeding an enterprise data warehouse, integrating Oracle, Ross ERP, and Dynamics 365 Finance & Operations to power trusted reporting.

The role requires 5+ years in data engineering, strong SQL, and data warehousing fundamentals.

Qualifications

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.
Bachelor’s degree in a related discipline or equivalent professional experience.
Ability to troubleshoot pipeline failures and data accuracy issues with minimal direction.

Responsibilities

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.