Data Engineer

Aminov Search Partners LLC; Pittsburgh (Allegheny County); Hybrid; USD 108,000 - 132,000; Full time

Benefits offered by this job

Two remote days per month

On-site Pittsburgh, PA

Job summary

Aminov Search Partners LLC is hiring a Data Engineer to build and improve ETL/ELT pipelines and a data warehouse used for reporting in a manufacturing environment. The role focuses on data from Oracle and ERP/finance systems to ensure BI teams have reliable, accurate data.

The position requires deep SQL and Oracle experience, ownership of loading performance, and documentation of transformations and architecture decisions. Pittsburgh onsite with limited monthly remote days.

Qualifications

• 5+ years of experience in data engineering, ETL development, or related field.
• Hands-on SQL development with strong performance optimization.
• Proven Oracle database experience, ETL/ELT and data warehousing background.
• Ability to diagnose and resolve pipeline issues with minimal guidance.
• Bachelor’s degree in related field or equivalent experience.

Responsibilities

• Architect and refine ETL/ELT channels expanding an established data warehouse.
• Integrate data from Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and multiple sources.
• Develop and optimize advanced SQL queries, stored procedures, and performance-driven scripts.
• Independently manage and troubleshoot data loading processes and prompt issue diagnosis.
• Strengthen data integrity with verification, logging, and error management.
• Collaborate with BI developers, analysts, and business experts to provide dependable reporting data.
• Document complex data processes and transformation logic for warehouse architecture and dimensional modeling.

Skills

SQL development

Oracle

ETL/ELT

Data warehousing

Performance optimization

Issue diagnosis

Education

Bachelor’s degree

Tools

WhereScape RED

TimeXtender

Microsoft Fabric

Lakehouse

Dataverse

SSIS

Informatica

Power BI

Job description

Aminov Search Partners is hiring a Data Engineer to help build and continuously improve ETL/ELT pipelines and strengthen a data warehouse used for reporting and analytics in a manufacturing environment. The role centers on integrating data from Oracle and ERP and finance systems so that BI teams and business stakeholders can rely on consistent, accurate data.

This Pittsburgh-based position supports an onsite workflow, with flexibility for two remote days each month after an initial adjustment period. The role is designed for someone with deep SQL and Oracle experience, who can own data loading performance, troubleshoot issues quickly, and document transformations and architecture decisions.

Responsibilities

• Architect and refine ETL/ELT channels that expand and improve an established data warehouse infrastructure.
• Integrate data from Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and multiple source platforms.
• Develop and optimize advanced SQL queries, stored procedures, and performance-driven scripts.
• Independently manage and troubleshoot data loading processes, including prompt issue diagnosis and resolution.
• Strengthen data integrity using verification, comprehensive logging, and effective error management.
• Work with BI developers, analysts, and business experts to provide dependable reporting data.
• Document complex data processes and transformation logic, contributing to warehouse architecture, dimensional modeling, and code assessments.

Requirements

• 5+ years of experience in data engineering, ETL development, or a related field.
• Hands-on SQL development experience with strong performance optimization skills.
• Proven Oracle database experience, plus a solid foundation in ETL/ELT and data warehousing.
• Ability to diagnose and resolve pipeline issues and data accuracy concerns with minimal guidance.
• Bachelor’s degree in a related field (or equivalent professional experience).

Technologies

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

Compensation: USD 120,000 per year.

Valuable Additional Experience

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

Working Conditions

• On-site role in Pittsburgh, PA.
• Two flexible remote days monthly after an initial adjustment period.