- Field
- Software engineering
- Location
- Pittsburgh, PA
- Work model
- Onsite
- Level
- Mid
- Pay
- $120k to $130k
About the role
Work closely with a business intelligence team on high-impact reporting initiatives.
What you would own
- 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.
What they are looking for
- 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.
- Extra Experience We'd Love to See WhereScape RED or TimeXtender; Microsoft Fabric, Lakehouse, or Dataverse.
- D365 Finance & Operations, SSIS, Informatica, Power BI, or DBA experience.
- Dimensional modeling and manufacturing, mining, or industrial data environments.
- Work Arrangement This position is based on-site in Pittsburgh, with two remote days per month available after the initial ramp-up period.
- Interested in making an impact?
Everything above is the hiring company’s own words, with the company name taken out. The name, the team, and the interview steps come with the first conversation.