Data Engineer - ETL/Warehouse Architect (On-Site Pittsburgh)

Essenti Talent

Pittsburgh (Allegheny County)

On-site

USD 120,000 - 160,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

Essenti Talent is seeking a hands-on Data Engineer in Pittsburgh, PA to turn complex, disconnected data into reliable intelligence and power visible decision-making in a growing industrial environment.

You will own end-to-end ETL/ELT pipelines, integrate data from Oracle and ERP systems, optimize SQL queries, monitor data loads, and collaborate with BI to deliver trusted reporting data for stakeholders.

Qualifications

5+ years in data engineering, ETL development, or related role.
Strong hands-on SQL development and performance tuning.
Experience with Oracle databases and data warehousing fundamentals.
Ability to troubleshoot pipeline failures and data accuracy issues with minimal direction.
Bachelor’s degree in a related field 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.
Strengthen data quality through validation, logging, and error handling.
Partner with BI developers, analysts, and business stakeholders to deliver trusted reporting data.
Document data flows and transformation logic; contribute to warehouse architecture, dimensional modeling, and code reviews.