Data Engineer: Build ETL Pipelines & Data Warehouse
6 Degrees Search
A complete application in a minute
Tailored resume and cover letter, ready to send.
Job summary
6 Degrees Search is seeking a hands-on Data Engineer in Pittsburgh to design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse. You will integrate Oracle, Ross ERP, Dynamics 365 Finance & Operations, and other systems, writing and tuning complex SQL for performance and reliability.
You will monitor loads, diagnose failures, and reinforce data quality while partnering with BI developers and business stakeholders to deliver trusted reporting data.
Qualifications
- 5+ years in data engineering, ETL development or related role.
- Strong SQL development and performance-tuning skills.
- Experience with Oracle databases and data warehousing fundamentals.
Responsibilities
- Design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse.
- Integrate data from Oracle, Ross ERP, 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 stakeholders to deliver trusted reporting data.
- Document data flows and transformation logic; contribute to warehouse architecture and modeling.
Skills
Education
Tools
Job description
6 Degrees Search is seeking a hands-on Data Engineer in Pittsburgh to design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse. You will integrate Oracle, Ross ERP, Dynamics 365 Finance & Operations, and other systems, writing and tuning complex SQL for performance and reliability.
You will monitor loads, diagnose failures, and reinforce data quality while partnering with BI developers and business stakeholders to deliver trusted reporting data.
'/%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}
