Data Engineer: ETL & Data Warehouse Lead (Pittsburgh)

Modern Machining Solutions Inc

Pittsburgh (Allegheny County)

On-site

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

Modern Machining Solutions Inc. is seeking a hands-on Data Engineer to turn complex, disconnected data into reliable intelligence. You’ll build pipelines and the warehouse foundations that power reporting and business decisions, with a focus on manufacturing data.

Based on-site in Pittsburgh, PA, with two remote days per month after ramp-up. You’ll work with Oracle, Ross ERP, Dynamics 365 Finance & Operations, and BI developers to deliver trusted data for analytics.

Qualifications

Bachelor's degree in a related field or equivalent professional experience.
5+ years in data engineering, ETL/ELT, or a closely related role.
Strong hands-on SQL development and performance-tuning skills.
Experience with Oracle databases and data warehousing fundamentals.
Ability to troubleshoot pipeline failures and data accuracy issues 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.
Document data flows and transformation logic; contribute to warehouse architecture and data modeling.