Data Engineer: Build Enterprise Data Pipelines (On-Site)

Professional Recruiting Consultants, Inc.; Pittsburgh (Allegheny County); Hybrid; USD 90,000 - 140,000; Full time

Job summary

Professional Recruiting Consultants, Inc. is seeking a hands-on Data Engineer in Pittsburgh to turn complex, disconnected data into reliable intelligence.

This role builds the pipelines and warehouse foundations that power reporting and better business decisions for a growing industrial organization. You will own critical ETL/ELT pipelines, integrate Oracle and ERP data, write and tune SQL, monitor loads, and collaborate with BI teams to deliver trusted data assets.

Qualifications

• 5+ years in data engineering or closely related roles.
• Strong SQL development and performance-tuning skills.
• Experience with Oracle databases and data warehousing fundamentals.

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.

Skills

SQL development

ETL/ELT development

Data warehousing fundamentals

Oracle databases

Troubleshooting pipelines

Bachelor's degree

Education

Bachelor's degree or equivalent

Tools

Oracle DBMS

SSIS

Informatica

Power BI

WhereScape RED

TimeXtender

Microsoft Fabric

Dataverse

D365 Finance & Operations

Job description

Professional Recruiting Consultants, Inc. is seeking a hands-on Data Engineer in Pittsburgh to turn complex, disconnected data into reliable intelligence.

This role builds the pipelines and warehouse foundations that power reporting and better business decisions for a growing industrial organization. You will own critical ETL/ELT pipelines, integrate Oracle and ERP data, write and tune SQL, monitor loads, and collaborate with BI teams to deliver trusted data assets.