Pittsburgh On-Site Data Engineer: ETL & Data Warehouse Lead

Ilocatum

Pittsburgh (Allegheny County)

Hybrid

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

Ilocatum in Pittsburgh, PA, is seeking a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse. You will integrate data from Oracle, Ross ERP, and Microsoft Dynamics 365 Finance & Operations, writing and tuning complex SQL scripts for performance and reliability.

You will monitor data loads, diagnose failures, and strengthen data quality with logging and validation while collaborating with BI developers and business stakeholders on trusted

Qualifications

  • 5+ years in data engineering, ETL development, or 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
ETL/ELT
Data warehousing
Oracle databases
Troubleshooting pipelines
Data quality

Education

Bachelor’s degree or equivalent

Tools

WhereScape RED
TimeXtender
Microsoft Fabric
Lakehouse
Dataverse
D365 Finance & Operations
SSIS
Informatica
Power BI

Job description

Ilocatum in Pittsburgh, PA, is seeking a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse. You will integrate data from Oracle, Ross ERP, and Microsoft Dynamics 365 Finance & Operations, writing and tuning complex SQL scripts for performance and reliability.

You will monitor data loads, diagnose failures, and strengthen data quality with logging and validation while collaborating with BI developers and business stakeholders on trusted

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
Pittsburgh Data Engineer: ETL & Data Warehouse Specialist
Pittsburgh Data Engineer: ETL & Data Warehouse Specialist

Key People • Pittsburgh

On-site
USD 110,000 - 140,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 - 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/Warehouse Architect (On-Site Pittsburgh)
Data Engineer - ETL/Warehouse Architect (On-Site Pittsburgh)

Essenti Talent • Pittsburgh

On-site
USD 120,000 - 160,000
Data Engineer: Industrial Data Pipelines & Warehouse
Data Engineer: Industrial Data Pipelines & Warehouse

Connectly Recruiting • Pittsburgh

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

Top Echelon Software, LLC. • Pittsburgh

On-site
USD 110,000 - 160,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: ETL & Data Warehouse Lead (On-Site Pittsburgh)
Data Engineer: ETL & Data Warehouse Lead (On-Site Pittsburgh)

Markent Personnel, Inc. • Pittsburgh

Hybrid
USD 105,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