ETL & Warehouse Data Engineer (On-Site, Pittsburgh)

Tom Trese Networking LLC; Pittsburgh (Allegheny County); Hybrid; USD 110.000 - 160.000; Vollzeit

Zusammenfassung

Tom Trese Networking LLC is seeking a hands-on Data Engineer in Pittsburgh, PA to transform disconnected data into reliable intelligence. You will build pipelines and a warehouse foundation powering reporting and better decisions, with on-site emphasis and limited remote days.

You will design ETL/ELT pipelines, integrate Oracle and ERP data, and partner with BI teams to deliver trusted data for analytics. This role requires 5+ years in data engineering and strong SQL skills.

Qualifikationen

• 5+ years in data engineering or related role.
• 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.

Aufgaben

• Design, build, and optimize ETL/ELT pipelines to feed a data warehouse.
• Integrate data from Oracle, Ross ERP, Dynamics 365 Finance & Operations, and others.
• Write and tune complex SQL queries, stored procedures, and scripts.
• Monitor data loads, diagnose failures, and fix discrepancies.
• Improve data quality through validation, logging, and error handling.
• Collaborate with BI developers, analysts, and stakeholders to deliver trusted data.
• Document data flows and contribute to warehouse architecture and modeling.

Kenntnisse

SQL development

Performance tuning

Data integration

Troubleshooting pipelines

Data warehousing fundamentals

Ausbildung

Bachelor's degree or equivalent experience

Tools

Oracle

WhereScape RED

TimeXtender

Microsoft Fabric

Dataverse

SSIS

Informatica

Power BI

Jobbeschreibung

Tom Trese Networking LLC is seeking a hands-on Data Engineer in Pittsburgh, PA to transform disconnected data into reliable intelligence. You will build pipelines and a warehouse foundation powering reporting and better decisions, with on-site emphasis and limited remote days.

You will design ETL/ELT pipelines, integrate Oracle and ERP data, and partner with BI teams to deliver trusted data for analytics. This role requires 5+ years in data engineering and strong SQL skills.