Data Engineer — Build ETL Pipelines for Industrial Analytics

ExcelliSearch, Inc.; Pittsburgh (Allegheny County); On-site; USD 110,000 - 140,000; Full time

Job summary

ExcelliSearch, Inc. in Pittsburgh, PA is seeking a hands-on Data Engineer to build data pipelines and a robust warehouse foundation for reliable reporting and smarter decisions. This is a full-time, primarily on-site role with two remote days per month after ramp-up.

You will work with Oracle, Ross ERP, Dynamics 365 Finance & Operations, and BI stakeholders to deliver trusted data. Strong SQL and data warehousing fundamentals are essential.

Qualifications

• 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.

Responsibilities

• 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 and modeling.

Skills

SQL development

Performance tuning

Oracle databases

ETL/ELT

Data warehousing

Data quality

Data integration

Education

Bachelor’s degree or equivalent

Tools

WhereScape RED

TimeXtender

Microsoft Fabric

Lakehouse

Dataverse

Job description

ExcelliSearch, Inc. in Pittsburgh, PA is seeking a hands-on Data Engineer to build data pipelines and a robust warehouse foundation for reliable reporting and smarter decisions. This is a full-time, primarily on-site role with two remote days per month after ramp-up.

You will work with Oracle, Ross ERP, Dynamics 365 Finance & Operations, and BI stakeholders to deliver trusted data. Strong SQL and data warehousing fundamentals are essential.