Data Engineer: ETL Pipelines & Warehouse Expert
Red Seal Recruiting Ltd.
A complete application in a minute
Tailored resume and cover letter, ready to send.
Job summary
Red Seal Recruiting Ltd. is seeking a hands-on Data Engineer in Pittsburgh, PA to design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse.
You will integrate data from Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and other systems to support reporting and decision-making. You will write and tune complex SQL queries, monitor data loads, and troubleshoot discrepancies while collaborating with BI developers and business stakeholders.
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 solid ETL/ELT 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.
- 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
Red Seal Recruiting Ltd. is seeking a hands-on Data Engineer in Pittsburgh, PA to design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse.
You will integrate data from Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and other systems to support reporting and decision-making. You will write and tune complex SQL queries, monitor data loads, and troubleshoot discrepancies while collaborating with BI developers and business stakeholders.
'/%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}
