Data Engineer - Manufacturing ETL and Data Warehouse
Job Description
Data Engineer, Manufacturing ETL and Data Warehouse
\n
Pittsburgh, PA (Onsite, 2 remote days a month after ramp-up)
\n
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.
\n
Must-Haves
\n
- \n
- 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
\n
\n
\n
\n
\n
\n
\n
What You'll Do
\n
- \n
- 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
\n
\n
\n
\n
\n
\n
\n
Nice-to-Haves
\n
- \n
- 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
\n
\n
\n
\n
\n
What You'll Get
\n
- \n
- $120,000 to $130,000 base salary
- Visible impact on company-wide reporting
\n
\n
\n
About the Company
\n
A growing, multi-site industrial manufacturer based in the Pittsburgh area.