Data Engineer - On-Site Pipelines for Smart Manufacturing

Soap Creek Resources

Pittsburgh (Allegheny County)

On-site

USD 90,000 - 140,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

Soap Creek Resources in Pittsburgh, PA is seeking a hands-on Data Engineer who loves turning complex, disconnected data into reliable intelligence. You will build the pipelines and warehouse foundations that power meaningful reporting and better business decisions.

Design, build, and optimize ETL/ELT processes, integrate Oracle, Ross ERP, Microsoft Dynamics 365, and other systems; write high‑performing SQL and procedures; monitor loads; ensure data quality; and collaborate with BI to deliver

Qualifications

5+ years in data engineering, ETL development, or related role.
Strong hands-on SQL development and performance-tuning skills.
Experience with Oracle databases and data warehousing fundamentals.
Ability to troubleshoot pipeline failures and data accuracy issues independently.
Bachelor’s degree or equivalent professional experience.

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.
Document data flows and transformation logic; contribute to warehouse architecture and code reviews.