Data Engineer: ETL/SQL + Oracle | On-Site in Pittsburgh

Rare Bird Recruiting, LLC; Pittsburgh (Allegheny County); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Rare Bird Recruiting, LLC is seeking a hands-on Data Engineer in Pittsburgh, PA to build and optimize data pipelines and a robust data warehouse. You’ll transform disparate data into reliable analytics for smarter decisions and partner with BI to deliver trusted reporting data.

The role emphasizes SQL development, Oracle experience, and manufacturing-oriented data environments. On-site with two remote days per month after ramp-up, full-time employment.

Qualifications

• 5+ years in data engineering, ETL development, or a closely related role.
• Strong hands-on SQL development and performance-tuning skills.
• Experience with Oracle databases and sound ETL/ELT and data warehousing fundamentals.
• Ability to troubleshoot pipeline failures and data accuracy issues with minimal direction.
• Bachelor’s degree in a related discipline 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.

Skills

Data engineering

SQL development

ETL/ELT

Data warehousing

Problem solving

Education

Bachelor's degree or equivalent

Tools

Oracle DB

WhereScape RED

TimeXtender

SSIS

Informatica

Power BI

DBA experience

D365 Finance & Operations

Dataverse

Lakehouse

Microsoft Fabric

Job description

Rare Bird Recruiting, LLC is seeking a hands-on Data Engineer in Pittsburgh, PA to build and optimize data pipelines and a robust data warehouse. You’ll transform disparate data into reliable analytics for smarter decisions and partner with BI to deliver trusted reporting data.

The role emphasizes SQL development, Oracle experience, and manufacturing-oriented data environments. On-site with two remote days per month after ramp-up, full-time employment.