Data Engineer — On-Site in Pittsburgh with Limited Remote Days

Confident Search Consultants

Pittsburgh (Allegheny County)

Hybride

USD 110 000 - 150 000

Plein temps

Il y a 2 jours

Soyez parmi les premiers à postuler

Une candidature complète en une minute

Un CV et une lettre de motivation personnalisés, prêts à envoyer.

Passez les filtres ATS

Résumé du poste

Confident Search Consultants in Pittsburgh is seeking a hands-on Data Engineer to design and operate ETL/ELT pipelines, building a reliable data warehouse and enabling smarter decision-making through robust reporting.

You will work with Oracle, Ross ERP, and Microsoft Dynamics 365 Finance & Operations data, writing optimized SQL and ensuring data quality in a manufacturing-focused environment with close collaboration across BI teams.

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.
Bachelor’s degree in a related discipline or equivalent professional experience.

Responsabilités

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.