Skip to main content

Data Engineer

Posted yesterday

affinity executive searchPittsburgh (PA)

SENIORITY

Senior

Apply (opens in a new tab)

About the role

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 OutOwn 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 SeeWhereScape RED or Time
  • Xtender; 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. Interested in making an impact? Apply today to learn more about this opportunity with our client.

Before you apply

Applying takes about a minute. These four things decide how fast it moves after that.

Your profile is current

It's what we read first. Occupations, seniority and locations matter more than a long history.

Two examples you can talk through

Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.

A number in mind

What you're on now and what would make you move. We negotiate better when we know both.

Your notice period

Employers plan around it, and it's the question that stalls offers most often.

Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.

More like this