Data Engineer
Job Description
Aminov Search Partners is hiring a Data Engineer to help build trustworthy data pipelines and strengthen an analytics-ready data warehouse for a manufacturing environment. This onsite role in Pittsburgh pairs deep hands-on engineering with close collaboration with BI developers, analysts, and business experts to support reporting and analytics that teams can rely on.
What you’ll do
- Architect and continuously improve ETL/ELT channels that support an expansive data warehouse infrastructure.
- Integrate and unify data from Oracle and ERP and finance systems including Ross ERP and Microsoft Dynamics 365 Finance & Operations, plus additional source platforms.
- Develop and refine advanced SQL queries, stored procedures, and performance-focused scripts to keep data processing efficient.
- Own data loading processes end to end by diagnosing failures and resolving issues quickly and independently.
- Maintain data integrity using verification practices, strong logging, and clear error management.
- Work with BI developers, analysts, and business stakeholders to deliver dependable datasets for reporting and analytics.
- Document complex data processes and transformation logic while contributing to warehouse architecture, dimensional modeling, and code reviews.
What you bring
- 5+ years of experience in data engineering, ETL development, or a closely related area.
- Strong, hands-on SQL development with proven attention to performance optimization.
- Working knowledge of Oracle databases and solid experience across 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.
Tools you may work with
You’ll likely engage with SQL, Oracle, ETL/ELT, Ross ERP, Microsoft Dynamics 365 Finance & Operations, stored procedures, and performance-driven scripting. Additional technologies include WhereScape RED, TimeXtender, Microsoft Fabric, Lakehouse, Dataverse, SSIS, Informatica, and Power BI, including D365 Finance & Operations and related DBA experience where applicable.
Valuable additional experience
- Experience with WhereScape RED, TimeXtender, Microsoft Fabric, Lakehouse, or Dataverse.
- Familiarity with D365 Finance & Operations, SSIS, Informatica, Power BI, or DBA experience.
- Background in dimensional modeling and data environments within manufacturing, mining, or industrial settings.
Location and schedule
This position is onsite in Pittsburgh, PA. After an initial adjustment period, you can expect two flexible remote days monthly.
Compensation
USD 120,000 per year.