Data Platform Engineer: ETL, DW, SQL (On-Site PA)

Sterling St James LLC

Pittsburgh (Allegheny County)

Hybrid

USD 110,000 - 140,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Sterling St James Inc. in Pittsburgh, PA is seeking a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines that feed an enterprise data warehouse. The role focuses on turning complex, disparate data into reliable intelligence for smarter decisions.

You will integrate data from Oracle, Ross ERP, Dynamics 365 Finance & Operations, and other systems, writing and tuning SQL to ensure performance and reliability. On-site with two remote days per month after ramp-up.

Qualifications

  • 5+ years in data engineering, ETL development or related role.
  • Strong hands-on SQL development and performance tuning.
  • Experience with Oracle databases and data warehousing fundamentals.
  • Ability to troubleshoot pipeline failures and data accuracy issues.

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, procedures, and scripts for performance.
  • Monitor data loads, diagnose failures, and resolve discrepancies.
  • Strengthen data quality through validation, logging, and error handling.
  • Partner with BI developers, analysts, and stakeholders to deliver trusted reporting data.
  • Document data flows and transformation logic; contribute to warehouse architecture and modeling.

Skills

SQL development
ETL/ELT
Data warehousing
Troubleshooting

Education

Bachelor's degree

Tools

Oracle databases
WhereScape RED
TimeXtender
Informatica
Power BI

Job description

Sterling St James Inc. in Pittsburgh, PA is seeking a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines that feed an enterprise data warehouse. The role focuses on turning complex, disparate data into reliable intelligence for smarter decisions.

You will integrate data from Oracle, Ross ERP, Dynamics 365 Finance & Operations, and other systems, writing and tuning SQL to ensure performance and reliability. On-site with two remote days per month after ramp-up.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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

Top Echelon Software, LLC • Pittsburgh

On-site
USD 120,000 - 160,000
Data Engineer - ETL & DW Lead (On-Site Pittsburgh)
Data Engineer - ETL & DW Lead (On-Site Pittsburgh)

Launching Point • Pittsburgh

Hybrid
USD 110,000 - 140,000
Data Engineer: Build ETL Pipelines & Data Warehouse
Data Engineer: Build ETL Pipelines & Data Warehouse

Management Performance Associates • Pittsburgh

On-site
USD 110,000 - 150,000
Pittsburgh Data Engineer: ETL & Warehouse (On-Site)
Pittsburgh Data Engineer: ETL & Warehouse (On-Site)

Sun Recruiting, Inc. • Pittsburgh

On-site
USD 110,000 - 150,000
Data Engineer: Enterprise Pipelines (On-Site, Pittsburgh)
Data Engineer: Enterprise Pipelines (On-Site, Pittsburgh)

Workforce Recruiter • Pittsburgh

Hybrid
USD 120,000 - 160,000
Data Engineer — ETL & Warehouse On-Site Pittsburgh
Data Engineer — ETL & Warehouse On-Site Pittsburgh

Genie Matthews and Associates • Pittsburgh

Hybrid
USD 110,000 - 150,000
Data Engineer - ETL & Data Warehouse Maestro (Pittsburgh)
Data Engineer - ETL & Data Warehouse Maestro (Pittsburgh)

Ashton North LLC • Pittsburgh

Hybrid
USD 110,000 - 140,000
Data Engineer - On-Site: Build Enterprise Data Pipelines
Data Engineer - On-Site: Build Enterprise Data Pipelines

Talent Solutions Partners • Pittsburgh

Hybrid
USD 120,000 - 160,000
Data Engineer - On-Site Pittsburgh: Core Pipeline Builder
Data Engineer - On-Site Pittsburgh: Core Pipeline Builder

SPG • Pittsburgh

On-site
USD 100,000 - 140,000
Data Engineer - ETL/Warehouse Architect (On-Site Pittsburgh)
Data Engineer - ETL/Warehouse Architect (On-Site Pittsburgh)

Essenti Talent • Pittsburgh

On-site
USD 120,000 - 160,000