Data Engineer: Build Industrial Data Pipelines

RON SUNSHINE ASSOCIATES LLC

Pittsburgh (Allegheny County)

On-site

USD 110,000 - 150,000

Full time

13 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ron Sunshine Associates LLC in Pittsburgh, PA is seeking a hands-on Data Engineer to build pipelines and a reliable data warehouse foundation that powers reporting and better business decisions.

The role emphasizes ETL/ELT pipelines, integration of Oracle, Ross ERP, and Dynamics 365 Finance & Operations, with strong SQL development and data quality practices. On-site work with some remote days after ramp-up are available.

Qualifications

  • 5+ years of experience 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.

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

Skills

SQL development
Performance tuning
ETL/ELT concepts
Data warehousing fundamentals
Problem solving

Education

Bachelor's degree in a related discipline

Tools

WhereScape RED
TimeXtender
Microsoft Fabric
Lakehouse
Dataverse
D365 Finance & Operations
SSIS
Informatica
Power BI

Job description

Ron Sunshine Associates LLC in Pittsburgh, PA is seeking a hands-on Data Engineer to build pipelines and a reliable data warehouse foundation that powers reporting and better business decisions.

The role emphasizes ETL/ELT pipelines, integration of Oracle, Ross ERP, and Dynamics 365 Finance & Operations, with strong SQL development and data quality practices. On-site work with some remote days after ramp-up are available.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer — Build ETL Pipelines for Industrial Analytics
Data Engineer — Build ETL Pipelines for Industrial Analytics

ExcelliSearch, Inc. • Pittsburgh

On-site
USD 110,000 - 140,000
Data Engineer - On-Site: Build Enterprise Data Pipelines
Data Engineer - On-Site: Build Enterprise Data Pipelines

Talent Solutions Partners • Pittsburgh

Hybrid
USD 120,000 - 160,000
Data Engineer: Build ETL Pipelines & Data Warehouse
Data Engineer: Build ETL Pipelines & Data Warehouse

Management Performance Associates • Pittsburgh

On-site
USD 110,000 - 150,000
Data Engineer: Build Enterprise Data Pipelines (On-Site)
Data Engineer: Build Enterprise Data Pipelines (On-Site)

Professional Recruiting Consultants, Inc. • Pittsburgh

Hybrid
USD 90,000 - 140,000
Data Engineer: Enterprise Pipelines (On-Site, Pittsburgh)
Data Engineer: Enterprise Pipelines (On-Site, Pittsburgh)

Workforce Recruiter • Pittsburgh

Hybrid
USD 120,000 - 160,000
Data Engineer: Industrial Data Pipelines & Warehouse
Data Engineer: Industrial Data Pipelines & Warehouse

Connectly Recruiting • Pittsburgh

On-site
USD 110,000 - 150,000
Data Engineer: Build Industrial Data Pipelines (Pittsburgh)
Data Engineer: Build Industrial Data Pipelines (Pittsburgh)

Talent With Heart • Pittsburgh

Hybrid
USD 120,000 - 150,000
Data Engineer: Industrial Pipelines & Analytics (On-Site)
Data Engineer: Industrial Pipelines & Analytics (On-Site)

CareerNerds, LLC • Pittsburgh

Hybrid
USD 100,000 - 140,000
Data Engineer: ETL Pipelines & Warehouse Expert
Data Engineer: ETL Pipelines & Warehouse Expert

Red Seal Recruiting • Pittsburgh

Hybrid
USD 110,000 - 160,000
Data Engineer On-site ETL Pipelines for Industrial Analytics
Data Engineer On-site ETL Pipelines for Industrial Analytics

Client Growth Resources, Inc • Pittsburgh

Hybrid
USD 100,000 - 150,000