Data Engineer — ETL & Warehouse On-Site Pittsburgh

Genie Matthews and Associates; Pittsburgh (Allegheny County); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Genie Matthews and Associates in Pittsburgh, PA is seeking a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines that feed an enterprise data warehouse. You will integrate Oracle, Ross ERP, and Dynamics 365 Finance & Operations, while writing high-performance SQL and ensuring data reliability.

The role is primarily on-site with two remote days per month after ramp-up, offering a clear impact on reporting and business decisions for a manufacturing-oriented organization.

Qualifications

• 5+ years in data engineering or related roles.
• Strong SQL development and performance tuning.
• Experience with Oracle databases and ETL/ELT fundamentals.
• Bachelor’s degree or equivalent professional experience.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines to feed the 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.
• Monitor data loads, diagnose failures, and resolve discrepancies independently.
• Strengthen data quality via validation, logging, and error handling.
• Collaborate with BI developers, analysts, and stakeholders to deliver trusted reporting data.
• Document data flows and transformation logic; contribute to warehouse architecture and dimensional modeling.

Skills

SQL development

Data integration

ETL/ELT

Education

Bachelor’s degree

Tools

Oracle databases

WhereScape RED

TimeXtender

SSIS

Job description

Genie Matthews and Associates in Pittsburgh, PA is seeking a hands-on Data Engineer to design, build, and optimize ETL/ELT pipelines that feed an enterprise data warehouse. You will integrate Oracle, Ross ERP, and Dynamics 365 Finance & Operations, while writing high-performance SQL and ensuring data reliability.

The role is primarily on-site with two remote days per month after ramp-up, offering a clear impact on reporting and business decisions for a manufacturing-oriented organization.