Industrial Data Engineer — ETL Pipelines & Data Warehouse

True North Consultants, Inc.; Pittsburgh (Allegheny County); Hybrid; USD 95,000 - 140,000; Full time

Job summary

True North Consultants, Inc. in Pittsburgh is seeking a hands-on Data Engineer to turn disconnected data into reliable intelligence, build pipelines and data warehouse foundations that power reporting and decisions.

The role collaborates with BI teams, uses Oracle, Ross ERP, Dynamics 365 Finance & Operations, and SQL to deliver trusted data that informs business choices in a manufacturing-oriented environment.

Qualifications

• 5+ years in data engineering, ETL development or a closely related role.
• Strong hands-on SQL development and performance tuning.
• Experience with Oracle databases and data warehousing fundamentals.
• Ability to troubleshoot pipeline failures 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

Oracle databases

ETL/ELT fundamentals

Data warehousing fundamentals

Education

Bachelor’s degree

Tools

WhereScape RED

TimeXtender

SSIS

Informatica

Power BI

DBA experience

Microsoft Fabric

Lakehouse

Dataverse

D365 Finance & Operations

Job description

True North Consultants, Inc. in Pittsburgh is seeking a hands-on Data Engineer to turn disconnected data into reliable intelligence, build pipelines and data warehouse foundations that power reporting and decisions.

The role collaborates with BI teams, uses Oracle, Ross ERP, Dynamics 365 Finance & Operations, and SQL to deliver trusted data that informs business choices in a manufacturing-oriented environment.