Data Engineer: Build Core Pipelines & Warehouse (On-Site)

Barrette Workforce Solutions, LLC; Pittsburgh (Allegheny County); On-site; USD 110,000 - 160,000; Full time

Job summary

Barrette Workforce Solutions, LLC in Pittsburgh, PA, is seeking a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines feeding an analytics-ready warehouse. You will integrate Oracle, Ross ERP, Dynamics 365 Finance & Operations, and other systems to power trusted reporting.

You’ll partner with BI developers and analysts, ensure data quality, monitor loads, and document data flows. This role is primarily on-site with limited remote days after ramp-up.

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

ETL / Data Pipelines

SQL proficiency

Data warehousing concepts

Education

Bachelor’s degree in a related discipline

Tools

Oracle Database

WhereScape RED

TimeXtender

Power BI

Informatica

SSIS

Dataverse

Lakehouse

Microsoft Fabric

Job description

Barrette Workforce Solutions, LLC in Pittsburgh, PA, is seeking a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines feeding an analytics-ready warehouse. You will integrate Oracle, Ross ERP, Dynamics 365 Finance & Operations, and other systems to power trusted reporting.

You’ll partner with BI developers and analysts, ensure data quality, monitor loads, and document data flows. This role is primarily on-site with limited remote days after ramp-up.