Data Engineer

ASHFORD CONNEX, LLC

Pittsburgh (Allegheny County)

On-site

USD 110,000 - 160,000

Full time

11 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

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

Data Engineer

Build the Data Foundation Behind Smarter Decisions

Pittsburgh, PA | Full-Time | Primarily On-Site

Our client is seeking a hands-on Data Engineer who loves turning complex, disconnected data into reliable intelligence. This is an opportunity to make a visible impact on a growing industrial organization - building the pipelines and warehouse foundations that power meaningful reporting and better business decisions.

Why This Opportunity Stands Out

Own critical data pipelines from source systems to analytics-ready datasets.

Work closely with a business intelligence team on high-impact reporting initiatives.

Bring your SQL and Oracle expertise to real operational challenges in a manufacturing-oriented environment.

What You'll Do

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, dimensional modeling, and code reviews.

What You Bring

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.

Ability to troubleshoot pipeline failures and data accuracy issues with minimal direction.

Bachelor's degree in a related discipline or equivalent professional experience.

Extra Experience We'd Love to See

WhereScape RED or TimeXtender; Microsoft Fabric, Lakehouse, or Dataverse.

D365 Finance & Operations, SSIS, Informatica, Power BI, or DBA experience.

Dimensional modeling and manufacturing, mining, or industrial data environments.

Work Arrangement

This position is based on-site in Pittsburgh, with two remote days per month available after the initial ramp-up period.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Connectly Recruiting • Pittsburgh

On-site
USD 110,000 - 150,000
Data Engineer
Data Engineer

KLA Industries • Pittsburgh

Hybrid
USD 90,000 - 140,000
Data Engineer
Data Engineer

True North Consultants, Inc. • Pittsburgh

Hybrid
USD 95,000 - 140,000
Data Engineer
Data Engineer

Franklin Executive Solutions, LLC • Pittsburgh

On-site
USD 110,000 - 160,000
Data Engineer
Data Engineer

Launching Point • Pittsburgh

Hybrid
USD 110,000 - 140,000
Data Engineer
Data Engineer

Soap Creek Resources • Pittsburgh

On-site
USD 90,000 - 140,000
Data Engineer
Data Engineer

Management Performance Associates • Pittsburgh

On-site
USD 110,000 - 150,000
Data Engineer
Data Engineer

Client Growth Resources, Inc • Pittsburgh

Hybrid
USD 100,000 - 150,000
Data Engineer
Data Engineer

Joseph Michaels International • Pittsburgh

Hybrid
USD 110,000 - 150,000
Data Engineer
Data Engineer

Eckceptional Search • Pittsburgh

Hybrid
USD 110,000 - 160,000