On-Site Data Engineer: ETL/DW for Manufacturing

Accounting Search; Pittsburgh (Allegheny County); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Accounting Search seeks a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse in a manufacturing-oriented environment. You will integrate data from Oracle and ERP systems, write complex SQL, and monitor data loads to ensure reliability.

The role emphasizes data quality, collaboration with BI professionals, and contributing to warehouse architecture. Pittsburgh-based with on-site emphasis and limited remote days after ramp-up.

Qualifications

• 5+ years in data engineering or ETL development
• Strong SQL development and performance tuning
• Experience with Oracle databases and data warehousing 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 enterprise data warehouse
• Integrate data from Oracle, Ross ERP, Dynamics 365 Finance & Operations, and other systems
• Write and tune complex SQL queries and stored procedures
• Monitor data loads and diagnose failures
• Improve data quality through validation and logging
• Collaborate with BI developers to deliver trusted reporting data
• Document data flows and contribute to warehouse architecture

Skills

SQL development

Performance tuning

ETL/ELT development

Oracle databases

Data warehousing fundamentals

Education

Bachelor’s degree

Tools

WhereScape RED

TimeXtender

Microsoft Fabric

Lakehouse

Dataverse

SSIS

Informatica

Power BI

DBA experience

Job description

Accounting Search seeks a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse in a manufacturing-oriented environment. You will integrate data from Oracle and ERP systems, write complex SQL, and monitor data loads to ensure reliability.

The role emphasizes data quality, collaboration with BI professionals, and contributing to warehouse architecture. Pittsburgh-based with on-site emphasis and limited remote days after ramp-up.