On-Site Data Engineer — ETL Pipelines for Industrial Analytics

United Future

Pittsburgh (Allegheny County)

Hybrid

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

United Future seeks a hands-on Data Engineer in Pittsburgh to design, build, and optimize ETL/ELT pipelines that feed an enterprise data warehouse. You will integrate Oracle, Ross ERP, and other systems while ensuring data quality and performance.

You’ll partner with BI developers and analysts to deliver trusted reporting data, monitor loads, troubleshoot issues, and document transformation logic. This on-site role offers two remote days per month after ramp-up.

Qualifications

5+ years in data engineering, ETL development, or related role.
Strong SQL development and performance tuning skills.
Experience with Oracle databases and ETL/ELT and data warehousing fundamentals.
Ability to troubleshoot pipeline failures with minimal direction.

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.