Data Engineer - Manufacturing ETL and Data Warehouse

Data Engineer, Manufacturing ETL and Data Warehouse

Pittsburgh, PA (Onsite, 2 remote days a month after ramp-up)

Build the pipelines and warehouse that power reporting for a growing industrial manufacturer. You will integrate Oracle, D365 F&O, and ERP data into an enterprise data warehouse and work closely with the BI team.

Must-Haves

• 5+ years in data engineering, ETL development, or a closely related role
• Strong hands-on SQL development and performance tuning
• Oracle database experience
• Solid ETL/ELT and data warehousing fundamentals
• Able to troubleshoot pipeline failures and data issues independently
• Bachelor's degree or equivalent experience

What You'll Do

• Design, build, and optimize ETL/ELT pipelines into the enterprise data warehouse
• Integrate data from Oracle, Ross ERP, D365 F&O, and other systems
• Write and tune complex SQL, stored procedures, and scripts
• Monitor loads, fix failures, and resolve data discrepancies
• Strengthen data quality with validation, logging, and error handling
• Contribute to warehouse architecture, dimensional modeling, and code reviews

Nice-to-Haves

• WhereScape RED or TimeXtender
• Microsoft Fabric, Lakehouse, or Dataverse
• D365 F&O, SSIS, Informatica, Power BI, or DBA experience
• Manufacturing, mining, or industrial data background

What You'll Get

• $120,000 to $130,000 base salary
• Visible impact on company-wide reporting

About the Company

A growing, multi-site industrial manufacturer based in the Pittsburgh area.