Data Engineer — ETL, Warehouse, On-Site in Pittsburgh

ASHFORD CONNEX, LLC; Pittsburgh (Allegheny County); On-site; USD 110,000 - 160,000; Full time

Job summary

ASHFORD CONNEX, LLC in Pittsburgh, PA is seeking a Data Engineer to design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse. The role emphasizes Oracle data handling, SQL performance tuning, and collaboration with BI teams.

You will integrate Oracle and ERP data, monitor loads, and ensure data quality, with on-site work and occasional remote days. A strong foundation in data warehousing is essential.

Qualifications

• 5+ years in data engineering or related roles.
• Strong hands-on SQL development and performance tuning.
• Experience with Oracle databases and data warehousing basics.
• Ability to troubleshoot pipeline failures with minimal direction.
• Bachelor's degree or equivalent professional experience.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines to feed a data warehouse.
• Integrate data from Oracle, ERP systems, and other sources.
• Write and tune complex SQL queries and scripts.
• Monitor loads, diagnose failures, and resolve discrepancies.
• Document data flows and support warehouse architecture.

Skills

ETL pipelines

SQL development

Oracle databases

Data warehousing

Troubleshooting pipelines

Education

Bachelor's degree

Tools

SSIS

Informatica

Power BI

TimeXtender

WhereScape RED

Job description

ASHFORD CONNEX, LLC in Pittsburgh, PA is seeking a Data Engineer to design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse. The role emphasizes Oracle data handling, SQL performance tuning, and collaboration with BI teams.

You will integrate Oracle and ERP data, monitor loads, and ensure data quality, with on-site work and occasional remote days. A strong foundation in data warehousing is essential.