EngineerJobs.io
← Back to all jobs

Job Description

Aminov Search Partners is seeking a Data Engineer to help strengthen a manufacturing-focused data platform. This on-site role in Pittsburgh centers on designing and improving ETL/ELT data pipelines and enhancing an enterprise data warehouse with reliable data from ERP and finance systems.

You will work at the intersection of data integration and analytics readiness, connecting Oracle and multiple business systems so BI teams can deliver consistent reporting and insights.

Role Focus

  • Architect and refine ETL/ELT channels to support an expanding data warehouse infrastructure.
  • Integrate data from Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and multiple source platforms.
  • Build and optimize SQL queries, stored procedures, and performance-driven scripts.
  • Independently monitor, diagnose, and resolve issues in data loading processes.
  • Improve data integrity through verification practices, logging, and error management.
  • Partner with BI developers, analysts, and business stakeholders to provide dependable reporting data.
  • Document data processes and transformation logic, supporting warehouse architecture, dimensional modeling, and critical code reviews.

Requirements

  • 5+ years of experience in data engineering, ETL development, or a related field.
  • Hands-on SQL development with demonstrated performance optimization skills.
  • Experience with Oracle databases, plus a strong background in ETL/ELT and data warehousing.
  • Ability to troubleshoot pipeline issues and address data accuracy concerns with minimal guidance.
  • Bachelor’s degree in a related field, or equivalent professional experience.

Technologies

  • SQL, Oracle, ETL/ELT, stored procedures, SQL queries
  • Ross ERP, Microsoft Dynamics 365 Finance & Operations
  • WhereScape RED, TimeXtender, Microsoft Fabric, Lakehouse, Dataverse
  • SSIS, Informatica, Power BI, D365 Finance & Operations

Compensation

  • USD 120,000 per year

Location and Work Schedule

  • Pittsburgh, PA (on-site)
  • After an initial adjustment period, two flexible remote days per month

Helpful Background (Valuable Additional Experience)

  • Experience with WhereScape RED, TimeXtender, Microsoft Fabric, Lakehouse, or Dataverse.
  • Exposure to D365 Finance & Operations, SSIS, Informatica, Power BI, or DBA experience.
  • Background in dimensional modeling and data environments in manufacturing, mining, or industrial settings.

Similar Jobs