Data Engineer: Industrial Pipelines & Analytics (On-Site)

CareerNerds, LLC; Pittsburgh (Allegheny County); Híbrido; USD 100.000 - 140.000; Jornada completa

Descripción de la vacante

CareerNerds, LLC in Pittsburgh is seeking a hands-on Data Engineer to turn disconnected data into reliable intelligence. You will design and build ETL/ELT pipelines and contribute to the data warehouse foundation that powers reporting and better business decisions.

You’ll work with Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and other systems, tuning SQL, validating data loads, and collaborating with BI analysts to deliver trusted data for dashboards and analyses.

Formación

• 5+ years in data engineering, ETL development, or related role.
• Strong hands-on SQL development and performance-tuning skills.
• Experience with Oracle databases 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.

Responsabilidades

• Design, build, and optimize ETL/ELT pipelines feeding an enterprise data warehouse.
• Integrate data from Oracle, Ross ERP, 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 and dimensional modeling.

Conocimientos

SQL development

Oracle databases

ETL/ELT

Data warehousing fundamentals

Educación

Bachelor's degree

Herramientas

WhereScape RED

TimeXtender

Microsoft Fabric

Lakehouse

Dataverse

D365 Finance & Operations

SSIS

Informatica

Power BI

Descripción del empleo

CareerNerds, LLC in Pittsburgh is seeking a hands-on Data Engineer to turn disconnected data into reliable intelligence. You will design and build ETL/ELT pipelines and contribute to the data warehouse foundation that powers reporting and better business decisions.

You’ll work with Oracle, Ross ERP, Microsoft Dynamics 365 Finance & Operations, and other systems, tuning SQL, validating data loads, and collaborating with BI analysts to deliver trusted data for dashboards and analyses.