On-Site Data Engineer - ETL & SQL for DW Foundations

Top Dog Recruiting

Pittsburgh (Allegheny County)

Hybrid

USD 95,000 - 135,000

Full time

10 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Top Dog Recruiting in Pittsburgh is seeking a hands-on Data Engineer who turns disconnected data into reliable intelligence. You will design and build ETL/ELT pipelines feeding an enterprise data warehouse and collaborate with BI to power trusted reporting.

This full-time, on-site role offers optional remote days after ramp-up; you will work with Oracle, ERP systems, and manufacturing data. Strong SQL skills and data warehousing fundamentals are essential to deliver accurate data for decision

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.
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.