Data Engineer - On-Site Pittsburgh | ETL/ELT & DW

Top Echelon Software, LLC; Pittsburgh (Allegheny County); On-site; USD 120,000 - 160,000; Full time

Job summary

Top Echelon Software, LLC is seeking a hands-on Data Engineer to build and optimize ETL/ELT pipelines and to shape the data foundation for decision-making. You will work with Oracle, Ross ERP, and Dynamics 365 Finance & Operations to deliver analytics-ready data and reliable reporting.

You’ll collaborate with BI developers and analysts, tune SQL queries for performance, and ensure data quality across the enterprise data warehouse in a manufacturing-oriented environment.

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

SQL development

Performance tuning

Data warehousing fundamentals

Troubleshooting pipelines

Team collaboration

Education

Bachelor's degree in related discipline

Tools

WhereScape RED

TimeXtender

SSIS

Informatica

Power BI

Dataverse

D365 Finance & Operations

Ross ERP

Oracle

Job description

Top Echelon Software, LLC is seeking a hands-on Data Engineer to build and optimize ETL/ELT pipelines and to shape the data foundation for decision-making. You will work with Oracle, Ross ERP, and Dynamics 365 Finance & Operations to deliver analytics-ready data and reliable reporting.

You’ll collaborate with BI developers and analysts, tune SQL queries for performance, and ensure data quality across the enterprise data warehouse in a manufacturing-oriented environment.