Data Engineer — ETL/Warehouse for Industrial Ops (On-Site)
Hire Consulting Services
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
Hire Consulting Services in Pittsburgh, PA is seeking a hands-on Data Engineer who loves turning complex, disconnected data into reliable intelligence. Build pipelines and warehouse foundations that power reporting and better business decisions in a growing industrial environment.
You'll design, build, and optimize ETL/ELT pipelines, integrate Oracle and ERP systems, and collaborate with BI teams to deliver trusted data for analytics.
Qualifications
- 5+ years in data engineering, ETL development, or a closely related role.
- Strong hands-on SQL development and performance-tuning.
- Experience with Oracle databases 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
Education
Tools
Job description
Hire Consulting Services in Pittsburgh, PA is seeking a hands-on Data Engineer who loves turning complex, disconnected data into reliable intelligence. Build pipelines and warehouse foundations that power reporting and better business decisions in a growing industrial environment.
You'll design, build, and optimize ETL/ELT pipelines, integrate Oracle and ERP systems, and collaborate with BI teams to deliver trusted data for analytics.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
